On Thu, Jan 15, 2009 at 11:02 AM, Jeremy Kister <pgsql-general-01@xxxxxxxxxxxxxxxx> wrote: > I've got two 300GB databases that I'm going to be upgrading from 8.2.4 (32 > bit) to 8.3.5 (64 bit). > > The systems are running on Solaris 10u5 64bit with lots of disks in a zfs > raid10 and have 32GB ram. > > I've read lots of docs and Google, and found a special flavor of > postgresql.conf that helps the import speed along, but the dump + import > process still takes about 15 hours. If you're looking to minimize downtime, and switch over quickly, look at slony, assuming you have the disk space / I/O bandwidth to do it that way, the actual downtime can be measured in minutes and seconds. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
