pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
could not open file "/var/lib/pgsql/data/pg_xlog/0000000000000001"
3+ messages / 3 participants
[nested] [flat]

* could not open file "/var/lib/pgsql/data/pg_xlog/0000000000000001"
@ 2004-06-14 08:55  Barry Clearwater <barryc@kelly.co.nz>
  0 siblings, 2 replies; 3+ messages in thread

From: Barry Clearwater @ 2004-06-14 08:55 UTC (permalink / raw)
  To: pgsql-admin

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




^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: could not open file "/var/lib/pgsql/data/pg_xlog/0000000000000001"
@ 2004-06-14 12:31  Tom Lane <tgl@sss.pgh.pa.us>
  parent: Barry Clearwater <barryc@kelly.co.nz>
  1 sibling, 0 replies; 3+ messages in thread

From: Tom Lane @ 2004-06-14 12:31 UTC (permalink / raw)
  To: Barry Clearwater <barryc@kelly.co.nz>; +Cc: pgsql-admin

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



^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: could not open file "/var/lib/pgsql/data/pg_xlog/0000000000000001"
@ 2004-06-14 13:55  Bjoern Metzdorf <bm@turtle-entertainment.de>
  parent: Barry Clearwater <barryc@kelly.co.nz>
  1 sibling, 0 replies; 3+ messages in thread

From: Bjoern Metzdorf @ 2004-06-14 13:55 UTC (permalink / raw)
  To: Barry Clearwater <barryc@kelly.co.nz>; +Cc: 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



^ permalink  raw  reply  [nested|flat] 3+ messages in thread


end of thread, other threads:[~2004-06-14 13:55 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-06-14 08:55 could not open file "/var/lib/pgsql/data/pg_xlog/0000000000000001" Barry Clearwater <barryc@kelly.co.nz>
2004-06-14 12:31 ` Tom Lane <tgl@sss.pgh.pa.us>
2004-06-14 13:55 ` Bjoern Metzdorf <bm@turtle-entertainment.de>

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