From: | Barry Clearwater <barryc(at)kelly(dot)co(dot)nz> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Subject: | could not open file "/var/lib/pgsql/data/pg_xlog/0000000000000001" |
Date: | 2004-06-14 08:55:44 |
Message-ID: | 1087202682.5267.94.camel@localhost |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2004-06-14 12:25:04 | Re: pg_clog after crash |
Previous Message | Andreas Schmitz | 2004-06-14 08:10:13 | Re: pg_clog after crash |