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

The only thing that solved the issue in my case was commenting out all lines relating to plpgsql, by manually editing the dump.

I hope this helps anyone.

On Wednesday, 11 October 2017 14:02:55 UTC+1, 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/7e8a0980-d284-42bf-bfd9-c40ae97dfd92%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.