Google cloud sql: How to import postgres database?

Question

I have a Postgresql database that is running on premises which I want to import into Google Cloud SQL. My database is called test and is owned by user test

Steps I've taken:

created Cloud SQL instance
created database on Cloud SQL instance:

curl --header "Authorization: Bearer XXXXX" \ --header 'Content-Type: application/json' \ --data '{"project": "YYYYYY", "instance": "dev", "name": "test"}' \

https://www.googleapis.com/sql/v1beta4/projects/YYYYYY/instances/dev/databases -X POST
Created test user:

gcloud beta sql users create test host --instance=dev --password=test
Dumped DB from source db with pg_dump
Tried to restored ... got this error:
ERROR: must be member of role test

So how do I execute import under test user?

gerasalus · Accepted Answer · 2017-04-07 21:00:26Z

6

To answer my own question...

Just use --no-acl --no-owner with pg_dump to remove all ownership altering, and it will work.

answered Apr 7, 2017 at 21:00

gerasalus

7,7076 gold badges49 silver badges67 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Google cloud sql: How to import postgres database?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related