Re: Please help -- Postgres stopped responding ....

On 02/26/11 7:04 AM, savio rodriges wrote:
> Hello Team,
>
> I am new to Postgresql. Postgresql suddenly stoped responding. Below is what I checked.
>
> [root(at)server]$/etc/init.d/postgres status
> dead but pid file exists

that probably means the server aborted for some reason without cleaning
up. this could happen if the system reset or power cycled without
being shutdown properly, or if the server crashed.

as others said, check the log file. if thats RHEL/CentOS/Fedora, odds
are its in /var/lib/pgsql/data/pg_log/postgresql-${DATE}_${SEQUENCE}.log
... look at the latest file. if you're running an older RHEL/etc stock
build of postgres, its possible its /var/lib/pgsql/server.log

to restart postgres, you'll need to delete the 'pid' file, likely
/var/lib/pgsql/data/postmaster.pid ... probably a good idea to verify
there aren't any postmaster processes still running detached,

$ ps -FU postgres
postgres 2707 1 0 38026 5696 1 Jan05 ? 00:18:50
/usr/bin/postmaster -p 5432 -D /var/lib/pgsql/data
postgres 3921 2707 0 3281 1060 0 Jan05 ? 00:00:19
postgres: logger process
postgres 4524 2707 0 38058 112828 2 Jan05 ? 00:01:24
postgres: writer process
postgres 4525 2707 0 38060 1304 1 Jan05 ? 00:00:05
postgres: wal writer process
postgres 4526 2707 0 38353 2352 1 Jan05 ? 00:55:39
postgres: autovacuum launcher process
postgres 4527 2707 0 3569 1648 0 Jan05 ? 02:35:08
postgres: stats collector process

(showing a normally running system)