Re: Including replication slot data in base backups - Mailing list pgsql-hackers

From Josh Berkus
Subject Re: Including replication slot data in base backups
Date
Msg-id 533B59DE.3060603@agliodbs.com
Whole thread Raw
In response to Including replication slot data in base backups  (Michael Paquier <michael.paquier@gmail.com>)
List pgsql-hackers
On 04/01/2014 05:24 AM, Michael Paquier wrote:
> Hi all,
> 
> As of now, pg_basebackup creates an empty repository for pg_replslot/
> in a base backup, forcing the user to recreate slots on other nodes of
> the cluster with pg_create_*_replication_slot, or copy pg_replslot
> from another node. This is not really user-friendly especially after a
> failover where a given slave may not have the replication slot
> information of the master that it is replacing.
> 
> The simple patch attached adds a new option in pg_basebackup, called
> --replication-slot, allowing to include replication slot information
> in a base backup. This is done by extending the command BASE_BACKUP in
> the replication protocol.
> 
> As it is too late for 9.4, I would like to add it to the first commit
> fest of 9.5. Comments are welcome.

Assuming it works, this seems like something we need to fix for 9.4.  No?


-- 
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com



pgsql-hackers by date:

Previous
From: Merlin Moncure
Date:
Subject: Re: using arrays within structure in ECPG
Next
From: Tom Lane
Date:
Subject: It seems no Windows buildfarm members are running find_typedefs