Re: is possible to upgrade from 9.2 to 9.4 with pg_upgrade

2015-05-06 15:15 GMT+02:00 Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>:

> Pavel Stehule wrote:
> > Hi
> >
> > I am working on preparation the migration from 9.2 to 9.4
> >
> > pg_upgrade fails
> >
> > pg_upgrade -b /usr/lib64/pgsql/postgresql-9.2/bin -B /usr/bin/ -d
> > /mnt/ebs/pgsql/data -D /mnt/ebs/pgsql/data94 -k'
> > Performing Consistency Checks
> > -----------------------------
> > Checking cluster versions ok
> > The old cluster lacks some required control information:
> > latest checkpoint oldest MultiXactId
> >
> > ?
>
> Uh, this is certainly supposed to work. Maybe pg_controldata or
> pg_resetxlog changed output format and pg_upgrade doesn't know how to
> read it.
>

It is tested on fresh 9.2.10 to 9.4.1

Regards

Pavel

>
> --
> Álvaro Herrera http://www.2ndQuadrant.com/
> PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
>