Re: Missing files under pg_data following power failure

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 pg_class.oid value is simply gone. This can affect
> many tables following a power outage. We know this problem has
> occurred when we are unable to access a table, e.g.

Really, the files should be under management of the operating system.
What OS are you using and is the filesystems you're using crash safe?

Have a nice day,
--
Martijn van Oosterhout <kleptog(at)svana(dot)org> http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to litigate.