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.
Asked
Active
Viewed 2,413 times
1 Answers
5
no way:
https://cloud.google.com/sql/docs/postgres/users
The postgres user is part of the
cloudsqlsuperuserrole, and has the following attributes (privileges): CREATEROLE, CREATEDB, and LOGIN. It does not have theSUPERUSERorREPLICATIONattributes.
Vao Tsun
- 37,644
- 8
- 70
- 98
-
Thanks. I read it, but I hoped somehow there was a way to corner it, maybe in powerShell connected to google cloud. :-) – Troels Jan 26 '18 at 13:24
-
Really?? No way? – Carles Figuera Jun 12 '18 at 16:02
-
1An opdate to this: I changed from Google Cloud Postgres to a VS and installed Postgres on that one instead. It works like a charm. – Troels Aug 14 '19 at 06:31