Re: Interrupted streaming replication

Поиск
Список
Период
Сортировка
От Andreas Kretschmer
Тема Re: Interrupted streaming replication
Дата
Msg-id 20151207134533.GA17039@tux
обсуждение исходный текст
Ответ на Interrupted streaming replication  (Tony Nelson <tnelson@starpoint.com>)
Ответы Re: Interrupted streaming replication  (Tony Nelson <tnelson@starpoint.com>)
Список pgsql-general
Tony Nelson <tnelson@starpoint.com> wrote:

> 2015-12-07 08:24:50 EST FATAL:  requested WAL segment 00000001000000890000002C
> has already been removed
>
>
>
> Can I simply copy the file from my archive directory back to the WAL directory?

I'm afraid that won't work, because of the master knows nothing about
this copy and can't stream its content.

Maybe you can create/update your recovery.conf, see restore_command.


for the future: increase wal_keep_segments, or better: use replication
slots (since 9.4 a really good feature to prevent such errors).





Andreas
--
Really, I'm not out to destroy Microsoft. That will just be a completely
unintentional side effect.                              (Linus Torvalds)
"If I was god, I would recompile penguin with --enable-fly."   (unknown)
Kaufbach, Saxony, Germany, Europe.              N 51.05082°, E 13.56889°


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

Предыдущее
От: Tony Nelson
Дата:
Сообщение: Interrupted streaming replication
Следующее
От: Tony Nelson
Дата:
Сообщение: Re: Interrupted streaming replication