Re: [COMMITTERS] pgsql: Allow external recovery_config_directory - Mailing list pgsql-hackers

From Heikki Linnakangas
Subject Re: [COMMITTERS] pgsql: Allow external recovery_config_directory
Date
Msg-id 5153314D.5080902@vmware.com
Whole thread Raw
In response to Re: [COMMITTERS] pgsql: Allow external recovery_config_directory  (Simon Riggs <simon@2ndQuadrant.com>)
Responses Re: [COMMITTERS] pgsql: Allow external recovery_config_directory  (Simon Riggs <simon@2ndQuadrant.com>)
List pgsql-hackers
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.

- Heikki



pgsql-hackers by date:

Previous
From: Simon Riggs
Date:
Subject: Re: [COMMITTERS] pgsql: Allow external recovery_config_directory
Next
From: Simon Riggs
Date:
Subject: Re: [COMMITTERS] pgsql: Allow external recovery_config_directory