Re: Does logical replication slot itself would be physicallyreplicated to slaves? - Mailing list pgsql-hackers

From Michael Paquier
Subject Re: Does logical replication slot itself would be physicallyreplicated to slaves?
Date
Msg-id 20180908200721.GA19122@paquier.xyz
Whole thread Raw
In response to Does logical replication slot itself would be physically replicatedto slaves?  (Jinhua Luo <luajit.io@gmail.com>)
List pgsql-hackers
On Sat, Sep 08, 2018 at 05:37:43PM +0800, Jinhua Luo wrote:
> The logical streaming replication is used to replicate changes between
> DC. I need to confirm that whether the logical replication slot would
> be saved in wal and replicated to slave via physical replication? So
> that in case of failover, the new master still holds the slot needed
> by peer.

Replication slot creation is not an operation WAL-logged.  Please note
that slots are not kept in base backups when taking them using the
replication protocol (see basebackup.c for the list of things filtered),
so as the standby or the new instance deployed with this base backup
does not bloat pg_wal with data which may not be around anymore.
--
Michael

Attachment

pgsql-hackers by date:

Previous
From: Michael Paquier
Date:
Subject: Re: Prevent concurrent DROP SCHEMA when certain objects are beinginitially created in the namespace
Next
From: Tom Lane
Date:
Subject: Re: Prevent concurrent DROP SCHEMA when certain objects are being initially created in the namespace