Changing wal_level configuration in Azure Database for PostgreSQL

Question

According the the question Changing wal_level configuration in Azure Database for PostgreSQL referred from Debezium > Test with Postgres on Azure support for

wal_level = logical
max_wal_senders = 1
max_replication_slots = 1 

was expected by 4Q/2019.

What is the status? Has it been implemented?

Answer 1

Hi @Emanuele Quinto , you can change the appropriate configuration as mentioned below through Azure CLI:

az postgres server configuration set --resource-group mygroup --server-name myserver --name azure.replication_support --value logical  

az postgres server restart --resource-group mygroup --name myserver  

If you want to change these through azure Portal, please refer to below screenshot:

Please refer to below article for complete details:

https://learn.microsoft.com/en-us/azure/postgresql/concepts-logical