| Lists: | pgsql-general |
|---|
| From: | Leon Pu <leon_xf_pu(at)yahoo(dot)com(dot)cn> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Database restoration performance issue on PostgreSQL 7.4.7 |
| Date: | 2006-04-04 04:30:39 |
| Message-ID: | 20060404043039.41125.qmail@web15706.mail.cnb.yahoo.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-general |
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
| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Leon Pu <leon_xf_pu(at)yahoo(dot)com(dot)cn> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Database restoration performance issue on PostgreSQL 7.4.7 |
| Date: | 2006-04-04 04:50:03 |
| Message-ID: | 12820.1144126203@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-general |
Leon Pu <leon_xf_pu(at)yahoo(dot)com(dot)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
| From: | Leon Pu <leon_xf_pu(at)yahoo(dot)com(dot)cn> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Database restoration performance issue on PostgreSQL 7.4.7 |
| Date: | 2006-04-04 05:59:47 |
| Message-ID: | 20060404055947.19201.qmail@web15709.mail.cnb.yahoo.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-general |
--- Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> Leon Pu <leon_xf_pu(at)yahoo(dot)com(dot)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