How do I set the wal_level in PostgreSQL Single Server?

Question

I am trying migrate my PostgreSQL Single Server to a Flexible Server. I am using Azure's migration portal, but am running into an error:

Error 603107: GUC settings error. Source server WAL level parameter is set to 'replica'. Set GUC parameter WAL level to be 'logical'.

However, for a single server there is no server parameter to change the WAL level. I am confused as to why I cannot set the level, but I can't move forward with migration unless the level is set to logical. Any suggestions?

Answer 1

Thanks for posting your question in the Microsoft Q&A forum.

Enable logical replication on your PostgreSQL Single Server. For Single Server instances, you can't directly modify the WAL level parameter. Instead, you need to enable logical replication, which will automatically set the WAL level to logical

After enabling logical replication and restarting the server, the WAL level will be set to logical

---

Please don't forget to close up the thread here by upvoting and accept it as an answer if it is helpful