Обсуждение: Database restoration performance issue on PostgreSQL 7.4.7

Hi all,

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

Is the problem related to my backup and restore command, or it's the
problem of my system, or PostgreSQL installation?


Best regards,
Leon

__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around
http://mail.yahoo.com

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