Errror when trying to create a logical replication slot - Mailing list pgsql-admin

From Craig Jackson
Subject Errror when trying to create a logical replication slot
Date
Msg-id c3389938-1a1c-4edb-a573-610e37cb9f2c@Spark
Whole thread Raw
Responses Re: Errror when trying to create a logical replication slot
List pgsql-admin
Hi All,

We get the following error when trying to test creating a logical replication slot in Postgres version 11.9

>SELECT * FROM pg_create_logical_replication_slot('regression_slot', 'test_decoding');
ERROR: cannot create logical replication slot in transaction that has performed writes

We are running the above command from psql and have tried issuing a rollback prior to running the command but still get the same error. 

We have the following settings enabled:

>show wal_level;
 wal_level
-----------
 logical

>show max_replication_slots;
 max_replication_slots
-----------------------
 25

Any suggestions on what may be causing the above error are appreciated. 

Regards,


Craig Jackson 

pgsql-admin by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: PgAdmin 4 EOL Versions?
Next
From: dbatoCloud Solution
Date:
Subject: