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 5,882 times
2 Answers
10
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
- 47,234
- 13
- 100
- 132
-
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
0
Here's my own script:
GRANT cloudsqlimportexport, cloudsqlsuperuser, pg_read_all_data, pg_write_all_data, postgres TO myawsumuser WITH ADMIN OPTION;
GRANT ALL PRIVILEGES ON DATABASE mytestdb1 TO myawsumuser WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON DATABASE postgres TO myawsumuser WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA public TO myawsumuser with grant option;
GRANT USAGE ON SCHEMA public TO myawsumuser with grant option;
GRANT ALL PRIVILEGES ON ALL SEQUENCES IN SCHEMA public TO myawsumuser with admin option;
GRANT ALL PRIVILEGES ON ALL SEQUENCES IN SCHEMA public TO myawsumuser with grant option;
ALTER DEFAULT PRIVILEGES IN SCHEMA public GRANT ALL PRIVILEGES ON TABLES TO myawsumuser with grant option;
ALTER DEFAULT PRIVILEGES IN SCHEMA public GRANT ALL PRIVILEGES ON SEQUENCES TO myawsumuser with grant option;
Good links: https://cloud.google.com/sql/docs/postgres/users
JDOaktown
- 4,262
- 7
- 37
- 52