Re: repmgr and archive_mode - Mailing list pgsql-general

From Toby Corkindale
Subject Re: repmgr and archive_mode
Date
Msg-id 342774324.4323.1312009026905.JavaMail.root@dmz03
Whole thread Raw
In response to Re: repmgr and archive_mode  (Jaime Casanova <jaime@2ndquadrant.com>)
Responses Re: repmgr and archive_mode
List pgsql-general
----- Original Message -----
> <toby.corkindale@strategicdata.com.au> wrote:
> > Hi,
> > In the repmgr README, it suggests configuration should include:
> >
> > archive_mode = on
> > archive_command = 'cd .'
> >
> > Could someone explain why we need archive_mode enabled? In my own
> > testing of
> > Pg's streaming replication, I've found it to work without this
> > enabled.
> >
>
> it's not really needed but in some situations you could want to
> archive wal segments (for example if you want to shut down the standby
> without having to put a really big value in wal_keep_segments) and
> while archive_command can be changed at anytime just reloading
> archive_mode needs to restart the server. so this is just a good
> configuration for 24x7 setups

Aaah.. now that explains it perfectly.

Many thanks for clearing that up! I hadn't realised that you could only change one of the two options on the fly.

Thanks,
Toby

pgsql-general by date:

Previous
From: Jaime Casanova
Date:
Subject: Re: repmgr and archive_mode
Next
From: Simon Riggs
Date:
Subject: Re: Factors Influencing Participant Satisfaction with Free/Libre and Open Source Software Projects