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@postgresql.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