De: Alvaro Herrera <alvherre@2ndquadrant.com> Enviado: quarta-feira, 1 de abril de 2020 19:55 Para: Abdul Sayeed <abdulsayeed24@gmail.com> Cc: Edson Richter <edsonrichter@hotmail.com>; pgsql-general <pgsql-general@postgresql.org> Assunto: Re: It is possible to force periodically switch xlog?
On 2020-Apr-02, Abdul Sayeed wrote:
> Hi Edson, > > You can switch by using below command below PG 10. > > Select pg_switch_xlog(); > > And there is no parameter present to switch it.
IIRC archive_timeout does precisely that.
I would assume that "archive_mode" must be "on" or "always" - but I do have "archive_mode=off".