upgrade user to superuser in postgres google cloud

8
votes

How do I create a user with superuser role in Postgres serwer 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.

1
postgresqlgoogle-cloud-console

1 Answers

8
votes

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.