Postgres Pro
Downloads
Home   >   mailing lists

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

From Leon Pu
Subject Database restoration performance issue on PostgreSQL 7.4.7
Date
Msg-id 20060404043039.41125.qmail@web15706.mail.cnb.yahoo.com
Whole thread Raw
Responses Re: Database restoration performance issue on PostgreSQL 7.4.7  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Chris
Date:
Subject: Re: Log Slow Queries
Next
From: "deepak pal"
Date:
Subject: what datatype is for autonumbering.in postgress