Hello,
I'm having issues restoring a dumped database with the following commands:
Dumping:
pg_dump -p -U'postgres' -C -f ./dumpbkp mydatabase
tar -cvzf dumpbkp.tar.gz dumpbkp
Restoring:
cat dumpbkp.tar.gz | gunzip | psql -U'postgres'
The database is quite big, so it takes a lot of time to restore. The process outputs some normal messages and, in the end, after a lot of time, it prints out some strangers errors like "duplicate key", "constraint already exists", and other similar...
at the end, I've got a database 10 GB smaller than the original, which clearly indicates that some data was lost.
The versions are 8.4.5 (original) and 8.4.7 (restored).
What should I do? Am I doing something wrong?
Thanks in advance.
Henrique Teófilo
