I'm running this script to make back-ups and restore them:
$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
but the pg_restore is taking more than 14 hours to
be done. Am I doing something wrong here?
Is there any faster way to restore OIDs/lo objects?
TIA,
Ricardo.