How to connect to postgresql google cloud sql instance? Need to import postgresql dump using pg_restore command

Question

I have a google cloud sql postgresql instance. When I try to import postgresql dump I get following error.

I am able to connect to instance with the command given below.

gcloud sql connect instance-name --user postgres

It takes me to the psql command line client where I can not use database restore command like pg_restore

Does anyone have an idea on how can I actually connect to Google Cloud SQL instance so that I can perform operation such as pg_restore?

Near the gift icon, in the upper right corner, you have the command prompt button. That will allow you to connect to the console so you could be abble to launch pg_restore... — Arkhena
– Arkhena, Commented Jun 22, 2017 at 7:13

Phil · Accepted Answer · 2017-10-15 09:40:50Z

7

if you need pg_restore can simply use:

gcloud sql connect instance-name --user postgres < dbbackup.sql

where dbbackup.sql is a file obtained from:

pg_dump olddb --format=plain --no-owner -v >> dbbackup.sql

answered Oct 15, 2017 at 9:40

Phil

1251 silver badge11 bronze badges

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

2 Comments

london_utku Over a year ago

Where does this file exactly created at ? "dbbackup.sql"

Jerod Venema Over a year ago

This will import into the postgres database, you need to add PGDATABASE=yourdb to the gcloud command to specify your database. Note that despite google's docs, you CANNOT specify the database on the command line: stackoverflow.com/questions/47299696/…

Collectives™ on Stack Overflow

How to connect to postgresql google cloud sql instance? Need to import postgresql dump using pg_restore command

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related