Re: upgrading postgres version - Mailing list pgsql-admin

From Scott Marlowe
Subject Re: upgrading postgres version
Date
Msg-id dcc563d10910231505q5222f3e8lf92d86416bd52a68@mail.gmail.com
Whole thread Raw
In response to upgrading postgres version  (Anj Adu <fotographs@gmail.com>)
List pgsql-admin
On Fri, Oct 23, 2009 at 4:00 PM, Anj Adu <fotographs@gmail.com> wrote:
> We have several databases over 700Gb. A full dump can take  a very long time.
>
> is there any plan in the future to address migration of databases from
> a 8.x.y release to a 8.y.x release..
>
> Due to the current nature of migration(  full dump and restore)...we
> simply cannot migrate without a lot of down time.

We migrate with Slony.  Works like a charm and our downtime is usually
only a minute or two.

pgsql-admin by date:

Previous
From: Anj Adu
Date:
Subject: upgrading postgres version
Next
From: Scott Marlowe
Date:
Subject: Re: upgrading postgres version