X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 0F8829FB1B7 for ; Fri, 5 May 2006 07:05:22 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 04282-02 for ; Fri, 5 May 2006 07:05:16 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from fafnir.androme.com (fafnir.androme.com [62.58.96.158]) by postgresql.org (Postfix) with ESMTP id 000219FB0D1 for ; Fri, 5 May 2006 07:05:15 -0300 (ADT) Received: by fafnir.androme.com (Postfix, from userid 1003) id BD21FB929DF; Fri, 5 May 2006 12:05:13 +0200 (CEST) Message-ID: <445B2359.2070004@andromeiberica.com> Date: Fri, 05 May 2006 12:05:13 +0200 From: Arnau Reply-To: arnaulist@andromeiberica.com User-Agent: Mozilla Thunderbird 1.0.6 (Windows/20050716) X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: Best way to upgrade Postgresql 7.4.x to 8.1.x? 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: 200605/54 X-Sequence-Number: 21586 Hi all, I have several servers running with Postgresql 7.4.x on Debian, everybody says that those servers should be migrated to version 8.0 or 8.1. Finally I'm decided to migrate those servers but I'm worried about how to do that. Those servers are in production and the downtime should be the minimum. Any advise about what's the way or the best way to do it? Thank you very much -- Arnau