--- 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