Search Postgresql Archives

RE: It is possible to force periodically switch xlog?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 






De: David Steele <david@xxxxxxxxxxxxx>
Enviado: quarta-feira, 1 de abril de 2020 22:09
Para: Edson Richter <edsonrichter@xxxxxxxxxxx>; pgsql-general <pgsql-general@xxxxxxxxxxxxxx>
Cc: Alvaro Herrera <alvherre@xxxxxxxxxxxxxxx>
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
david@xxxxxxxxxxxxx

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux