public inbox for [email protected]
help / color / mirror / Atom feedFrom: Christophe Pettus <[email protected]>
To: Phillip Diffley <[email protected]>
Cc: [email protected]
Subject: Re: Create replication slot options
Date: Mon, 24 Mar 2025 17:37:30 -0700
Message-ID: <[email protected]> (raw)
In-Reply-To: <CAGAwPgRvitw7PMPiJyjFP0=gOArha9t5JzKu73iwkH17pUOWNQ@mail.gmail.com>
References: <CAGAwPgRvitw7PMPiJyjFP0=gOArha9t5JzKu73iwkH17pUOWNQ@mail.gmail.com>
> On Mar 24, 2025, at 17:31, Phillip Diffley <[email protected]> wrote:
>
> I am testing out some streaming logical replication commands and am having trouble specifying options when calling 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?
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.
view thread (2+ messages)
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected]
Subject: Re: Create replication slot options
In-Reply-To: <[email protected]>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox