ERROR: (gcloud.sql.instances.import) ERROR_RDBMS
I understand that's related to permissions, so I inspected the logs, and I see ERROR: must be owner of extension plpgsql. This is where I get stuck - any suggestions on how to fix this?
Thanks,
Mike
--
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsub...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/6087c10d-13e9-4479-84cf-fa2ae9c2b62b%40googlegroups.com.
pg_dump -Fp --no-acl --no-owner -h localhost -d test2 -U myusername --file sth.sql
Returns :
SET SET SET SET SET SET SET SET CREATE EXTENSION ERROR: must be owner of extension plpgsql
Tbh, I find it baffling that the command provided in [the documentation](https://cloud.google.com/sql/docs/postgres/import-export/creating-sqldump-csv) doesn't work either (returns the same error as above).
I've been trying to overcome this for the past three hours using numerous methods. I've recreated an instance, dumped a test and production DB using various combinations, tried to DROP plpsql and change user privileges. Nothing worked so far.
I've also carefully looked at this [S.O thread](https://stackoverflow.com/questions/13410631/how-to-solve-privileges-issues-when-restore-postgresql-database)
Contrarily to what is described for Amazon RDS, the error seems blocking (I can't see any changes in the DB).
What is the proper way to dump a simple DB as of now ?
Thank you for your help