problem with pg_restore

Started by listsabout 23 years ago1 messagesgeneral
Jump to latest
#1lists
lists@insyde.com.br

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.