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

3
votes

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

enter image description here

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?

1
databasepostgresqlgoogle-cloud-platformgoogle-cloud-sql
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

1 Answers

4
votes

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