MIME-Version: 1.0
From: Phillip Diffley <phillip6402@gmail.com>
Date: Mon, 24 Mar 2025 19:31:57 -0500
Message-ID: <CAGAwPgRvitw7PMPiJyjFP0=gOArha9t5JzKu73iwkH17pUOWNQ@mail.gmail.com>
Subject: Create replication slot options
To: pgsql-general@postgresql.org
Content-Type: multipart/alternative; boundary="000000000000d527b606311fd954"
Archived-At: <https://www.postgresql.org/message-id/CAGAwPgRvitw7PMPiJyjFP0%3DgOArha9t5JzKu73iwkH17pUOWNQ%40mail.gmail.com>
Precedence: bulk

--000000000000d527b606311fd954
Content-Type: text/plain; charset="UTF-8"

I am testing out some streaming logical replication commands and am having
trouble specifying options when calling CREATE_REPLICATION_SLOT
<https://www.postgresql.org/docs/current/protocol-replication.html#PROTOCOL-REPLICATION-CREATE-REPLICATION-SLOT>
.

I connect to the database with
psql "dbname=replication_test_db replication=database"

Then I am able to successfully run
CREATE_REPLICATION_SLOT test_slot LOGICAL pgoutput;

But if I try to specify the snapshot option with
CREATE_REPLICATION_SLOT test_slot_2 LOGICAL pgoutput SNAPSHOT 'nothing';
the command fails with "ERROR:  syntax error"

I have tried several combinations of brackets commas and equals signs but
have not been able to get the command with additional options to work. What
is the right syntax to use here?

Thanks,
Phillip

--000000000000d527b606311fd954
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr">I am testing out some streaming logical replication comman=
ds and am having trouble specifying options when calling <a href=3D"https:/=
/www.postgresql.org/docs/current/protocol-replication.html#PROTOCOL-REPLICA=
TION-CREATE-REPLICATION-SLOT">CREATE_REPLICATION_SLOT</a>.<br><div><br></di=
v><div>I connect to the database with</div>psql &quot;dbname=3Dreplication_=
test_db replication=3Ddatabase&quot;<br><div><br></div><div>Then I am able =
to successfully run</div>CREATE_REPLICATION_SLOT test_slot LOGICAL pgoutput=
;<br><br>But if I try to specify the snapshot option with<br>CREATE_REPLICA=
TION_SLOT test_slot_2 LOGICAL pgoutput SNAPSHOT &#39;nothing&#39;;<br><div>=
the command fails with &quot;ERROR: =C2=A0syntax error&quot;</div><div><br>=
</div><div>I have tried several combinations of brackets commas and equals =
signs but have not been able to get the command with additional options to =
work. What is the right syntax to use here?</div><div><br></div><div>Thanks=
,</div><div>Phillip<br></div><div><br></div></div>

--000000000000d527b606311fd954--