Re: [ADMIN] Standby: Use WAL instead of Streaming for now

Поиск
Список
Период
Сортировка
От Don Seiler
Тема Re: [ADMIN] Standby: Use WAL instead of Streaming for now
Дата
Msg-id CAHJZqBCPNxYF0BM8tXibiWYc9HJYKG+4_VnSH_1omOp8Z=UMLg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: [ADMIN] Standby: Use WAL instead of Streaming for now  (Don Seiler <don@seiler.us>)
Список pgsql-admin
Дерево обсуждения
Sorted it out thanks to the folks in IRC. I didn't change any configs, just killed the sender process on the primary via pg_terminate_backed() on the PID of the sender (as seen in pg_stat_replication). This caused recovery on the standby immediately fall back to WAL recovery, where it quickly restored and recovered all the WAL files I had copied over. Once it finished with those, it opened another streaming connection. So I'll just rinse/repeat this process until our networking issues are resolved.

Don.
--
Don Seiler
www.seiler.us

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

Предыдущее
От: Don Seiler
Дата:
Сообщение: Re: [ADMIN] Standby: Use WAL instead of Streaming for now
Следующее
От: Aleksander Kamenik
Дата:
Сообщение: [ADMIN] Re: pg_current_xlog*_location and pg_stat_replication.replay_location> 0 for synced replication connection