Restore of pg_dump taking a long time...
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
- Subject: Restore of pg_dump taking a long time...
- From: "Ruairi" <rcarroll@xxxxxxxxxxxxxx>
- Date: Wed, 24 May 2006 12:38:33 +0100
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
[Index of Archives]
[KVM ARM]
[KVM ia64]
[KVM ppc]
[Virtualization Tools]
[Spice Development]
[Libvirt]
[Libvirt Users]
[Linux USB Devel]
[Linux Audio Users]
[Yosemite Questions]
[Linux Kernel]
[Linux SCSI]
[XFree86]