cascading replication and replication_slots

Started by Leif Gunnar Erlandsenalmost 11 years ago3 messagesgeneral
Jump to latest
#1Leif Gunnar Erlandsen
leif.gunnar.erlandsen@basefarm.com

Is it possible to use a replication_slot for a downstream-server when setting up cascading replication on 9.4

Leif G.

Vennlig hilsen/ Best regards
--

LEIF GUNNAR ERLANDSEN
Senior Database Consultant

BASEFARM | Nydalen Allé 37a | 0484 Oslo | Norway
Phone: +47 4000 4100 | Mobile: +47 906 24 949
leif.gunnar.erlandsen@basefarm.com<mailto:leif.gunnar.erlandsen@basefarm.com> | www.basefarm.com<http://www.basefarm.com&gt;

?

technical excellence - caring for your business

#2Michael Paquier
michael@paquier.xyz
In reply to: Leif Gunnar Erlandsen (#1)
Re: cascading replication and replication_slots

On Tue, Jun 23, 2015 at 8:18 PM, Leif Gunnar Erlandsen
<leif.gunnar.erlandsen@basefarm.com> wrote:

Is it possible to use a replication_slot for a downstream-server when
setting up cascading replication on 9.4

Yes. Just be careful that replication slot data is not included in a
base backup.
--
Michael

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

#3Leif Gunnar Erlandsen
leif.gunnar.erlandsen@basefarm.com
In reply to: Michael Paquier (#2)
Re: cascading replication and replication_slots

Fra: Michael Paquier <michael.paquier@gmail.com>
Sendt: 23. juni 2015 13:32

On Tue, Jun 23, 2015 at 8:18 PM, Leif Gunnar Erlandsen
<leif.gunnar.erlandsen@basefarm.com> wrote:

Is it possible to use a replication_slot for a downstream-server when
setting up cascading replication on 9.4

Yes. Just be careful that replication slot data is not included in a
base backup.
--
Michael

Thank you, got it to work now.
Created the replication slot on the cascading server after I had created the base backup.

Leif G.

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general