postgresqlgoogle-cloud-console

Upgrade user to superuser in Postgres in Google Cloud


How do I create a user with the superuser role in Postgres server with Google Cloud console?

When I create databases in Google Cloud, the default user is a non-superuser. From this role, it is not possible to upgrade.


Solution

  • no way:

    https://cloud.google.com/sql/docs/postgres/users

    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.