Drop Down MenusCSS Drop Down MenuPure CSS Dropdown Menu

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
[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.


Popular posts from this blog

rman interview and scenario based questions and answer and also rman(backup and recovery) discussions panel

How to Get Table Size, Database Size, Indexes Size, schema Size, Tablespace Size, column Size in PostgreSQL Database

How to find the server is whether standby (slave) or primary(master) in Postgresql replication ?

7 Steps to configure BDR replication in postgresql

PostgreSQL pgBadger