| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | "brunormr" <brunormr(at)bol(dot)com(dot)br> |
| Cc: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: Help to restore lost database |
| Date: | 2002-06-26 13:42:23 |
| Message-ID: | 1833.1025098943@sss.pgh.pa.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
"brunormr" <brunormr(at)bol(dot)com(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Nick Fankhauser | 2002-06-26 14:04:32 | Re: Missing or Erroneous pg_hba.conf file |
| Previous Message | brunormr | 2002-06-26 01:03:01 | Help to restore lost database |