Missing files under pg_data following power failure

From: Jack Orenstein <jack(dot)orenstein(at)hds(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Missing files under pg_data following power failure
Date: 2007-10-12 15:28:04
Message-ID: 470F9284.40100@hds.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

ERROR: relation "xxx" does not exist

The table is present in the system tables, but the file storing table
content under pg_data is missing.

Can anyone provide insight on this phenomenon? Why are these files
lost? Are they really lost, or have they simply moved somewhere? What
happens to the disk blocks formerly occupied by the files?

Getting back in service following this file loss is not a problem; I'm
just trying to understand how postgres gets into this state.

Jack Orenstein

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Scott Marlowe 2007-10-12 15:42:14 Re: DB errors
Previous Message Tom Lane 2007-10-12 15:16:34 Re: Coercing compound types to use generic ROW comparison operators