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

From: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
To: arnaulist(at)andromeiberica(dot)com
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Best way to upgrade Postgresql 7.4.x to 8.1.x?
Date: 2006-05-05 16:48:29
Message-ID: 445B81DD.8070609@commandprompt.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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/

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message MIlos Prudek 2006-05-05 17:49:33 Re: missing chunk number 0 for toast value ...
Previous Message Alvaro Herrera 2006-05-05 15:04:38 Re: Where to get column length