Is it possible to import postgresql custom-format dump file in cloud sql without using pg_restore?

Question

I downloaded the postgresql .dmp file from the chembl database.

I want to import this into gcp cloudsql.

When I run it with the console and gcloud command, I get the following error:

Importing data into Cloud SQL instance...failed.
ERROR: (gcloud.sql.import.sql) [ERROR_RDBMS] exit status 1
The input is a PostgreSQL custom-format dump.
Use the pg_restore command-line client to restore this dump to a database.

Can I import custom-format dmp files without using the pg_restore command?

https://cloud.google.com/sql/docs/postgres/import-export/importing

There is a description of pg_restore in the document on that site, but I didn't get it right.

In the case of custom-format files, is it necessary to pg_restore after uploading them to the cloud shell?

mDeram · Accepted Answer · 2023-07-06 16:58:46Z

1

According to the CloudSQL docs:

Only plain SQL format is supported by the Cloud SQL Admin API. The custom format is allowed if the dump file is intended for use with pg_restore.

If you cannot use pg_restore for some reason, I would spin up a local Postgres instance (i.e., on your laptop) and use pg_restore to restore the database.

After loading into your local database, you can use pg_dump to dump to file in plaintext format, then load into CloudSQL with the console or gcloud command.

edited Jul 6, 2023 at 16:58

mDeram

911 silver badge10 bronze badges

answered Mar 31, 2021 at 23:14

richyen

10.3k4 gold badges18 silver badges36 bronze badges

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

Collectives™ on Stack Overflow

Is it possible to import postgresql custom-format dump file in cloud sql without using pg_restore?

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