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