Re: Turning slave into a master - PostgreSQL 9.2

Поиск
Список
Период
Сортировка
От Francisco Olarte
Тема Re: Turning slave into a master - PostgreSQL 9.2
Дата
Msg-id CA+bJJbymDPE7TNPDYUemVpeG0C-Ski0OfuCc5Zh=hHenSUAZyw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Turning slave into a master - PostgreSQL 9.2  (Patrick B <patrickbakerbr@gmail.com>)
Список pgsql-general
Hi:

On Tue, Nov 1, 2016 at 3:01 AM, Patrick B <patrickbakerbr@gmail.com> wrote:
> If I change recovery.conf:
> recovery_target_time = '2016-10-30 02:24:40'
> I get error:
> FATAL:  requested recovery stop point is before consistent recovery point

It looks clear. When you take a base backup from a running system some
recovery is needed to make it consistent. With the target time you can
limit how much is done. But there is a minimum. Think of it, if you
stated '1970-01-01' it would be clearly imposible, your date is
bigger, but still imposible, try raising it a bit.

Francisco Olarte.


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

Предыдущее
От: 德哥
Дата:
Сообщение: pgbench support dynamic identifier name
Следующее
От: Merlin Moncure
Дата:
Сообщение: Re: How to hint 2 coulms IS NOT DISTINCT FROM each other