________________________________ De: David Steele <da...@pgmasters.net> Enviado: quarta-feira, 1 de abril de 2020 22:09 Para: Edson Richter <edsonrich...@hotmail.com>; pgsql-general <pgsql-gene...@postgresql.org> Cc: Alvaro Herrera <alvhe...@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 da...@pgmasters.net