Re: PostgreSQL Point In Time Recovery

Поиск
Список
Период
Сортировка
От Jayadevan
Тема Re: PostgreSQL Point In Time Recovery
Дата
Msg-id 1382681614651-5775874.post@n5.nabble.com
обсуждение исходный текст
Ответ на Re: PostgreSQL Point In Time Recovery  (Alan Hodgson <ahodgson@simkin.ca>)
Ответы Re: PostgreSQL Point In Time Recovery  (Alan Hodgson <ahodgson@simkin.ca>)
Список pgsql-general
Alan Hodgson wrote
> That's basically what warm standby's do, isn't it? As long as they keep
> recovery open it should work.

A warn standby will be almost in sync with the primary, right? So recovery
to point-in-time (like 10 AM this morning) won't be possible. We need a
base, but it shouldn't be so old that it takes hours to catchup- that was my
thought. As John mentioned, looking at the WAL/transaction numbers, time to
recover etc need to be looked at.



--
View this message in context:
http://postgresql.1045698.n5.nabble.com/PostgreSQL-Point-In-Time-Recovery-tp5775717p5775874.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.


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

Предыдущее
От: Jayadevan
Дата:
Сообщение: Re: PostgreSQL Point In Time Recovery
Следующее
От: Achilleas Mantzios
Дата:
Сообщение: Re: (collation) Building postgresql on FreeBSD, the pros and cons of icu