Help to restore lost database - Mailing list pgsql-admin

From brunormr
Subject Help to restore lost database
Date
Msg-id GYAG91$ILF30yHYwmtL_XFCGueBP3f0i29jM2d2WOlmMCr@bol.com.br
Whole thread Raw
Responses Re: Help to restore lost database
List 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





pgsql-admin by date:

Previous
From: acchung@mit.edu
Date:
Subject: Missing or Erroneous pg_hba.conf file
Next
From: Tim Ellis
Date:
Subject: New dia2sql Made