set failover=true on existing logical replication slot PG18 - Mailing list pgsql-general

From Scot Kreienkamp
Subject set failover=true on existing logical replication slot PG18
Date
Msg-id SJ0PR15MB5245B5DA980217228FD9B7AC9AE22@SJ0PR15MB5245.namprd15.prod.outlook.com
Whole thread
Responses Re: set failover=true on existing logical replication slot PG18
List pgsql-general

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!

 

 

 

 

 


Scot Kreienkamp | Applications Infrastructure Architect | La-Z-Boy Corporate 
(734) 384-6403 | 1-734-915-1444 | Scot.Kreienkamp@la-z-boy.com
One La-Z-Boy Drive | Monroe, Michigan 48162 | la-z-boy.com
facebook.com/lazboy  | instagram.com/lazboy | youtube.com/lazboy

LaZboy Logo

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.

Attachment

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: can a linux program, running on the client side, generate data to load a temp table ?
Next
From: Paul A Jungwirth
Date:
Subject: Postgres Patch Review Workshop: July 2026