Re: Database restoration performance issue on PostgreSQL 7.4.7 - Mailing list pgsql-general

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