Thread: Help to restore lost database

  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

"brunormr" <brunormr@bol.com.br> writes:
>   I erased the files (000000000000 and
> 000000000001) that were im the pg_xlog
> folder into the data directory of
> pgsql.

A piece of advice: if you don't know what a file is for, don't remove
it.

>   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?

If the postmaster was shut down at the time, then running
contrib/pg_resetxlog should get you out of trouble.

            regards, tom lane