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