Content-Type: text/plain;
	charset=us-ascii
Mime-Version: 1.0 (Mac OS X Mail 16.0 \(3776.700.51.11.1\))
Subject: Re: Create replication slot options
From: Christophe Pettus <xof@thebuild.com>
In-Reply-To: <CAGAwPgRvitw7PMPiJyjFP0=gOArha9t5JzKu73iwkH17pUOWNQ@mail.gmail.com>
Date: Mon, 24 Mar 2025 17:37:30 -0700
Cc: pgsql-general@postgresql.org
Content-Transfer-Encoding: quoted-printable
Message-Id: <74B944FA-9B36-4919-97EF-8E3099A45314@thebuild.com>
References: <CAGAwPgRvitw7PMPiJyjFP0=gOArha9t5JzKu73iwkH17pUOWNQ@mail.gmail.com>
To: Phillip Diffley <phillip6402@gmail.com>
Archived-At: <https://www.postgresql.org/message-id/74B944FA-9B36-4919-97EF-8E3099A45314%40thebuild.com>
Precedence: bulk


> On Mar 24, 2025, at 17:31, Phillip Diffley <phillip6402@gmail.com> =
wrote:
>=20
> I am testing out some streaming logical replication commands and am =
having trouble specifying options when calling CREATE_REPLICATION_SLOT.
>=20
> I connect to the database with
> psql "dbname=3Dreplication_test_db replication=3Ddatabase"
>=20
> Then I am able to successfully run
> CREATE_REPLICATION_SLOT test_slot LOGICAL pgoutput;
>=20
> 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"
>=20
> 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?

The options after LOGICAL <output_plugin > need to be in parentheses:

	CREATE_REPLICATION_SLOT test_slot_2 LOGICAL pgoutput ( SNAPSHOT =
'nothing' );

In the PostgreSQL documentation, parentheses mean literal parentheses =
rather than being part of the grammar.=