Cascading replication with slots

From: Scot Kreienkamp <Scot(dot)Kreienkamp(at)la-z-boy(dot)com>
To: Postgres General <pgsql-general(at)postgresql(dot)org>
Subject: Cascading replication with slots
Date: 2018-10-30 17:04:08
Message-ID: 17082AAFC33A934082836458CB53494374D69C47@MONDB03.na.lzb.hq
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi everyone,

I've never used replication slots before so I'm just wanting to clarify how they work on a two node streaming replication cluster.

1. From the documentation both active and standby nodes seem to be aware of the status of the replication slot... is that true?

2. Any limitations on using it with cascading replication? For instance, can I setup a replication slot on a standby, then replicate using that slot from another standby?

3. Or can I only replicate from the master when using replication slots?

Thanks!

Scot Kreienkamp | Senior Systems Engineer | La-Z-Boy Corporate
One La-Z-Boy Drive | Monroe, Michigan 48162 | * 734-384-6403 | | * 7349151444 | * Scot(dot)Kreienkamp(at)la-z-boy(dot)com<mailto:%7BE-mail%7D>
www<http://www.la-z-boy.com/>.la-z-boy.com<http://www.la-z-boy.com/> | facebook.<https://www.facebook.com/lazboy>com<https://www.facebook.com/lazboy>/<https://www.facebook.com/lazboy>lazboy<http://facebook.com/lazboy> | twitter.com/lazboy<https://twitter.com/lazboy> | youtube.com/<https://www.youtube.com/user/lazboy>lazboy<https://www.youtube.com/user/lazboy>

[cid:lzbVertical_hres.jpg]

This message is intended only for the individual or entity to which it is addressed. It may contain privileged, confidential information which is exempt from disclosure under applicable laws. If you are not the intended recipient, you are strictly prohibited from disseminating or distributing this information (other than to the intended recipient) or copying this information. If you have received this communication in error, please notify us immediately by e-mail or by telephone at the above number. Thank you.

Browse pgsql-general by date

  From Date Subject
Next Message David Gauthier 2018-10-30 19:05:20 editable spreadsheet style interface
Previous Message Marian Forums 2018-10-30 16:27:32 Re: Question about servicescript for stopping and starting postgresql instance