From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
---|---|
To: | rob stone <floriparob(at)gmail(dot)com>, pgsql-general(at)lists(dot)postgresql(dot)org |
Subject: | Re: Running pg_upgrade Version 11 |
Date: | 2018-11-06 14:10:23 |
Message-ID: | ba697306-7170-2374-c6e6-e8e41f0f407c@aklaver.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(dot)klaver(at)aklaver(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | Charles Martin | 2018-11-06 14:29:55 | Re: Trouble Upgrading Postgres |
Previous Message | Ron | 2018-11-06 13:54:23 | Re: PgAgent on Windows |