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

From Tom Lane
Subject Re: How do I recover from>> pg_xlog/0000000000000000 (log file 0, segment 0) failed: No such file or directory
Date
Msg-id 20243.1098223066@sss.pgh.pa.us
Whole thread Raw
In response to How do I recover from>> pg_xlog/0000000000000000 (log file 0, segment 0) failed: No such file or directory  (peter Willis <peterw@borstad.com>)
Responses Re: How do I recover from>> pg_xlog/0000000000000000 (log
List pgsql-general
peter Willis <peterw@borstad.com> writes:
> [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

pg_resetxlog would probably get you to a point where you could start
the server, but you should not have any great illusions about the
consistency of your database afterward.

How did you get into this state, anyway?  And what PG version is it?

            regards, tom lane

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: how much ram do i give postgres?
Next
From: Kevin Barnard
Date:
Subject: Re: [PERFORM] Performance on Win32 vs Cygwin