pg_dump -U username dbname > outfile.sql
psql -U username dbname < db.sql
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
Created
July 27, 2015 02:16
-
-
Save astopo/bb8e8c76bf6124082e2c to your computer and use it in GitHub Desktop.
Postgres psql - export and import database
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
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!