On 04/17/2015 03:09 PM, rob stone wrote:
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.
Guessing /home/postgres/data*/userqueries/ is the location of your tablespace, not the cluster directory.
The -d and -D need to point at the cluster directory, which will be something like :
/var/lib/postgresql/9.3/main
Do I just create a dummy directory named "base"?
No, you need to point to the correct directory. See here for more information: http://www.postgresql.org/docs/9.4/interactive/pgupgrade.html Or use pg_upgradecluster: http://manpages.ubuntu.com/manpages/trusty/man8/pg_upgradecluster.8.html
If there is supposed to be a directory or file named "base" why wasn't it created by initdb?
Regards, Robert
-- Adrian Klaver adrian.klaver@xxxxxxxxxxx -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
