| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | "Johnson, Shaunn" <SJohnson6(at)bcbsm(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: how to use pg_resetxlog |
| Date: | 2003-10-20 16:37:16 |
| Message-ID: | 3343.1066667836@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
"Johnson, Shaunn" <SJohnson6(at)bcbsm(dot)com> writes:
> 1) How do you use pg_resetxlog?
Read the README file for it.
> 2) Am I at risk of losing all of my data
> if I use this?
You're at risk of having corrupted data, but I think that's true already
because of the disk failure.
> 3) Some info at groups.google.com suggest that I will
> have to initdb - I figured that would be good anyway, but
> how does pg_resetxlog play into this?
After pg_resetxlog you should be able to dump your database. I'd
recommend doing that, then initdb, reload the dump, look for
inconsistencies ...
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2003-10-20 16:38:53 | Re: how to use pg_resetxlog |
| Previous Message | J Smith | 2003-10-20 16:27:40 | Re: Using subselects in INSERTs? |