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

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