Re: Best way to upgrade Postgresql 7.4.x to 8.1.x?

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/