Errror when trying to create a logical replication slot

From: Craig Jackson <crajac66(at)gmail(dot)com>
To: Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Errror when trying to create a logical replication slot
Date: 2020-12-16 22:10:31
Message-ID: c3389938-1a1c-4edb-a573-610e37cb9f2c@Spark
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message dbatoCloud Solution 2020-12-16 23:48:41
Previous Message David G. Johnston 2020-12-16 17:52:10 Re: PgAdmin 4 EOL Versions?