log shipping with pg_receivewal

Поиск
Список
Период
Сортировка
От Marc Millas
Тема log shipping with pg_receivewal
Дата
Msg-id CADX_1aYC1buV3T=NRC_=p=HxbHpPF3EXck-KWN-cymgRY260Gg@mail.gmail.com
обсуждение исходный текст
Ответы Re: log shipping with pg_receivewal  (Michael Paquier <michael@paquier.xyz>)
Re: log shipping with pg_receivewal  (Dilip Kumar <dilipbalaut@gmail.com>)
Список pgsql-general
Hi,
postgres 13 question, 

if I setup pg_receivewal from a primary instance to a given directory, and then setup a standby with a restore_command pointing to that directory,, the changes on the primary are applied on the standby at each wal change. And this, even if I run pg_receivewal with the --synchronous option.

My question: as the synchronous option is supposed to make pg_receivewal write transaction immediately in the wal files, is there a way to ask the standby to apply them on the fly ie. without waiting a wal file change ?

thanks,


Marc MILLAS
Senior Architect
+33607850334

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

Предыдущее
От: Marc Millas
Дата:
Сообщение: locks within select
Следующее
От: Michael Paquier
Дата:
Сообщение: Re: log shipping with pg_receivewal