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

2010-11-15 Thread Craig Ringer
On 15/11/10 19:59, anypossibility wrote: > 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. I very, very strongly suggest getting your SAN host to export an iSCSI volume to mount directly on

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

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

2010-11-14 Thread Gabriele Bartolini
Hi, In general, it's a really bad idea to run PostgreSQL (or any other database) over file-level network storage like SMB/AFP/CIFS/NFS. Block-level network storage like iSCSI is generally OK, depending on the quality of the drivers in target and initiator. What Craig says it is true and it migh

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

2010-11-14 Thread Craig Ringer
On 15/11/10 07:04, anypossibility wrote: > I am running postgres postgres version 8.3 on OS X. > The data directory is on network volume. What kind of network volume? An AFP mount? SMB share? NFS? iSCSI? In general, it's a really bad idea to run PostgreSQL (or any other database) over file-level

[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