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@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@roblaptop:/usr/lib/postgresql/9.4/bin$ > > > > postgres@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@xxxxxxxxxxxxxx) > > 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 > > -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
