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

From Michael Paquier
Subject Including replication slot data in base backups
Date
Msg-id CAB7nPqTBik66XosbXpRoSneQQ9EPPXr0tVpLc4vGLB5hWz0Rkg@mail.gmail.com
Whole thread Raw
Responses Re: Including replication slot data in base backups
List pgsql-hackers
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.

Regards,
--
Michael

Attachment

pgsql-hackers by date:

Previous
From: Andrzej Mazurkiewicz
Date:
Subject: Re: Inheritance of foregn key constraints.
Next
From: Tom Lane
Date:
Subject: Re: Patch to add support of "IF NOT EXISTS" to others "CREATE" statements