Postgres Pro
Downloads
Home   >   mailing lists

Re: Best way to upgrade Postgresql 7.4.x to 8.1.x? - Mailing list pgsql-admin

From Joshua D. Drake
Subject Re: Best way to upgrade Postgresql 7.4.x to 8.1.x?
Date
Msg-id 445B81DD.8070609@commandprompt.com
Whole thread Raw
In response to Best way to upgrade Postgresql 7.4.x to 8.1.x?  (Arnau <arnaulist@andromeiberica.com>)
List pgsql-admin
Tree view 
Arnau wrote:
> 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


I think Slony is going to be the best bet for minimal downtime.


--

            === The PostgreSQL Company: Command Prompt, Inc. ===
      Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
      Providing the most comprehensive  PostgreSQL solutions since 1997
                     http://www.commandprompt.com/

pgsql-admin by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: Where to get column length
Next
From: MIlos Prudek
Date:
Subject: Re: missing chunk number 0 for toast value ...