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

From: Bjoern Metzdorf <bm(at)turtle-entertainment(dot)de>
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 13:55:55
Message-ID: 40CDAE6B.90400@turtle-entertainment.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Bruno Wolff III 2004-06-14 15:22:02 Re: [ADMIN] doubt
Previous Message Bender, Cheryl 2004-06-14 13:36:22 Re: FreeBSD & Shared Memory