On 11/5/18 9:27 PM, rob stone wrote:
Hello,
Trying to run pg_upgrade from version 10 to version 11 on the test
server and pulling the following error:-
could not open version file: /home/postgres/testing/data_v10/PG_VERSION
Failure, exiting
O/S is:- Debian 4.18.10-2 (2018-11-02) x86_64 GNU/Linux
Running pg_upgrade as user postgres.
These are the permissions on the version 10 file:-
-rw------- 1 postgres postgres 3 Mar 23 2018 PG_VERSION
These are the permissions on the version 11 file:-
-rw------- 1 postgres postgres 3 Nov 6 14:50 PG_VERSION
This is the command being run:-
/usr/lib/postgresql/11/bin/pg_upgrade -b /usr/lib/postgresql/10/bin -B
/usr/lib/postgresql/11/bin -d /home/postgres/testing/data_v10 -D
/home/postgres/testing/data_v11
Logged in as user postgres and postgres owns the files created by
initdb, so is this a permissions problem or am I having a brain fade?
Is:
/home/postgres/testing/data_v10/
the correct path to the data directory?
What happens if you add?:
-U postgres
Maybe there is a PGUSER env variable set that is not postgres.
TIA,
Rob
--
Adrian Klaver
adrian.kla...@aklaver.com
