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

Поиск
Список
Период
Сортировка
От Jim C. Nasby
Тема Re: How can I restore from WAL log? [PG 7.3]
Дата
Msg-id 20060928185851.GX34238@nasby.net
обсуждение исходный текст
Ответ на How can I restore from WAL log? [PG 7.3]  (Chan Michael <michael_kychan@yahoo.com.hk>)
Ответы 回覆: Re: How can I restore from WAL log? [PG 7.3]  (Chan Michael <michael_kychan@yahoo.com.hk>)
Список pgsql-admin
On Thu, Sep 28, 2006 at 10:16:19PM +0800, Chan Michael wrote:
> 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
thedoc and seems with it I can archieve point-in-time recovery. But I don't know the exact steps of doing this. 

Point in Time Recovery wasn't added until version 8.0.
--
Jim Nasby                                            jim@nasby.net
EnterpriseDB      http://enterprisedb.com      512.569.9461 (cell)

В списке pgsql-admin по дате отправления:

Предыдущее
От: "Talha Khan"
Дата:
Сообщение: Re: transaction id wraparound
Следующее
От: Brad Nicholson
Дата:
Сообщение: Re: What Are Last Steps Performed When PostgreSQL