pg migrator

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(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
>