Re: pg_upgrade 10.2

2018-06-12 Thread Jerry Sievers
Murthy Nunna writes: > Jerry, > > OMG, I think you nailed this... I know what I did. I cut/pasted the > command from an e-mail... I have seen this issue before with stuff not Oh! I suggest you lose that habit ASAP before ever issuing another command to anything :-) > related to postgres. But t

Re: pg_upgrade 10.2

2018-06-12 Thread Adrian Klaver
On 06/12/2018 02:49 PM, Murthy Nunna wrote: Hi Adrian, Port numbers are correct. I moved the position of -c (-p 5433 -P 5434 -c -r -v). Now it is NOT complaining about old cluster running. However, I am running into a different problem. New cluster database "ifb_prd_last" is not empty Failur

RE: pg_upgrade 10.2

2018-06-12 Thread Murthy Nunna
Jerry, OMG, I think you nailed this... I know what I did. I cut/pasted the command from an e-mail... I have seen this issue before with stuff not related to postgres. But then those commands failed in syntax error and then you know what you did wrong. Similarly, I expect pg_upgrade to throw an

Re: pg_upgrade 10.2

2018-06-12 Thread Jerry Sievers
Murthy Nunna writes: > Hi Adrian, > > Port numbers are correct. > > I moved the position of -c (-p 5433 -P 5434 -c -r -v). Now it is NOT > complaining about old cluster running. However, I am running into a different > problem. I noted in your earlier message the final -c... the dash was not a

RE: pg_upgrade 10.2

2018-06-12 Thread Murthy Nunna
Hi Adrian, Port numbers are correct. I moved the position of -c (-p 5433 -P 5434 -c -r -v). Now it is NOT complaining about old cluster running. However, I am running into a different problem. New cluster database "ifb_prd_last" is not empty Failure, exiting Note: ifb_prd_last is not new clus

Re: pg_upgrade 10.2

2018-06-12 Thread Adrian Klaver
On 06/12/2018 02:18 PM, Murthy Nunna wrote: pg_upgrade -V pg_upgrade (PostgreSQL) 10.4 pg_upgrade -b /fnal/ups/prd/postgres/v9_3_14_x64/Linux-2-6/bin -B /fnal/ups/prd/postgres/v10_4_x64/Linux-2-6/bin -d /data0/pgdata/ifb_prd_last -D /data0/pgdata/ifb_prd_last_104 -p 5433 -P 5434 -r -v –c L

RE: pg_upgrade 10.2

2018-06-12 Thread Murthy Nunna
pg_upgrade -V pg_upgrade (PostgreSQL) 10.4 pg_upgrade -b /fnal/ups/prd/postgres/v9_3_14_x64/Linux-2-6/bin -B /fnal/ups/prd/postgres/v10_4_x64/Linux-2-6/bin -d /data0/pgdata/ifb_prd_last -D /data0/pgdata/ifb_prd_last_104 -p 5433 -P 5434 -r -v –c -Original Message- From: Adrian Klaver [m

Re: pg_upgrade 10.2

2018-06-12 Thread Adrian Klaver
On 06/12/2018 01:58 PM, Murthy Nunna wrote: Thanks Adrian. I removed "-k" flag. But still got same error. There seems to be a postmaster servicing the old cluster. Please shutdown that postmaster and try again. Failure, exiting Well according to the code in pg_upgrade.c that message should no

RE: pg_upgrade 10.2

2018-06-12 Thread Murthy Nunna
Thanks Adrian. I removed "-k" flag. But still got same error. There seems to be a postmaster servicing the old cluster. Please shutdown that postmaster and try again. Failure, exiting -Original Message- From: Adrian Klaver [mailto:adrian.kla...@aklaver.com] Sent: Tuesday, June 12, 2018 3

Re: pg_upgrade 10.2

2018-06-12 Thread Adrian Klaver
On 06/12/2018 01:34 PM, Murthy Nunna wrote: In older versions of pg_upgrade (e.g from 9.2 to 9.3), I was able to run pg_upgrade without stopping old cluster using the check flag. pg_upgrade -b -B -d -D -p 5432 -P 5434 -r -v -k -c Note the “c” flag at the end I take the below to it mean

pg_upgrade 10.2

2018-06-12 Thread Murthy Nunna
In older versions of pg_upgrade (e.g from 9.2 to 9.3), I was able to run pg_upgrade without stopping old cluster using the check flag. pg_upgrade -b -B -d -D -p 5432 -P 5434 -r -v -k -c Note the "c" flag at the end However pg_upgrade in 10 (I tried from 9.3 to 10.4), when I did not stop th