If you are getting above error while restoring backup of database in postgresql. This error means you have taken backup in plain text format.
Advertisement
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.
3 Comments
Why do you assume it is in Linux? What if this problem is coming on Windows? “cat” is not a Windows command.
if you are developer most of us are working on linux so its majority fix
Nice retarded logic
and ofc nice bait titled blog posting