Re: [google-cloud-sql-discuss] Re: ERROR: must be owner of extension plpgsql

so there is no way to import any big external db into gcloud, also, there is no way for master-slave config streaming replication... and 1 year passed. 

On Friday, April 13, 2018 at 12:16:25 PM UTC+3, Tianzhou Chen wrote:

The proper way to dump a single DB is via the export option from your console or via gcloud, which would skip dumping plpgsql stuff.

Using pg_dump directly will not work as it has the permission issue of plpgsql.

On Wednesday, October 11, 2017 at 6:02:55 AM UTC-7, Stanislas drg wrote:

The above code doesn't work in my case.

The following command :

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

--
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+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/d065e834-e092-42b7-aeb1-2b7952a31b67%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.