Re: upgrading postgres version

From: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
To: Anj Adu <fotographs(at)gmail(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: upgrading postgres version
Date: 2009-10-23 22:05:26
Message-ID: dcc563d10910231505q5222f3e8lf92d86416bd52a68@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Fri, Oct 23, 2009 at 4:00 PM, Anj Adu <fotographs(at)gmail(dot)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.

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Scott Marlowe 2009-10-23 22:06:18 Re: upgrading postgres version
Previous Message Anj Adu 2009-10-23 22:00:15 upgrading postgres version