From: | Raymond O'Donnell <rod(at)iol(dot)ie> |
---|---|
To: | savio rodriges <sj_savio(at)yahoo(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Please help -- Postgres stopped responding .... |
Date: | 2011-02-26 15:21:58 |
Message-ID: | 4D691A96.2030000@iol.ie |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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?
Ray.
--
Raymond O'Donnell :: Galway :: Ireland
rod(at)iol(dot)ie
From | Date | Subject | |
---|---|---|---|
Next Message | franco egizii | 2011-02-26 15:54:02 | Re: Website code Pl/pgsql |
Previous Message | Raymond O'Donnell | 2011-02-26 15:18:42 | Re: views and categorized tables |