--- Tom Lane <[EMAIL PROTECTED]> wrote: > Leon Pu <[EMAIL PROTECTED]> writes: > > the database restoration on my PosgreSQL 7.4.7 Linux installation > is > > terribly poor. It takes more than one and half hour to restore a > 61M > > restored database. > > > Here are my commands to backup and restore. > > > - backup: pg_dump -d $DB_NAME > db.bak > > - restore: psql -d $DB_NAME < db.bak > > Try dropping the -d switch to pg_dump.
It works. Thanks a lot. Best regards, Leon __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
