Re: Running pg_upgrade Version 11
On Wed, Nov 7, 2018 at 11:30:18AM +1100, rob stone wrote: > > > On Tue, 2018-11-06 at 15:17 +0900, Michael Paquier wrote: > > On Tue, Nov 06, 2018 at 04:27:35PM +1100, rob stone wrote: > > > 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? > > > > Having 0600 as umask for those files is normal. Don't you have more > > logs about the error? You should not see this error, except if > > data_v10 > > is not a data folder initialized correctly, so perhaps you messed up > > something in your environment? > > -- > > Michael > > > > Problem caused by my eyesight. > A colleague pointed out the typo in the argument to the -d parameter. > Working as intended. Should the error message be improved? -- Bruce Momjian http://momjian.us EnterpriseDB http://enterprisedb.com + As you are, so once was I. As I am, so you will be. + + Ancient Roman grave inscription +
Re: Running pg_upgrade Version 11
On 11/06/2018 06:30 PM, rob stone wrote: On Tue, 2018-11-06 at 15:17 +0900, Michael Paquier wrote: On Tue, Nov 06, 2018 at 04:27:35PM +1100, rob stone wrote: 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? Having 0600 as umask for those files is normal. Don't you have more logs about the error? You should not see this error, except if data_v10 is not a data folder initialized correctly, so perhaps you messed up something in your environment? -- Michael Problem caused by my eyesight. A colleague pointed out the typo in the argument to the -d parameter. Working as intended. That's why I like to line up my statements /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 -- Angular momentum makes the world go 'round.
Re: Running pg_upgrade Version 11
On Tue, Nov 06, 2018 at 04:27:35PM +1100, rob stone wrote: > 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? Having 0600 as umask for those files is normal. Don't you have more logs about the error? You should not see this error, except if data_v10 is not a data folder initialized correctly, so perhaps you messed up something in your environment? -- Michael signature.asc Description: PGP signature
Running pg_upgrade Version 11
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? TIA, Rob