PostgreSQL Discussion - Database restoration performance issue on PostgreSQL 7.4.7

Author

Database restoration performance issue on PostgreSQL 7.4.7

Leon Pu

2006-04-04, 3:27 am

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

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

Tom Lane

2006-04-04, 3:27 am

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

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match

Leon Pu

2006-04-04, 3:27 am

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

> Leon Pu <leon_xf_pu@yahoo.com.cn> writes:
> is
> 61M
>
>
>
> 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

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

Sponsored Links