Re: could not open file "/var/lib/pgsql/data/pg_xlog/0000000000000001"

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Barry Clearwater <barryc(at)kelly(dot)co(dot)nz>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: could not open file "/var/lib/pgsql/data/pg_xlog/0000000000000001"
Date: 2004-06-14 12:31:49
Message-ID: 21932.1087216309@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Barry Clearwater <barryc(at)kelly(dot)co(dot)nz> writes:
> How important was the 0000000000000001 file ?

Fairly :-(

You can get the database back into a startable condition with
pg_resetxlog, but it is likely that you may have lost part or
all of transactions since the last checkpoint.

regards, tom lane

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Bender, Cheryl 2004-06-14 13:36:22 Re: FreeBSD & Shared Memory
Previous Message Tom Lane 2004-06-14 12:25:04 Re: pg_clog after crash