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) -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
