astopo/psql.md

Created July 27, 2015 02:16

Star () You must be signed in to star a gist
Fork () You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/astopo/bb8e8c76bf6124082e2c.js"></script>
Save astopo/bb8e8c76bf6124082e2c to your computer and use it in GitHub Desktop.

Download ZIP

Postgres psql - export and import database

Raw

psql.md

Export a database to .sql file

pg_dump -U username dbname > outfile.sql

Importing a db.sql file

psql -U username dbname < db.sql

Importing to Heroku

heroku pg:psql --app APPNAME < path/to/db.sql

[a2hosting article](https://www.a2hosting.com/kb/developer-corner/postgresql/import-and-export-a-postgresql-database

rajesh-ivd commented Oct 13, 2023

I hope this message finds you well. I'm currently facing an issue when trying to import a PostgreSQL database backup, and I'm seeking assistance to resolve it.

The problem I'm encountering is as follows:

Error Message:

The error seems to indicate that I'm performing a data-only restore, and I may be missing schema objects. I would like to restore both data and schema objects, and I'm unsure how to proceed.

Any suggestions, insights, or explanations on how to address this issue would be highly valuable. Thank you in advance for your help!