jeremykendall/postgres-dump-restore.markdown

Last active April 27, 2021 20:27

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/jeremykendall/1a1151c2082c40bb566a.js"></script>
Save jeremykendall/1a1151c2082c40bb566a to your computer and use it in GitHub Desktop.

Download ZIP

PostgreSQL: dump and restore (to db with different name and roles even)

Raw

postgres-dump-restore.markdown

Postgres Export and Import

Export

pg_dump -U [superuser] -Fc [dbname] > db.dump

Import

This syntax allows importing to a database with the name of your choice.

Create the database (if it does not exist):

createdb -T template0 [dbname]

Import:

pg_restore --clean --if-exists --no-acl --no-owner --verbose -d [dbname] -U [superuser] db.dump

Reference

at-longhoang commented Feb 24, 2017

i got this error pg_restore: [custom archiver] could not read from input file: end of file

juniorUsca commented Jul 11, 2018 •

edited

Loading

@at-longhoang your file dumped db.dump has been corrupted. You need to regenerate it

aksharj commented Sep 24, 2020

hi,

I am facing the same issue pg_restore: [custom archiver] could not read from input file: end of file and regenerating did not fix the issue. Any ideas?