Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 30A969FB6C7 for ; Wed, 28 Mar 2007 10:23:18 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 38071-01 for ; Wed, 28 Mar 2007 10:23:00 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from starvinmarvin.rokcorp.com (host26.rokcorp.com [194.119.140.91]) by postgresql.org (Postfix) with ESMTP id 64C309FB8BA for ; Wed, 28 Mar 2007 10:23:05 -0300 (ADT) Received: from [10.0.11.144] (unknown [213.120.252.2]) by starvinmarvin.rokcorp.com (Postfix) with ESMTP id AE6D9D4147 for ; Wed, 28 Mar 2007 14:23:03 +0100 (BST) Message-ID: <460A6C3B.1030302@rokcorp.com> Date: Wed, 28 Mar 2007 14:23:07 +0100 From: Chuck Amadi Reply-To: chuck.amadi@rokcorp.com Organization: Rok Corporation Ltd User-Agent: Thunderbird 1.5.0.10 (X11/20070221) MIME-Version: 1.0 To: postgresql Subject: Investigating upgrading from version 8.0.1 to 8.2.3 to allow for easy replication and upgrades. Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200703/221 X-Sequence-Number: 25045 Hi List My Organisation are currently investigating upgrading from version 8.0.1 to 8.2.3 to allow for easy replication and upgrades. The Primary database server **houses both the TEST and LIVE Postgresql databases and are synchronised to a Secondary database server. Thus I am looking at RSERV (Master/Slave concept) and pg_dumpall. PS I also like to know about the RESRV failover concept. Please is there any good links or gotcha's. Cheers Chuck -- Chuck Amadi ROK Corporation Limited Ty ROK, Dyffryn Business Park, Llantwit Major Road, Llandow, Vale Of Glamorgan. CF71 7PY Tel: 01446 795 839 Fax: 01446 794 994 International Tel: +44 1446 795 839 email: chuck.amadi@rokcorp.com This email is confidential to the addressee only. If you do not believe that you are the intended recipient, do not pass it on or copy it in any way. Please delete it immediately.