Received: from maia.hub.org (unknown [200.46.208.211]) by mail.postgresql.org (Postfix) with ESMTP id 037A4632C47 for ; Wed, 14 Apr 2010 18:11:35 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.208.211]) (amavisd-maia, port 10024) with ESMTP id 69661-07 for ; Wed, 14 Apr 2010 21:11:19 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from zql.com (3a.1f.de.static.xlhost.com [206.222.31.58]) by mail.postgresql.org (Postfix) with ESMTP id 5AFE8633920 for ; Wed, 14 Apr 2010 18:11:24 -0300 (ADT) Received: from localhost ([127.0.0.1]) by zql.com with smtp (Exim 4.68) (envelope-from ) id 1O29rm-0006tc-Tg; Wed, 14 Apr 2010 17:11:22 -0400 From: "Greg Sabino Mullane" To: pgsql-admin@postgresql.org Subject: Re: Migrating from 8.3 to 8.4 on the same server X-PGP-Key: 2529 DF6A B8F7 9407 E944 45B4 BC9B 9067 1496 4AC8 X-Request-PGP: http://www.biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8 In-Reply-To: <4BC6273B.3000803@setonhome.org> Date: Wed, 14 Apr 2010 21:11:22 -0000 X-Mailer: JoyMail 2.4.0 Message-ID: <4e01e0bb79419eabaee763bd13ed1590@biglumber.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-2.099 tagged_above=-10 required=5 tests=AWL=-0.199, BAYES_00=-1.9 X-Spam-Level: X-Archive-Number: 201004/181 X-Sequence-Number: 34275 -----BEGIN PGP SIGNED MESSAGE----- Hash: RIPEMD160 > It wouldn't kill us to have two or three hours of down time, > but I would like to avoid it. If it wouldn't kill you, I'd suck up the time. All other solutions are going to take additional expertise, prep, and testing. Keep in mind that if you have tables and/or databases that don't change frequently, you can dump those beforehand to minimize the final downtime. You can also put your db in readonly mode to keep it available while the export is going on. Depending on your server layout, (e.g. available partitions) this may or may not be worth it. - -- Greg Sabino Mullane greg@turnstep.com End Point Corporation http://www.endpoint.com/ PGP Key: 0x14964AC8 201004141705 http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8 -----BEGIN PGP SIGNATURE----- iEYEAREDAAYFAkvGL0UACgkQvJuQZxSWSshrFgCgxQJGmwW/GEHDysaYqBzWD2PM KiUAoMaq/nMeQWV3hbE8uoQzoF/FZVlx =3b+F -----END PGP SIGNATURE-----