Skip to content

pg_restore: [archiver] input file does not appear to be a valid archive

Advertisement

If you are getting above error while restoring backup of database in postgresql. This error means you have taken backup in plain text format.

Error:

pg_restore: [archiver] input file does not appear to be a valid archive

Solution:

To restore plain text backup using below command.

Backup filename: backup-db.txt
Database name: mydb

# cat backup-db.txt | psql mydb

I hope it will help you.

Rahul

I, Rahul Kumar am the founder and chief editor of TecAdmin.net. I am a Red Hat Certified Engineer (RHCE) and working as an IT professional since 2009..

3 Comments

  1. Why do you assume it is in Linux? What if this problem is coming on Windows? “cat” is not a Windows command.

Leave a Reply

Your email address will not be published. Required fields are marked *


Back to top