public inbox for [email protected]  

help / color / mirror / Atom feed
From: Matthew Tice <[email protected]>
Cc: [email protected] <[email protected]>
Subject: Re: set failover=true on existing logical replication slot PG18
Date: Sat, 20 Jun 2026 06:16:36 -0600
Message-ID: <[email protected]> (raw)
In-Reply-To: <SJ0PR15MB5245B5DA980217228FD9B7AC9AE22@SJ0PR15MB5245.namprd15.prod.outlook.com>
References: <a2cd8084-b93e-4da0-8999-569a6e58ef6b.8f62f83c-ab51-428e-98d1-ab1abb243a49.b8cec5a7-e117-4586-92d1-d2ec185f70de@emailsignatures365.codetwo.com>
	<a2cd8084-b93e-4da0-8999-569a6e58ef6b.b1460fbe-55a2-4060-995f-39f4e2f3c7f9.666faa2f-fecd-409d-a065-bc423f5acc45@emailsignatures365.codetwo.com>
	<SJ0PR15MB5245B5DA980217228FD9B7AC9AE22@SJ0PR15MB5245.namprd15.prod.outlook.com>



> On Jun 19, 2026, at 9:24 AM, Scot Kreienkamp <[email protected]> wrote:
> 
> Hello list,
>  
> I am trying to make use of the synchronized logical replication slots on PG18.  I have all the requirements met, and if I create a logical replication slot manually with failover=true it is replicated to the second node.  Unfortunately I have two connections that create their own logical replication slots with failover false.  AWS DMS is one for example, but both have the same problem.  Is there any way to change the failover parameter on an existing logical replication slot from false to true?  Or set it so that all logical replications slots are synchronized so that they don’t have to be individually created or altered for replication=true?  Or force them all to true?  Any other ideas?
>  
> Thanks!
>  

I had the same problem recently with our Confluent-generated replication slots.  I didn’t think there was but I just found this in the docs:

ALTER_REPLICATION_SLOT slot_name ( option [, ...] ) 
Change the definition of a replication slot. See Section 26.2.6 for more about replication slots. This command is currently only supported for logical replication slots.

slot_name
The name of the slot to alter. Must be a valid replication slot name (see Section 26.2.6.1).

The following option is supported:

FAILOVER [ boolean ]
If true, the slot is enabled to be synced to the standbys so that logical replication can be resumed after failover.

https://www.postgresql.org/docs/17/protocol-replication.html
53.4. Streaming Replication Protocol
postgresql.org

Attachments:

  [image/png] elephant.png (64.3K, ../[email protected]/3-elephant.png)
  download | view image

view thread (4+ messages)  latest in thread

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected]
  Subject: Re: set failover=true on existing logical replication slot PG18
  In-Reply-To: <[email protected]>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox