________________________________ De: Kyotaro Horiguchi <[email protected]> Enviado: quarta-feira, 1 de abril de 2020 22:22 Para: [email protected] <[email protected]> Cc: [email protected] <[email protected]>; [email protected] <[email protected]>; [email protected] <[email protected]> Assunto: Re: It is possible to force periodically switch xlog?
At Wed, 1 Apr 2020 21:09:20 -0400, David Steele <[email protected]> wrote in > 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? Also I'm a bit curious about that, but anyway archive_timeout works even with archive_mode=off. The name looks being a bit off of its substance. regards. -- Kyotaro Horiguchi NTT Open Source Software Center Good to know! But meanwhile I've wrote a small bash script that executs pg_switch_xlog() and scheduled it in Crond. Regards, Edson
