How can I restore from WAL log? [PG 7.3]

From: Chan Michael <michael_kychan(at)yahoo(dot)com(dot)hk>
To: pgsql-admin(at)postgresql(dot)org
Subject: How can I restore from WAL log? [PG 7.3]
Date: 2006-09-28 14:16:19
Message-ID: 20060928141619.70631.qmail@web30502.mail.mud.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi,

I am new to PostgreSQL and now want to know how can I recover from a database crash.

I know pg_dump and pg_restore but with pg_dump all transactions between every pg_dump will be lost. I found WAL in the doc and seems with it I can archieve point-in-time recovery. But I don't know the exact steps of doing this.

Any input, link or tutorials will be greatly appreciated.

Thanks in advance.

Michael
_______________________________________
YM - 離線訊息
就算你沒有上網，你的朋友仍可以留下訊息給你，當你上網時就能立即看到，任何說話都冇走失。
http://messenger.yahoo.com.hk

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Chris Hoover 2006-09-28 15:10:46 Table Truncate and Locks
Previous Message Edoardo Ceccarelli 2006-09-28 08:44:05 Re: autovacuum on a -mostly- r/o table