google-cloud-sql - 为 GCP Cloud SQL 设置 session_replication_role

Question

我正在尝试在 GCP Cloud SQL Postgres 9.6 实例中运行 SET session_replication_role = 'replica';，但是我遇到了这个错误 ERROR: permission denied to set parameter "session_replication_role " 即使 postgres 用户是 cloudsql 管理员用户。我是否必须启动自己的 self 管理实例来解决问题，还是有解决办法？

Answer 1

很遗憾，它与服务是否处于 Beta 版无关，您无法在 GCP Cloud SQL 中设置 session_replication_role。

你需要有 superuser privileges to do that operation ，但 GCP Cloud 只允许 cloudsqlsuperuser 权限。这是features as follows :

When you create a new Cloud SQL for PostgreSQL instance, the default postgres user is already created for you, though you must set its password.

The postgres user is part of the cloudsqlsuperuser role, and has the following attributes (privileges): CREATEROLE, CREATEDB, and LOGIN. It does not have the SUPERUSER or REPLICATION attributes.

您可以在 this 中找到更多信息博文。