PostgreSQL – PG_RESTORE: [Archiver] Input file is too short in Postgres

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 get an error:

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

What am I doing wrong?

I encountered the same error. In my case, I just ignored the Specify the backup file.

I tried 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 get an error:

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

What am I doing wrong?

I encountered the same error. In my case, I just ignored specifying the backup file at the end of the command.

< /p>

WordPress database error: [Table 'yf99682.wp_s6mz6tyggq_comments' doesn't exist]
SELECT SQL_CALC_FOUND_ROWS wp_s6mz6tyggq_comments.comment_ID FROM wp_s6mz6tyggq_comments WHERE ( comment_approved = '1' ) AND comment_post_ID = 694 ORDER BY wp_s6mz6tyggq_comments.comment_date_gmt ASC, wp_s6mz6tyggq_comments.comment_ID ASC

Leave a Comment

Your email address will not be published.