RE: set failover=true on existing logical replication slot PG18

From: Scot Kreienkamp <Scot(dot)Kreienkamp(at)la-z-boy(dot)com>
To: "Hayato Kuroda (Fujitsu)" <kuroda(dot)hayato(at)fujitsu(dot)com>, 'Matthew Tice' <mjtice(at)gmail(dot)com>
Cc: "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: RE: set failover=true on existing logical replication slot PG18
Date: 2026-06-22 13:42:21
Message-ID: SJ0PR15MB52453731991382CE2B76586D9AEF2@SJ0PR15MB5245.namprd15.prod.outlook.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-general

<html><head><meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<meta name="Generator" content="Microsoft Exchange Server">
<!-- converted from text -->
<style>.EmailQuote { margin-left: 1pt; padding-left: 4pt; border-left: #800000 2px solid; }</style></head>
<body>
<font size="2"><div class="PlainText">&quot;normal backend cannot understand them.&quot;<br>
<br>
Thank you Hayato, that's what I was missing.&nbsp;&nbsp; I got it working now.<br>
<br>

<p style="FONT-SIZE: 10pt; FONT-FAMILY: ARIAL"><span style="FONT-FAMILY: Calibri"><font face="HelveticaNeueLT Std"><span style="FONT-FAMILY: Calibri"><strong><br></strong></span></font></span></p><p style="FONT-SIZE: 10pt; FONT-FAMILY: ARIAL"><span style="FONT-FAMILY: Calibri"><font face="HelveticaNeueLT Std"><span style="FONT-FAMILY: Calibri"><strong>Scot Kreienkamp&nbsp;| Applications Infrastructure Architect | La-Z-Boy Corporate</strong></span><br style="FONT-SIZE: 9pt"><span style="FONT-SIZE: 9pt"><span style="FONT-FAMILY: Calibri">One La-Z-Boy Drive | Monroe, Michigan 48162</span>
|&nbsp;</span></font></span><span style="font-family: Calibri, sans-serif; font-size: 12px;"> (734) 384-6403 | 1-734-915-1444 | Scot(dot)Kreienkamp(at)la-z-boy(dot)com</span><span style="FONT-FAMILY: Calibri"><font face="HelveticaNeueLT Std"><br></font></span></p>
<p style="FONT-SIZE: 10pt; FONT-FAMILY: ARIAL"><font face="Arial"><span style="FONT-FAMILY: HelveticaNeueLT Std"><span style="FONT-SIZE: 9pt"><span style="FONT-FAMILY: Wingdings"><span style="FONT-FAMILY: HelveticaNeueLT Std"></span></span></span></span></font>&nbsp;</p>
<br>
-----Original Message-----<br>
From: Hayato Kuroda (Fujitsu) &lt;kuroda(dot)hayato(at)fujitsu(dot)com&gt; <br>
Sent: Monday, June 22, 2026 1:44 AM<br>
To: 'Matthew Tice' &lt;mjtice(at)gmail(dot)com&gt;<br>
Cc: pgsql-general(at)lists(dot)postgresql(dot)org<br>
Subject: RE: set failover=true on existing logical replication slot PG18<br>
<br>
Dear Matthew, Scot,<br>
<br>
There are no ways to control default value of failover. Regarding the way for<br>
changing the value, yes, ALTER_REPLICATION_SLOT replication command is an only<br>
way to do that. Note that it's acceptable only when the backend is in the<br>
replication mode - normal backend cannot understand them.<br>
<br>
Best regards,<br>
Hayato Kuroda<br>
FUJITSU LIMITED<br>
<br>
</div></font>

<P style="FONT-SIZE: 10pt; FONT-FAMILY: ARIAL">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. </P></body>
</html>

Attachment Content-Type Size
unknown_filename text/html 2.9 KB

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Matthias Apitz 2026-06-23 10:30:59 Re: PostgreSQL server with SSL
Previous Message shashi B savarn 2026-06-22 08:19:19 Intermittent hang in SQLConnect (ODBC, PostgreSQL 15, Windows)