pg migrator - Mailing list pgsql-general

From Denis Lussier
Subject pg migrator
Date
Msg-id 64db53a00701292023i146a187dpb25e1a6e5adae9f0@mail.gmail.com
Whole thread Raw
Responses Re: pg migrator
List pgsql-general
Korry Douglas has an EDB sponsored project called pg_migrator on
pgfoundry.   I believe it works for upgrading from 8.1 to 8.2 except
for tables that use the ip address datatype.  It works by just
replacing the 8.1 system catalogs with the 8.2 system catalogs.  I
believe the on-disk images for 8.1 and 8.2 are the same except for the
ip address field.

--Luss
  http://www.enterpisedb.com

On 1/29/07, Bruno Wolff III <bruno@wolff.to> wrote:
> On Mon, Jan 29, 2007 at 15:51:54 -0800,
>   Rich Shepard <rshepard@appl-ecosys.com> wrote:
> > On Tue, 30 Jan 2007, Michael Glaesemann wrote:
> >
> > >It was *discussed*. 8.1 to 8.2 (as does any move from M.x to M.y where x ­
> > >y) requires a dump and reload.
> >
> > Michael,
> >
> >   That's what I thought. However, it never hurts to ask. :-)
>
> I figured that mentionioning you need a tool that doesn't exist would make
> it clear that this was proposed for the future and not current reality.
>
> ---------------------------(end of broadcast)---------------------------
> TIP 9: In versions below 8.0, the planner will ignore your desire to
>        choose an index scan if your joining column's datatypes do not
>        match
>

pgsql-general by date:

Previous
From: Bruno Wolff III
Date:
Subject: Re: PostgreSQL 9.0
Next
From: Sim Zacks
Date:
Subject: Re: PG Email Client