RE: It is possible to force periodically switch xlog?

Поиск
Список
Период
Сортировка
От Edson Richter
Тема RE: It is possible to force periodically switch xlog?
Дата
Msg-id MN2PR01MB5327B3098D365954C49C907BCFC60@MN2PR01MB5327.prod.exchangelabs.com
обсуждение исходный текст
Ответ на Re: It is possible to force periodically switch xlog?  (David Steele <david@pgmasters.net>)
Ответы Re: It is possible to force periodically switch xlog?
Список pgsql-general



De: David Steele <david@pgmasters.net>
Enviado: quarta-feira, 1 de abril de 2020 22:09
Para: Edson Richter <edsonrichter@hotmail.com>; pgsql-general <pgsql-general@postgresql.org>
Cc: Alvaro Herrera <alvherre@2ndquadrant.com>
Assunto: Re: It is possible to force periodically switch xlog?
 
On 4/1/20 7:19 PM, Edson Richter wrote:
>
>     IIRC archive_timeout does precisely that.
>
> I would assume that "archive_mode" must be "on" or "always" - but I do
> have "archive_mode=off".

I'm not sure what the point of switching the WAL segment would be with
archive_mode=off.

What are you trying to accomplish?


Actually, I do have a stand by server I wish to update a bit more frequently in low traffic servers.

Regards,


Regards,
--
-David
david@pgmasters.net

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

Предыдущее
От: Kyotaro Horiguchi
Дата:
Сообщение: Re: It is possible to force periodically switch xlog?
Следующее
От: Edson Richter
Дата:
Сообщение: RE: It is possible to force periodically switch xlog?