Re: Error when starting postgres database!!

Hi,

I'm facing an error in starting my postgresql database. The error is as
shown below:

bash-4.1$ psql
psql: could not connect to server: No such file or directory
Is the server running locally and accepting
connections on Unix domain socket
"/var/run/postgresql/.s.PGSQL.5432"?

But surprisingly the port was open at 5432, I got it confirmed as below:

top -u postgres

PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
6180 postgres 20 0 164m 2296 1824 S 0.9 0.0 0:00.36
/usr/pgsql-9.1/bin/pg_statsinfod 6171
6861 postgres 20 0 17176 1324 952 R 0.9 0.0 0:00.01 top -u postgres
6171 postgres 20 0 234m 20m 19m S 0.0 0.3 0:00.47
/usr/pgsql-9.1/bin/postmaster -p 5432 -D /home/new_data/9.1/data
6173 postgres 20 0 179m 1444 636 S 0.0 0.0 0:00.24 postgres:
pg_statsinfo launcher process
6174 postgres 20 0 181m 1368 520 S 0.0 0.0 0:00.03 postgres:
logger process
6176 postgres 20 0 234m 1792 920 S 0.0 0.0 0:00.17 postgres:
writer process
6177 postgres 20 0 234m 1520 648 S 0.0 0.0 0:00.14 postgres: wal
writer process
6178 postgres 20 0 235m 3300 1344 S 0.0 0.0 0:00.14 postgres:
autovacuum launcher process
6179 postgres 20 0 184m 1936 604 S 0.0 0.0 0:00.26 postgres: stats
collector process
6826 postgres 20 0 107m 1740 1304 S 0.0 0.0 0:00.00 bash

Is there any issue with my configuration?? Kindly suggest!

Regards,
Pavan

--
Sent from: http://www.postgresql-archive.org/PostgreSQL-admin-f2076596.html