I have used pg_dump on one machine and copied result file to another, where I tried to restore it. I believe schema is the same. However, I get:
pg_restore: [archiver] input file does not appear to be a valid archive
I have done following operations:
pg_dump -a -f db.txt dbname
And:
pg_restore -a -d dbname db.txt
What might be wrong?