Indagamos por todo el mundo on line para traerte la respuesta para tu duda, si continúas con preguntas puedes dejar tu pregunta y responderemos con mucho gusto.
Ejemplo 1: no se pudo conectar al servidor: no existe tal archivo o directorio. ¿El servidor se está ejecutando localmente y acepta conexiones en el socket de dominio Unix “/tmp/.s.PGSQL.5432”?
$ rm /usr/local/var/postgres/postmaster.pid
$ brew services restart postgresql
# Think to restart your terminal (cmd + q on macOS)Ejemplo 2: psql: no se pudo conectar al servidor: no existe tal archivo o directorio. ¿El servidor se está ejecutando localmente y acepta conexiones en el socket de dominio Unix “/var/run/postgresql/.s.pgsql.5432”?
The error states that the psql utility can't find the socket to connect to your database server. Either you don't have the database service running in the background,or the socket is located elsewhere,or perhaps the pg_hba.conf needs to be fixed.
Step 1: Verify that the databaseis running
The command may vary depending on your operating system. But on most *ix systems the following would work, it will search for postgres among all running processes
ps -ef | grep postgres
On my system, mac osx, this spits out501408102Jul15 ?? 0:21.63/usr/local/opt/postgresql/bin/postgres -D /usr/local/var/postgres -r /usr/local/var/postgres/server.log
The lastcolumn shows the command used tostart the server,and the options.
You can look at all the options available tostart the postgres server using the following.
man postgres
From there, you'd see that the options -D and -r are respectively the datadir & the logfilename.
Step 2: If the postgres service is running
Use find to search for the location of the socket, which should be somewhere in the /tmp
sudo find /tmp/ -name .s.PGSQL.5432
If postgres is running and accepting socket connections, the above should tell you the location of the socket. On my machine, it turned out to be:
/tmp/.s.PGSQL.5432
Then, try connecting via psql using this file's location explicitly, eg.
psql -h /tmp/ dbname
Step 3: If the service is running but you don't see a socket
If you can't find the socket, but see that the service is running, Verify that the pg_hba.conf file allows local sockets.Browseto the datadir and you should find the pg_hba.conf file.Bydefault, near the bottom of the file you should see the followinglines:
# "local" is for Unix domain socket connections onlylocalallall trust
If you don't see it, you can modify the file,and restart the postgres service.¡Haz clic para puntuar esta entrada!
(Votos: 0 Promedio: 0)