Restore of pg_dump taking a long time...

From: "Ruairi" <rcarroll(at)bluemetrix(dot)com>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: Restore of pg_dump taking a long time...
Date: 2006-05-24 11:38:33
Message-ID: 008c01c67f26$9848caf0$2815a8c0@D5T7W62J
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi,
I'm currently restoring a fairly large DB from a pg_dump and it's taking
about 12 hours to finish. The main part of this time is spent creating
indexes. Is there anyway I can speed up the restore process, or do i just
have to wait? I'm using postgres 8.1.3 on freebsd and the pg_dump is gzip'd.
I'm restoring with the following command : "zcat <gzip'd db> | psql -U
postgres <destination db>"

Regards,
Ruairi Carroll

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Alessandro Oggioni 2006-05-24 12:11:25 Postgresql install problem in windows system
Previous Message sibel karaasma 2006-05-24 08:39:13 compiling source code!!!!!!!!!!!!!!!!!!!!!!!!!!!!!