Postgres Pro
Downloads
Home   >   mailing lists

Re: could not open file "/var/lib/pgsql/data/pg_xlog/0000000000000001" - Mailing list pgsql-admin

From Tom Lane
Subject Re: could not open file "/var/lib/pgsql/data/pg_xlog/0000000000000001"
Date
Msg-id 21932.1087216309@sss.pgh.pa.us
Whole thread Raw
In response to could not open file "/var/lib/pgsql/data/pg_xlog/0000000000000001"  (Barry Clearwater <barryc@kelly.co.nz>)
List pgsql-admin
Tree view 
Barry Clearwater <barryc@kelly.co.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

pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: pg_clog after crash
Next
From: "Bender, Cheryl"
Date:
Subject: Re: FreeBSD & Shared Memory