> Are you sure your restoring to an empty database? If you try to restore > your dump into the database you dumped it from (without first > drop/create) it will take forever as you'll have all kinds of data > collisions (imagine every insert into a table erroring out due to > duplicate primary key).
Yes, I'm sure it is an empty database. I didn't mention in the e-mail, but the complete script I did is: $pg_dump -s DB1 > DB1.sql $pg_dump -a -b -Fc -f DB1.dump -o -v DB1 $dropdb DB2 $createdb DB2 $psql DB2 <DB1.sql $pg_restore -a -d DB2 -Fc -o -v DB1.dump So it's a brand new DB I'm restoring to. > As for the -Ft vs. -Fc size question, the tar format is not a compressed > format, while the "c"ustom format is. Thanks. Ricardo. ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html