De: Alvaro Herrera <alvherre@xxxxxxxxxxxxxxx>
Enviado: quarta-feira, 1 de abril de 2020 19:55
Para: Abdul Sayeed <abdulsayeed24@xxxxxxxxx>
Cc: Edson Richter <edsonrichter@xxxxxxxxxxx>; pgsql-general <pgsql-general@xxxxxxxxxxxxxx>
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".
Regards,
Edson
|
