Errror when trying to create a logical replication slot

Поиск
Список
Период
Сортировка
От Craig Jackson
Тема Errror when trying to create a logical replication slot
Дата
Msg-id c3389938-1a1c-4edb-a573-610e37cb9f2c@Spark
обсуждение исходный текст
Ответы Re: Errror when trying to create a logical replication slot
Список 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 по дате отправления:

Предыдущее
От: "David G. Johnston"
Дата:
Сообщение: Re: PgAdmin 4 EOL Versions?
Следующее
От: dbatoCloud Solution
Дата:
Сообщение: