From: | "brunormr" <brunormr(at)bol(dot)com(dot)br> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Subject: | Help to restore lost database |
Date: | 2002-06-26 01:03:01 |
Message-ID: | GYAG91$ILF30yHYwmtL_XFCGueBP3f0i29jM2d2WOlmMCr@bol.com.br |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
I erased the files (000000000000 and
000000000001) that were im the pg_xlog
folder into the data directory of
pgsql. So when I started the server it
gave me the message:
DEBUG: database system was shut down
at 2002-06-25 16:09:46 BRT
DEBUG: open(logfile 0 seg 0) failed:
No such file or directory
DEBUG: Invalid primary checkPoint record
DEBUG: open(logfile 0 seg 0) failed:
No such file or directory
DEBUG: Invalid secondary checkPoint
record
FATAL 2: Unable to locate a valid
CheckPoint record
postmaster: Startup proc 2649 exited
with status 512 - abort
I have all the other files of the
database and I want to restore the
data, but I hadn't made a backup (a
dump). Is there a way to restore the
files on the pg_xlog with the other
files or to save the data from the
database?
Thanks... Bruno
__________________________________________________________________________
AcessoBOL, só R$ 9,90! O menor preço do mercado!
Assine já! http://www.bol.com.br/acessobol
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2002-06-26 13:42:23 | Re: Help to restore lost database |
Previous Message | Tim Ellis | 2002-06-26 00:58:52 | New dia2sql Made |