Thread: could not open file "/var/lib/pgsql/data/pg_xlog/0000000000000001"

could not open file "/var/lib/pgsql/data/pg_xlog/0000000000000001"

From
Barry Clearwater
Date:
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


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

Re: could not open file "/var/lib/pgsql/data/pg_xlog/0000000000000001"

From
Bjoern Metzdorf
Date:
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