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. regards, tom lane
