Database restoration performance issue on PostgreSQL 7.4.7

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message deepak pal 2006-04-04 04:37:58 what datatype is for autonumbering.in postgress
Previous Message Patrick TJ McPhee 2006-04-04 04:15:06 Re: PSQL Data Type: text vs. varchar(n)