Backup/Restore to a point in time

Поиск
Список
Период
Сортировка
От Troy Campano
Тема Backup/Restore to a point in time
Дата
Msg-id 20040622204807.D3D72D1B2D9@svr1.postgresql.org
обсуждение исходный текст
Ответы Re: Backup/Restore to a point in time  (Doug McNaught <doug@mcnaught.org>)
Список pgsql-general

Hello,

1) I know that Postgresql writes its transactions to logs (WAL).

If I take exports once a day (say 7am) and I have a client that somehow ruins their database at 5pm today and it is now 7pm, can I somehow get the database back to the state it was in at 4:59 (right before they blew up their database)?

 

2) Where are the WAL files located?

 

 

Thank you!

 

~ Troy Campano ~

 

 

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

Предыдущее
От: Bricklen
Дата:
Сообщение: Re: virtual fields on VIEW?
Следующее
От: joseph speigle
Дата:
Сообщение: Re: How can I add a new language localization(locale) support