Postgres Pro
Downloads
Home   >   mailing lists

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

From Bjoern Metzdorf
Subject Re: could not open file "/var/lib/pgsql/data/pg_xlog/0000000000000001"
Date
Msg-id 40CDAE6B.90400@turtle-entertainment.de
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 wrote:
> LOG:  could not open file "/var/lib/pgsql/data/pg_xlog/0000000000000001"
> (log file 0, segment 1): No such file or directory
> LOG:  invalid primary checkpoint record
>
> Is there any way I can recreate a checkpoint record or resurrect any
> data from postgresql.  How important was the 0000000000000001 file ?

check pg_resetxlog from postgresql/bin

Regards,
Bjoern

pgsql-admin by date:

Previous
From: "Bender, Cheryl"
Date:
Subject: Re: FreeBSD & Shared Memory
Next
From: "Lee Wu"
Date:
Subject: table not shown