On 26/02/2011 15:04, 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
[root@server]$ uptime 20:33:26 up 63 days, 22:57, 4 users, load
average: 1.73, 2.26, 2.43
My questions are,
1. Which postgresql database logfile needs to checked for information
on why postgres stoped responding?
The latest one. :-)
Seriously, check in postgresql.conf where the logs are set to go, and
look there for the most recent file.
2. What else besides logfile can be checked ?
What happens when you try to restart it? - Again, check the logs.
Maybe look in syslog to see if anything else happened at that time?
Ray.
--
Raymond O'Donnell :: Galway :: Ireland
rod@xxxxxx
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
