problem with pg_restore

From: "lists" <lists(at)insyde(dot)com(dot)br>
To: <pgsql-general(at)postgresql(dot)org>
Subject: problem with pg_restore
Date: 2003-04-01 14:22:20
Message-ID: 013201c2f85a$1bc16740$84faabc8@insyde
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

Browse pgsql-general by date

  From Date Subject
Next Message Peter Choe 2003-04-01 14:36:28 stored procedure
Previous Message Nigel J. Andrews 2003-04-01 13:53:46 dropping a table with dependencies