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