Date: Wed, 16 Dec 2020 15:10:31 -0700
From: Craig Jackson <crajac66@gmail.com>
To: Pgsql-admin <pgsql-admin@lists.postgresql.org>
Message-ID: <c3389938-1a1c-4edb-a573-610e37cb9f2c@Spark>
In-Reply-To: <31314397-9cc1-479f-ab41-b415458a4da7@Spark>
References: <31314397-9cc1-479f-ab41-b415458a4da7@Spark>
Subject: Errror when trying to create a logical replication slot
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary="5fda85dd_7fdcc233_33b"
Precedence: bulk

--5fda85dd_7fdcc233_33b
Content-Type: text/plain; charset="utf-8"
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

Hi All,

We get the following error when trying to test creating a logical replica=
tion slot in Postgres version 11.9

>SELECT * =46ROM pg=5Fcreate=5Flogical=5Freplication=5Fslot('regression=5F=
slot', 'test=5Fdecoding');
ERROR: cannot create logical replication slot in transaction that has per=
formed writes

We are running the above command from psql and have tried issuing a rollb=
ack prior to running the command but still get the same error.

We have the following settings enabled:

>show wal=5Flevel;
=C2=A0wal=5Flevel
-----------
=C2=A0logical

>show max=5Freplication=5Fslots;
=C2=A0max=5Freplication=5Fslots
-----------------------
=C2=A025

Any suggestions on what may be causing the above error are appreciated.

Regards,


Craig Jackson

--5fda85dd_7fdcc233_33b
Content-Type: text/html; charset="utf-8"
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

<html xmlns=3D=22http://www.w3.org/1999/xhtml=22>
<head>
<title></title>
</head>
<body>
<div name=3D=22messageBodySection=22>
<div dir=3D=22auto=22>Hi All,<br />
<br />
We get the following error when trying to test creating a logical replica=
tion slot in Postgres version 11.9<br />
<br />
&gt;SELECT * =46ROM pg=5Fcreate=5Flogical=5Freplication=5Fslot('regressio=
n=5Fslot', 'test=5Fdecoding');<br />
ERROR: cannot create logical replication slot in transaction that has per=
formed writes<br />
<br />
We are running the above command from psql and have tried issuing a rollb=
ack prior to running the command but still get the same error.&=23160;<br=
 />
<br />
We have the following settings enabled:<br />
<br />
&gt;show wal=5Flevel;<br />
&=23160;wal=5Flevel<br />
-----------<br />
&=23160;logical<br />
<br />
&gt;show max=5Freplication=5Fslots;<br />
&=23160;max=5Freplication=5Fslots<br />
-----------------------<br />
&=23160;25<br />
<br />
Any suggestions on what may be causing the above error are appreciated.&=23=
160;<br />
<br />
Regards,<br />
<br /></div>
</div>
<div name=3D=22messageSignatureSection=22><br />
Craig Jackson&=23160;</div>
</body>
</html>

--5fda85dd_7fdcc233_33b--