pg_restore: [archiver] input file is too short error in postgres

postgresql pg-restore database-dump
the_unknown_spirit picture the_unknown_spirit · Apr 7, 2016 · Viewed 11.2k times · Source

I am trying to dump the database in my local system by using the command :

pg_restore --host=localhost --port=5432 --dbname=dev_db --no-owner --no-privileges db_dump_new.backup

but I am getting the error :

pg_restore: [archiver] input file is too short (read 0, expected 5)

What am I doing wrong?

Answer

lmat - Reinstate Monica picture lmat - Reinstate Monica · Jan 8, 2020

If you're using docker and redirecting the dump file from your local machine, don't forget -i. This won't work:

docker exec <container> pg_restore -U "$USER" < ./localfile.dump;

Be sure that the docker container can see standard in with the -i option! This should work:

docker exec -i <container> pg_restore -U "$USER" < ./localfile.dump;

Related questions

input file appears to be a text format dump. Please use psql

I take backup using pg_dump db_production > postgres_db.dump and then I copy it to localhost using scp. Now when I import on my local db it gives an error pg_restore: [archiver] input file appears to …

Read More
Getting "[archiver] unsupported version (1.13) in file header" when running pg_restore

I just upgraded to postgres 10.2 on mac os which matches 10.2 on heroku. I'm trying to download a copy of the database and restore it locally. Before the upgrade the restore would work fine. I run pg_restore --verbose --clean --no-acl …

Read More
I want to restore the database with a different schema

I have taken a dump of a database named temp1, by using the follwing command $ pg_dump -i -h localhost -U postgres -F c -b -v -f pub.backup temp1 Now I want to restore the dump in a different …

Read More