Re: pg_upgrade 10.2

2018-06-12 Thread Jerry Sievers
Murthy Nunna writes: BTW, this message was and remained cross-posted to 3 groups which is considered bad style around here and I was negligent too in the previous reply which also went out to all of them. Please take note. Thank -- Jerry Sievers Postgres DBA/Development Consulting e:

Re: pg_upgrade 10.2

2018-06-12 Thread Jerry Sievers
rry Sievers [mailto:gsiever...@comcast.net] > Sent: Tuesday, June 12, 2018 6:24 PM > To: Murthy Nunna > Cc: Adrian Klaver ; > pgsql-general@lists.postgresql.org; pgsql-ad...@lists.postgresql.org; > pgsql-performa...@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

RE: pg_upgrade 10.2

2018-06-12 Thread Murthy Nunna
[mailto:gsiever...@comcast.net] Sent: Tuesday, June 12, 2018 6:24 PM To: Murthy Nunna Cc: Adrian Klaver ; pgsql-general@lists.postgresql.org; pgsql-ad...@lists.postgresql.org; pgsql-performa...@lists.postgresql.org Subject: Re: pg_upgrade 10.2 Murthy Nunna writes: > Hi Adrian, > > Por

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-general@lists.postgresql.org; pgsql-ad...@lists.postgresql.org; pgsql-performa...@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

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-general@lists.postgresql.org; pgsql-ad...@lists.postgresql.org; pgsql-performa...@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

RE: pg_upgrade 10.2

2018-06-12 Thread Murthy Nunna
e 12, 2018 3:48 PM To: Murthy Nunna ; pgsql-general@lists.postgresql.org; pgsql-ad...@lists.postgresql.org; pgsql-performa...@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