在Azure数据库中为PostgreSQL更改wal_level配置 [英] Changing wal_level configuration in Azure Database for PostgreSQL

问题描述

您好，

我正在为我的公司开展一个涉及将Realm与PostgreSQL同步的项目。我们希望将Azure数据库用于PostgreSQL作为我们的PostgresSQL数据库。但是，我们遇到了一个复杂的问题，Realm提供的数据适配器需要
，我们在postgresql.conf中设置'wal_level = logical'。我从可用于Azure数据库for PostgreSQL的文档中注意到，我们将无法进行需要超级用户权限的更改（因此使用PostgreSQL中的ALTER SYSTEM命令不可用），
并且wal_level设置在设置中不可用我可以通过Azure门户进行更改。

所有这一切，我们有什么方法可以为Azure数据库设置wal_level = logical for PostgreSQL，还是我们应该探索其他选项？谢谢！
$


Realm PostgreSQL连接器文档：  https://docs.realm.io/sync/backend-integration/postgres-connector

解决方案

Hello Kalex，

感谢您对Azure产品和服务的关注。

我将在产品团队内部对此进行检查并回复给您。

Hello,

I am working on a project for my company that involves synchronizing Realm with PostgreSQL. We would like to use Azure Database for PostgreSQL as our PostgresSQL database. However, we've run into a complication where the data adapter Realm provides requires that we set 'wal_level = logical' in postgresql.conf. I noted from the documentation available for Azure Database for PostgreSQL that we will be unable to make changes that require superuser privileges (so using the ALTER SYSTEM command in PostgreSQL is unavailable), and the wal_level setting was not available in the settings available for me to change via the Azure Portal.

All that said, is there any way we can set wal_level = logical for Azure Database For PostgreSQL, or should we be exploring other options? Thank you!

Realm PostgreSQL Connector Documentation: https://docs.realm.io/sync/backend-integration/postgres-connector

解决方案

Hello Kalex,

Thank you for your interest in Azure products and services.

I will check this internally with the product team and back to you with a response.

这篇关于在Azure数据库中为PostgreSQL更改wal_level配置的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！