Received: from localhost (unknown [200.46.204.183])
	by mail.postgresql.org (Postfix) with ESMTP id 063E56501FF
	for <pgsql-admin-postgresql.org@mail.postgresql.org>;
	Fri,  7 Nov 2008 04:22:11 -0400 (AST)
Received: from mail.postgresql.org ([200.46.204.86])
	by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024)
	with ESMTP id 49051-01-3
	for <pgsql-admin-postgresql.org@mail.postgresql.org>;
	Fri,  7 Nov 2008 04:22:10 -0400 (AST)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6
Received: from mail-gx0-f13.google.com (mail-gx0-f13.google.com
	[209.85.217.13])
	by mail.postgresql.org (Postfix) with ESMTP id 50D1D6506B4
	for <pgsql-admin@postgresql.org>; Fri,  7 Nov 2008 02:04:07 -0400 (AST)
Received: by gxk6 with SMTP id 6so805750gxk.19
	for <pgsql-admin@postgresql.org>; Thu, 06 Nov 2008 22:04:06 -0800 (PST)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma;
	h=domainkey-signature:received:received:message-id:date:from:to
	:subject:mime-version:content-type;
	bh=mnzS7F5mRbHNWi0UC7Db0m4/D2UJLJGwfc4fAng/wDo=;
	b=Sp8rqwCRiWdyI0csw7XPHUByafMGN1lGNk3CqEg3uoeRDeI6R0AJuBMRCcQR7OAcvf
	Vz1Jh8dS13NqwogMjCSlha4mAZRb603u+wc4ETNoeQ/qtdsz7320UkA7NIIohbYePl6/
	ezmbmT28CfOyFtqrW6uMFyA/NJFG4wrbTxjQ0=
DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=message-id:date:from:to:subject:mime-version:content-type;
	b=hU6LChkASaJsb8dMXVTFSiv0f0mfGzhSO/3GnVnu26d0oMKDZeQT1hAcFDkloJpm2I
	YhB0fIJq5pNMJ+dDZkAFWPqdFAtqAXt0CMD7Xazlek1XM2c/EXpDdTe7hke6VPjWLZ+3
	J1CHas4UYsPPvJtCVIJ/zqsXL94QjTtYhalBM=
Received: by 10.231.15.130 with SMTP id k2mr1164924iba.31.1226037846013;
	Thu, 06 Nov 2008 22:04:06 -0800 (PST)
Received: by 10.140.172.6 with HTTP; Thu, 6 Nov 2008 22:04:05 -0800 (PST)
Message-ID: <6c1264780811062204t260f7c4eo20675bc8d2b0bb6b@mail.gmail.com>
Date: Fri, 7 Nov 2008 16:34:05 +1030
From: "Swathi S" <ss.postgres@gmail.com>
To: pgsql-admin@postgresql.org
Subject: Ideal way to upgrade to postgres 8.3 with less downtime
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_Part_26702_10724359.1226037845987"
X-Archive-Number: 200811/41
X-Sequence-Number: 30695

------=_Part_26702_10724359.1226037845987
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

Hi,

I have a database of size approx 400G. It's a 24/7 database. Only few tables
have regular reads and writes. The other tables just store information.

I would like to upgrade to 8.3 and would like to know the best way to
upgrade with less downtime.

Thanks
Swathi

------=_Part_26702_10724359.1226037845987
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

<div>Hi,<br><br>I have a database of size approx 400G. It&#39;s a 24/7 database. Only few tables have regular reads and writes. The other tables just store information. <br><br>I would like to upgrade to 8.3 and would like to know the best way to upgrade with less downtime. <br>
<br>Thanks</div>
<div>Swathi</div>

------=_Part_26702_10724359.1226037845987--