public inbox for [email protected]  

help / color / mirror / Atom feed

From: Phillip Diffley <[email protected]>
To: [email protected]
Subject: Create replication slot options
Date: Mon, 24 Mar 2025 19:31:57 -0500
Message-ID: <CAGAwPgRvitw7PMPiJyjFP0=gOArha9t5JzKu73iwkH17pUOWNQ@mail.gmail.com> (raw)

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-REPLIC...;
.

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

view thread (2+ messages)  latest in thread

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]
  Subject: Re: Create replication slot options
  In-Reply-To: <CAGAwPgRvitw7PMPiJyjFP0=gOArha9t5JzKu73iwkH17pUOWNQ@mail.gmail.com>

* 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