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

--- Tom Lane <tgl@sss.pgh.pa.us> wrote:

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.

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