Re: [GENERAL] Missing files under pg_data following power failure

2007-10-12 Thread Brad Nicholson
On Fri, 2007-10-12 at 10:54 -0500, Scott Marlowe wrote: > On 10/12/07, Jack Orenstein <[EMAIL PROTECTED]> wrote: > > Our testing involves cutting power to machines running postgres 7.4, > > while under load (lots of reads and writes). When we do this, we often > > lose some files under pg_data stor

Re: [GENERAL] Missing files under pg_data following power failure

2007-10-12 Thread Scott Marlowe
On 10/12/07, Jack Orenstein <[EMAIL PROTECTED]> wrote: > Our testing involves cutting power to machines running postgres 7.4, > while under load (lots of reads and writes). When we do this, we often > lose some files under pg_data storing table content. I.e., the file > named for a table's pg_class

Re: [GENERAL] Missing files under pg_data following power failure

2007-10-12 Thread Martijn van Oosterhout
On Fri, Oct 12, 2007 at 11:28:04AM -0400, Jack Orenstein wrote: > Our testing involves cutting power to machines running postgres 7.4, > while under load (lots of reads and writes). When we do this, we often > lose some files under pg_data storing table content. I.e., the file > named for a table's

[GENERAL] Missing files under pg_data following power failure

2007-10-12 Thread Jack Orenstein
Our testing involves cutting power to machines running postgres 7.4, while under load (lots of reads and writes). When we do this, we often lose some files under pg_data storing table content. I.e., the file named for a table's pg_class.oid value is simply gone. This can affect many tables followi