Re: Database restoration performance issue on PostgreSQL 7.4.7

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Chris 2006-04-04 04:54:10 Re: what datatype is for autonumbering.in postgress
Previous Message deepak pal 2006-04-04 04:37:58 what datatype is for autonumbering.in postgress