[GENERAL] Debug advice when postgres connection maxing out

2010-11-22 Thread anypossibility
Server: OS X 10.5 PostgreSQL version: 8.3 We experience this connection maxing out once in the full moon. The request from client reaches to the server but client never receive response back. The queries are very simple update on one record or select one record using primary key (checked curre

Re: [GENERAL] when postgres failed to recover after the crash...

2010-11-15 Thread anypossibility
Gabriele, Thank you for the link. I downloaded the book and read the chapter. Very useful information. Craig, The storage type is SAN over AFP. Unfortunately, it has been a week or so since the crash. We were able to recover lost data from last backup (a few hours old) but next time, I will

[GENERAL] when postgres failed to recover after the crash...

2010-11-14 Thread anypossibility
I am running postgres postgres version 8.3 on OS X. The data directory is on network volume. The network volume was disconnected and server crashed. Log reported that last know up was 9:30 pm (about 30 min prior to the server crash.) My conf Checkpoint_Segments setting = 3 (not sure if this is all