Postgres Pro
Downloads
Home   >   mailing lists

Create replication slot options - Mailing list pgsql-general

From Phillip Diffley
Subject Create replication slot options
Date
Msg-id CAGAwPgRvitw7PMPiJyjFP0=gOArha9t5JzKu73iwkH17pUOWNQ@mail.gmail.com
Whole thread Raw
Responses Re: Create replication slot options
List pgsql-general
Tree view
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?

Thanks,
Phillip

pgsql-general by date:

Previous
From: Laurenz Albe
Date:
Subject: Re: Experience and feedback on pg_restore --data-only
Next
From: Christophe Pettus
Date:
Subject: Re: Create replication slot options