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

Поиск
Список
Период
Сортировка
От Chan Michael
Тема How can I restore from WAL log? [PG 7.3]
Дата
Msg-id 20060928141619.70631.qmail@web30502.mail.mud.yahoo.com
обсуждение исходный текст
Ответы 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>)
Список 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 по дате отправления:

Предыдущее
От: "Matthew T. O'Connor"
Дата:
Сообщение: Re: [PERFORM] autovacuum on a -mostly- r/o table
Следующее
От: "Chris Hoover"
Дата:
Сообщение: Table Truncate and Locks