| From: | Andrew Sullivan <andrew(at)libertyrms(dot)info> |
|---|---|
| To: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: postgres xlog crashes - recovery procedure |
| Date: | 2002-10-30 15:23:14 |
| Message-ID: | 20021030102314.C9431@mail.libertyrms.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
On Tue, Oct 29, 2002 at 01:47:40PM -0500, Alexander Korobov wrote:
>
> I'm aware of contrib/pg_resetxlog but this does not seem to be reliable tool.
It's as reliable as it can be, as far as I know. There is the
potential for data loss, but that's the problem with having lost your
WAL.
> Are there any postgres specific recovery procedures and /or documentation on how
> to prevent such situations?
The recovery in this case is pg_resetxlog. As for prevention, it
depends on what happened. Any ideas?
A
--
----
Andrew Sullivan 204-4141 Yonge Street
Liberty RMS Toronto, Ontario Canada
<andrew(at)libertyrms(dot)info> M2P 2A8
+1 416 646 3304 x110
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andrew Sullivan | 2002-10-30 15:24:16 | Re: Connection refused errors |
| Previous Message | dima | 2002-10-30 13:36:32 | Re: pg_hba.conf on win32 |