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@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)