How can I restore from WAL log? [PG 7.3] - Mailing list pgsql-admin

From Chan Michael
Subject How can I restore from WAL log? [PG 7.3]
Date
Msg-id 20060928141619.70631.qmail@web30502.mail.mud.yahoo.com
Whole thread Raw
Responses Re: How can I restore from WAL log? [PG 7.3]  ("Jim C. Nasby" <jim@nasby.net>)
Re: How can I restore from WAL log? [PG 7.3]  (Bruno Wolff III <bruno@wolff.to>)
List 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

pgsql-admin by date:

Previous
From: "Matthew T. O'Connor"
Date:
Subject: Re: [PERFORM] autovacuum on a -mostly- r/o table
Next
From: "Chris Hoover"
Date:
Subject: Table Truncate and Locks