Re: [COMMITTERS] pgsql: Allow external recovery_config_directory

On 27 March 2013 17:50, Heikki Linnakangas <hlinnakangas@vmware.com> wrote:
> On 27.03.2013 19:34, Simon Riggs wrote:
>>
>> On 27 March 2013 16:24, Heikki Linnakangas<hlinnakangas@vmware.com>
>> wrote:
>>>
>>> Lastly, it breaks the new pg_basebackup -R
>>>
>>> functionality; pg_basebackup will create the recovery.conf file, but it
>>> won't take effect.
>>
>>
>> AFAIK pg_basebackup doesn't backup files not in the data directory and
>> tablespace dirs.
>
>
> Imagine that you have set recovery_config_directory='/foo/' in the master
> server. Now you want to set up a standby, so you do:'
>
> pg_basebackup -D data-standby -R
>
> With the -R option, pg_basebackup creates data-standby/recovery.conf to
> point to the master, with standby_mode='on'. But if you start the server, it
> will start up as a master, not as a standby, because
> recovery_config_directory points elsewhere.

Yeh, I get it.

Same argument applies to all conf files, not just recovery.conf.

Sounds like the patch to add -R to pg_basebackup should be revoked as
being not well thought out. Or it should be fixed, in which case this
works the same.

-- Simon Riggs                   http://www.2ndQuadrant.com/PostgreSQL Development, 24x7 Support, Training & Services