Skip site navigation (1) Skip section navigation (2)

pg migrator

From: "Denis Lussier" <denisl(at)enterprisedb(dot)org>
To: pgsql-general(at)postgresql(dot)org, "Korry Douglas" <korry(dot)douglas(at)enterprisedb(dot)com>, "Heikki Linnakangas" <heikki(at)enterprisedb(dot)com>
Cc: "Bruno Wolff III" <bruno(at)wolff(dot)to>, "Rich Shepard" <rshepard(at)appl-ecosys(dot)com>
Subject: pg migrator
Date: 2007-01-30 04:23:51
Message-ID: (view raw, whole thread or download thread mbox)
Lists: 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.


On 1/29/07, Bruno Wolff III <bruno(at)wolff(dot)to> wrote:
> On Mon, Jan 29, 2007 at 15:51:54 -0800,
>   Rich Shepard <rshepard(at)appl-ecosys(dot)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

Next:From: Sim ZacksDate: 2007-01-30 05:56:32
Subject: Re: PG Email Client
Previous:From: Bruno Wolff IIIDate: 2007-01-30 04:09:23
Subject: Re: PostgreSQL 9.0

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group