--- Tom Lane <tgl@xxxxxxxxxxxxx> wrote: > Leon Pu <leon_xf_pu@xxxxxxxxxxxx> 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
