Re: Running pg_upgrade under Debian

On Sat, 2015-04-18 at 00:25 +0200, Karsten Hilbert wrote:
> On Sat, Apr 18, 2015 at 08:09:43AM +1000, rob stone wrote:
>
> > I'm trying to upgrade from 9.3 to 9.4 on my laptop and encountering this
> > error:-
> >
> >
> > postgres(at)roblaptop:/usr/lib/postgresql/9.4/bin$ ./pg_upgrade
> > -b /usr/lib/postgresql/9.3/bin -B /usr/lib/postgresql/9.4/bin
> > -d /home/postgres/data93/userqueries
> > -D /home/postgres/data94/userqueries -U pguserqueries
>
> For what it's worth: Debian provides a
>
> pg_upgradecluster
>
> tailored to its specific setup of PostgreSQL clusters. That
> has worked well for me across several major version bumps.
>
> Karsten
>

Indeed I have that program installed in /usr/lib but the man pages state
that it cannot handle tablespaces.

So, I guess I have to move to Plan B, use pg_dump from the old version
and then import into 9.4.1.

Thanks for your help.

Robert

> > check for "/home/postgres/data93/userqueries/base" failed: No such file
> > or directory
> >
> > Failure, exiting
> > postgres(at)roblaptop:/usr/lib/postgresql/9.4/bin$
> >
> > postgres(at)roblaptop:/usr/lib/postgresql/9.4/bin$ ./pg_upgrade --version
> > pg_upgrade (PostgreSQL) 9.4.1
> >
> >
> > I have two tablespaces defined for this data -- one to hold the tables
> > and another for the indices.
> >
> > There is no "base" file or directory.
> >
> > Do I just create a dummy directory named "base"?
> >
> > If there is supposed to be a directory or file named "base" why wasn't
> > it created by initdb?
> >
> >
> > Regards,
> > Robert
> >
> >
> >
> > --
> > Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> > To make changes to your subscription:
> > http://www.postgresql.org/mailpref/pgsql-general
>
> --
> GPG key ID E4071346 @ eu.pool.sks-keyservers.net
> E167 67FD A291 2BEA 73BD 4537 78B9 A9F9 E407 1346
>
>