Обсуждение: Backup/Restore to a point in time

Поиск
Список
Период
Сортировка

Backup/Restore to a point in time

От
"Troy Campano"
Дата:

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 ~

 

 

Re: Backup/Restore to a point in time

От
Doug McNaught
Дата:
"Troy Campano" <troycampano@yahoo.com> writes:

>    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)?

Not with current versions.  This feature is called point-in-time
recovery (PITR) and is being reviewed for inclusion in the upcoming
7.5 release.

-Doug