Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 85DF69FA43C for ; Fri, 29 Dec 2006 08:07:10 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-new, port 10024) with ESMTP id 47456-02 for ; Fri, 29 Dec 2006 08:07:01 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from fafnir.androme.com (fafnir.androme.com [62.58.96.158]) by postgresql.org (Postfix) with ESMTP id BDE279FA182 for ; Fri, 29 Dec 2006 08:07:02 -0400 (AST) Received: by fafnir.androme.com (Postfix, from userid 1003) id CEA71BA2A4E; Fri, 29 Dec 2006 13:07:00 +0100 (CET) Message-ID: <459504E3.4050804@andromeiberica.com> Date: Fri, 29 Dec 2006 13:06:59 +0100 From: Arnau Reply-To: arnaulist@andromeiberica.com User-Agent: Thunderbird 1.5.0.9 (Windows/20061207) MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: How do you upgrade for production servers? 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: 200612/350 X-Sequence-Number: 24142 Hi all, This is a general question about which procedure you follow when you upgrade your productions servers. Let's say we have a server running and older version and I want to install the latest version on the same server. Do you install slony? do you dump all the databases, install the latest version and after you restore? any other procedure? I'd like to have my production server down as less time as possible. Thank you very much and have a great new year :D -- Arnau