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.klaver@xxxxxxxxxxx
