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

From: peter Willis <peterw(at)borstad(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: How do I recover from>> pg_xlog/0000000000000000 (log file 0, segment 0) failed: No such file or directory
Date: 2004-10-18 19:06:13
Message-ID: 41741425.4070509@borstad.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)web2 /]$ pg_ctl start
postmaster successfully started
[postgres(at)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(at)web2 /]$

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jan Wieck 2004-10-18 19:41:32 Re: Cache lookup failed for relation, when trying to DROP
Previous Message Chris Browne 2004-10-18 17:22:59 Re: Online system & transactions