Re: Database restoration performance issue on PostgreSQL 7.4.7

Leon Pu <leon_xf_pu@yahoo.com.cn> 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