"brunormr" <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/users-lounge/docs/faq.html
