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(at)server]$/etc/init.d/postgres status dead but pid file exists
> [root(at)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?
Raymond O'Donnell :: Galway :: Ireland
In response to
pgsql-general by date
|Next:||From: franco egizii||Date: 2011-02-26 15:54:02|
|Subject: Re: Website code Pl/pgsql|
|Previous:||From: Raymond O'Donnell||Date: 2011-02-26 15:18:42|
|Subject: Re: views and categorized tables|