Postgresql Error: psql: could not connect to server: No such file or directory Is the server running locally and accepting connections on Unix domain socket "/tmp/.s.PGSQL.5432"?
Cause: The postmaster or PostgreSQL's server daemon process is not running.
Solution:Typically this error means PostgreSQL is not currently running on the system you are logged into. You will need to start the daemon, which is typically done through your distribution's init system.
The easiest way to determine if PostgreSQL is running is to look for it using ps.
Solution:Typically this error means PostgreSQL is not currently running on the system you are logged into. You will need to start the daemon, which is typically done through your distribution's init system.
The easiest way to determine if PostgreSQL is running is to look for it using ps.
[nijam@host:~]$ ps -ef | grep post
postgres 4335 2.4 27704 2936 14:47 /usr/bin/postmaster -p 5432 -D /var/lib/pgsql/data
postgres 4337 0.0 9972 548 14:47 postgres: logger process
postgres 4339 0.0 27704 804 14:47 postgres: writer process
postgres 4340 0.0 10972 544 14:47 postgres: stats buffer process
postgres 4341 0.0 10148 668 14:47 postgres: stats collector process
nijam 4346 0.0 3912 676 14:47 grep post
Which as you can see means PostgreSQL is running on my local system. If we had received no results or just the final result line then we would know for certain that it is not running on this system.
Comments
Post a Comment