pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Barry Clearwater <barryc@kelly.co.nz>
To: pgsql-admin@postgresql.org
Subject: could not open file "/var/lib/pgsql/data/pg_xlog/0000000000000001"
Date: Mon, 14 Jun 2004 20:55:44 +1200
Message-ID: <1087202682.5267.94.camel@localhost> (raw)

Having sucessfully crashed sql ledger and desperate to see if I can
start it again, I read a posting by Lamar Owen which helped me get a
meaningful output to debug.
Problem started when I inadvertantly started the computer at a date in
the future.
Now I found I have deleted an important file (0000000000000001) -not a
very useful name, I assumed it was a log file.

bash-2.05b$ LOG:  database system was interrupted at 2004-07-23 00:40:11
NZST
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
LOG:  could not open file "/var/lib/pgsql/data/pg_xlog/0000000000000001"
(log file 0, segment 1): No such file or directory
LOG:  invalid secondary checkpoint record
PANIC:  could not locate a valid checkpoint record
LOG:  startup process (PID 9970) was terminated by signal 6
LOG:  aborting startup due to startup process failure

Is there any way I can recreate a checkpoint record or resurrect any
data from postgresql.  How important was the 0000000000000001 file ?

Thank you

Barry Clearwater




view thread (3+ messages)  latest in thread

Message-ID: <1087202682.5267.94.camel@localhost>
Permalink:  ../1087202682.5267.94.camel@localhost/
Also on:    postgresql.org/message-id/1087202682.5267.94.camel@localhost

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-admin@postgresql.org
  Cc: barryc@kelly.co.nz
  Subject: Re: could not open file "/var/lib/pgsql/data/pg_xlog/0000000000000001"
  In-Reply-To: <1087202682.5267.94.camel@localhost>
  References: <1087202682.5267.94.camel@localhost>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox