Re: [GENERAL] Please help -- Postgres stopped responding ....

2011-02-26 Thread John R Pierce
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. thi

Re: [GENERAL] Please help -- Postgres stopped responding ....

2011-02-26 Thread Raymond O'Donnell
On 26/02/2011 16:00, savio rodriges wrote: Please let me know how to configure "ERROR REPORTING AND LOGGING" section of postgres.conf to get all necessary postgres information in logfile for debuging/administration purpose. I think you need to look at log_min_messages and log_error_verbosity

Re: [GENERAL] Please help -- Postgres stopped responding ....

2011-02-26 Thread savio rodriges
on of postgres.conf to get all necessary postgres information in logfile for debuging/administration purpose. Thanks for your help. Savio --- On Sat, 2/26/11, Raymond O'Donnell wrote: > From: Raymond O'Donnell > Subject: Re: [GENERAL] Please help -- Postgres stopped respondi

Re: [GENERAL] Please help -- Postgres stopped responding ....

2011-02-26 Thread Raymond O'Donnell
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.2

[GENERAL] Please help -- Postgres stopped responding ....

2011-02-26 Thread savio rodriges
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 postg