Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id AA6B69FA0B7 for ; Fri, 29 Dec 2006 12:10:38 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-new, port 10024) with ESMTP id 98014-01 for ; Fri, 29 Dec 2006 12:10:13 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from mama.jerrysievers.com (adsl-64-118-249-70.netrox.net [64.118.249.70]) by postgresql.org (Postfix) with ESMTP id 45AD69F9F47 for ; Fri, 29 Dec 2006 12:10:31 -0400 (AST) Received: from mama.jerrysievers.com (localhost.localdomain [127.0.0.1]) by mama.jerrysievers.com (8.13.8/8.13.8) with ESMTP id kBTGAQpw024413; Fri, 29 Dec 2006 11:10:26 -0500 Received: (from jerry@localhost) by mama.jerrysievers.com (8.13.8/8.13.8/Submit) id kBTGAP8T024410; Fri, 29 Dec 2006 11:10:25 -0500 X-Authentication-Warning: mama.jerrysievers.com: jerry set sender to jerry@jerrysievers.com using -f To: arnaulist@andromeiberica.com Cc: pgsql-admin@postgresql.org Subject: Re: How do you upgrade for production servers? References: <459504E3.4050804@andromeiberica.com> From: Jerry Sievers Date: 29 Dec 2006 11:10:25 -0500 In-Reply-To: <459504E3.4050804@andromeiberica.com> Message-ID: Lines: 45 User-Agent: Gnus/5.09 (Gnus v5.9.0) Emacs/21.4 MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200612/353 X-Sequence-Number: 24145 Arnau writes: > 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.