Help setting postgresql on manjaro

gnome

#1

Hello i’am new on this forum and newbie user on manjaro that i love so much.
since 2 days i am trying to setup postgresql but i am having a technical problem with this:

psql: n’a pas pu se connecter au serveur : Aucun fichier ou dossier de ce type
Le serveur est-il actif localement et accepte-t-il les connexions sur la
socket Unix « /run/postgresql/.s.PGSQL.5432 » ?

That’s mean : can’t connect to a server because no file or folder for this type.
are you sure that server is active locally and accept connection from socket Unix …

Note: i have install postgresql like this { ```
sudo pacman -S postgresql

sudo su postgres -l

initdb --locale $LANG -E UTF8 -D ‘/var/lib/postgres/data/’

sudo systemctl enable --now postgresql.service

the result:
Job for postgresql.service failed because the control process exited with error code.
See "systemctl status postgresql.service" and "journalctl -xe" for details
.
please some one can give me he's postgresql config for me. trust me i have been trying since few days now and no way to find it out.
iam on MANJARO 18 WITH GNOME VERSION.

SORRY ABOUT MY ENGLISH I AM FRENCH GUY :thinking: :hot_face:

#2

But when i type my root password ? he don’t recognize my password. As i know i haven’t before the postgres database with password:

#1) Respectez la vie privée des autres.
#2) Réfléchissez avant d'utiliser le clavier.
#3) De grands pouvoirs confèrent de grandes responsabilités.

[sudo] Mot de passe de postgres : Sorry , try again.
I don’t know how to initialize the database password ? grrrr why they don’t do thing’s easy to do. they can’t try do it simply ? for other people who don’t speak ,or understand good english. it’s too hard to find it out.
sql lite is easy to set up but am a rails developer and i need postgres for deployment .
i need help for


#3

Use a virtual machine with an OS which you use for deployment.

Set up PostgreSQL in that OS and you should find it

rather than adapting to the Arch way of leaving you in control of your software and services.

Or, read the Arch wiki:

https://wiki.archlinux.org/index.php/PostgreSQL


closed #4

This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.