Postgres Pro
Downloads
Home   >   mailing lists

why restoring a dump file is sooo slow - Mailing list pgsql-general

From Reynard Hilman
Subject why restoring a dump file is sooo slow
Date
Msg-id 32945.4.34.129.12.1051348841.squirrel@lightsky.com
Whole thread Raw
Responses Re: why restoring a dump file is sooo slow  (Mike Mascari <mascarm@mascari.com>)
Re: why restoring a dump file is sooo slow  ("scott.marlowe" <scott.marlowe@ihs.com>)
List pgsql-general
Tree view 
Hi,

I'm trying to restore a dump file that I created using:
pg_dump -CD dbname > dump.sql

the dump file size is about 87 Mb.

so I did this to restore:
psql -f dump.sql -U user template1

It takes almost an hour and a half to restore the database.

I'm just wondering if that is normal for such a small database (87Mb), or
is something wrong with how I did the restore or with my db configuration?
btw, it's on dual pIII server running redhat 7.3. with about 2G of memory.

thanks,
reynard

pgsql-general by date:

Previous
From: Jerome Alet
Date:
Subject: SQL schema to LDAP schema ?
Next
From: Mike Mascari
Date:
Subject: Re: why restoring a dump file is sooo slow