Re: pg_upgrade 10.2

2018-06-12 Thread Jerry Sievers
; From: Jerry Sievers [mailto:gsiever...@comcast.net] > Sent: Tuesday, June 12, 2018 6:24 PM > To: Murthy Nunna > Cc: Adrian Klaver ; > pgsql-gene...@lists.postgresql.org; pgsql-ad...@lists.postgresql.org; > pgsql-performance@lists.postgresql.org > Subject: Re: pg_upgrade 10.2 >

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
ry Sievers [mailto:gsiever...@comcast.net] Sent: Tuesday, June 12, 2018 6:24 PM To: Murthy Nunna Cc: Adrian Klaver ; pgsql-gene...@lists.postgresql.org; pgsql-ad...@lists.postgresql.org; pgsql-performance@lists.postgresql.org Subject: Re: pg_upgrade 10.2 Murthy Nunna writes: > Hi Adrian, > &g

Re: pg_upgrade 10.2

2018-06-12 Thread Jerry Sievers
2018 4:35 PM > To: Murthy Nunna ; pgsql-gene...@lists.postgresql.org; > pgsql-ad...@lists.postgresql.org; pgsql-performance@lists.postgresql.org > Subject: Re: pg_upgrade 10.2 > > On 06/12/2018 02:18 PM, Murthy Nunna wrote: >> pg_upgrade -V >> pg_upgrade (PostgreSQL) 10.4 >> &

RE: pg_upgrade 10.2

2018-06-12 Thread Murthy Nunna
al Message- From: Adrian Klaver [mailto:adrian.kla...@aklaver.com] Sent: Tuesday, June 12, 2018 4:35 PM To: Murthy Nunna ; pgsql-gene...@lists.postgresql.org; pgsql-ad...@lists.postgresql.org; pgsql-performance@lists.postgresql.org Subject: Re: pg_upgrade 10.2 On 06/12/2018 02:18 PM, Murthy N

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
[mailto:adrian.kla...@aklaver.com] Sent: Tuesday, June 12, 2018 4:13 PM To: Murthy Nunna ; pgsql-gene...@lists.postgresql.org; pgsql-ad...@lists.postgresql.org; pgsql-performance@lists.postgresql.org Subject: Re: pg_upgrade 10.2 On 06/12/2018 01:58 PM, Murthy Nunna wrote: > Thanks Adrian.

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
e 12, 2018 3:48 PM To: Murthy Nunna ; pgsql-gene...@lists.postgresql.org; pgsql-ad...@lists.postgresql.org; pgsql-performance@lists.postgresql.org Subject: Re: pg_upgrade 10.2 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 >

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