How do I recover from>> pg_xlog/0000000000000000 (log file 0, segment 0) failed: No such file or directory - Mailing list pgsql-general

From peter Willis
Subject How do I recover from>> pg_xlog/0000000000000000 (log file 0, segment 0) failed: No such file or directory
Date
Msg-id 41741425.4070509@borstad.com
Whole thread Raw
Responses Re: How do I recover from>> pg_xlog/0000000000000000 (log file 0, segment 0) failed: No such file or directory  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Hello,

Is there a way to recover from the following error?
I have (had) an existing database and wish not
to lose the data tables.

Thanks for any help,

Pete


[postgres@web2 /]$ pg_ctl start
postmaster successfully started
[postgres@web2 /]$ LOG:  database system shutdown was interrupted at
2004-10-18 11:41:55 PDT
LOG:  open of /web2-disk1/grip/database/pg_xlog/0000000000000000 (log
file 0, segment 0) failed: No such file or directory
LOG:  invalid primary checkpoint record
LOG:  open of /web2-disk1/grip/database/pg_xlog/0000000000000000 (log
file 0, segment 0) failed: No such file or directory
LOG:  invalid secondary checkpoint record
PANIC:  unable to locate a valid checkpoint record
LOG:  startup process (pid 2803) was terminated by signal 6
LOG:  aborting startup due to startup process failure

[postgres@web2 /]$



pgsql-general by date:

Previous
From: Scott Frankel
Date:
Subject: attn.: psycopg users -- simple question
Next
From: Björn Lundin
Date:
Subject: Re: Online & update races