Skip site navigation (1)
Skip section navigation (2)
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
Peripheral Links
Header And Logo
|
Site Navigation
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: Thu, 28 Sep 2006 22:16:19 +0800 (CST)
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
- Follow-Ups:
- Re: How can I restore from WAL log? [PG 7.3]
- From: Bruno Wolff III
- Re: How can I restore from WAL log? [PG 7.3]
- From: Jim C. Nasby
- Re: How can I restore from WAL log? [PG 7.3]
- Prev by Date: Re: [PERFORM] autovacuum on a -mostly- r/o table
- Next by Date: Table Truncate and Locks
- Previous by thread: having trouble restoring a database from files
- Next by thread: Re: How can I restore from WAL log? [PG 7.3]
- Indexes: