Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-admin by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group