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

Question

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?

My initial guess would be that the problem was with the pg_dump rather than the pg_restore. How big is the db_dump_new.backup file? — Gary - Stand with Ukraine, Apr 07 '16 at 07:46

score 15 · Answer 1 · answered Jan 08 '20 at 19:26

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;

score 4 · Answer 2 · answered Jun 22 '16 at 08:06

4

I encountered the same error. In my case I had simply neglected to specify the backup file at the end of the command.

answered Jun 22 '16 at 08:06

nano

434
4
4

ended up with very same error because lost `\` of multiline bash script.... – andilabs Oct 05 '17 at 12:57

Andrei.Danciuc · Answer 3 · 2019-07-31T08:41:11.823

In my case I used docker

$ docker exec a5f7b094c523 pg_restore -d my_new_db < "./2256.dump"
pg_restore: [archiver] input file is too short (read 0, expected 5)

And the issue was that "./2256.dump" is not a binary file but a plain sql text dump.

To check that just do

$ head ~/2256.dump                                                                                                    
--
-- PostgreSQL database dump
--

-- Dumped from database version 10.8 (Ubuntu 10.8-0ubuntu0.18.04.1)
-- Dumped by pg_dump version 10.8 (Ubuntu 10.8-0ubuntu0.18.04.1)

SET statement_timeout = 0;
SET lock_timeout = 0;
SET idle_in_transaction_session_timeout = 0;

And to import sql dump fo

$ pv ~/2256.dump |docker-compose -f docker-compose.dev.yml -f docker-compose.override.yml -T db psql "fight-round3"

I'm getting the same error, but my dump file *is* binary. Any clues there? — lmat - Reinstate Monica, Dec 05 '19 at 14:27

score 0 · Answer 4 · edited Oct 06 '21 at 13:41

0

Use this command, it will work perfectly to restore the db file using sql file in Postgres 13 in pgadmin 4

C:\Program Files\PostgreSQL\13\bin>psql -U user_name db_name< D:\dbfile\sql_file.sql

edited Oct 06 '21 at 13:41

Suraj Rao

29,388
11
94
103

answered Oct 06 '21 at 13:34

White Wolf

1

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

4 Answers4