The tag has no wiki summary.

learn more… | top users | synonyms

16
votes
7answers
21k views

pg_dump and pg_restore: input file does not appear to be a valid archive

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 ...
5
votes
4answers
6k views

How to restore PostgreSQL database from .tar file?

I have all PostgreSQL databases backed up during incremental backups using WHM, which creates a $dbName.tar file. Data is stored in these .tar files, but I do not know how to restore it back into the ...
0
votes
1answer
849 views

pg_restore is taking too long to finish. What could be the problem?

pg_restore is taking too long to finish. I already performed the following service postgresql initdb /etc/init.d/postgresql start Modified /var/lib/pgsql/data/pg_hba.conf to use local all ...