Help to restore lost database

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

Responses

Browse pgsql-admin by date

  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