Postgres Pro
Downloads
Home   >   mailing lists

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

From Tom Lane
Subject Re: Database restoration performance issue on PostgreSQL 7.4.7
Date
Msg-id 12820.1144126203@sss.pgh.pa.us
Whole thread Raw
In response to Database restoration performance issue on PostgreSQL 7.4.7  (Leon Pu <leon_xf_pu@yahoo.com.cn>)
Responses Re: Database restoration performance issue on PostgreSQL 7.4.7  (Leon Pu <leon_xf_pu@yahoo.com.cn>)
List pgsql-general
Tree view 
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

pgsql-general by date:

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