________________________________ De: Kyotaro Horiguchi <horikyota....@gmail.com> Enviado: quarta-feira, 1 de abril de 2020 22:22 Para: da...@pgmasters.net <da...@pgmasters.net> Cc: edsonrich...@hotmail.com <edsonrich...@hotmail.com>; pgsql-gene...@postgresql.org <pgsql-gene...@postgresql.org>; alvhe...@2ndquadrant.com <alvhe...@2ndquadrant.com> Assunto: Re: It is possible to force periodically switch xlog?
At Wed, 1 Apr 2020 21:09:20 -0400, David Steele <da...@pgmasters.net> 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
