RE: pg_upgrade 10.2

From: Murthy Nunna <mnunna(at)fnal(dot)gov>
To: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>, "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>, "pgsql-admin(at)lists(dot)postgresql(dot)org" <pgsql-admin(at)lists(dot)postgresql(dot)org>, "pgsql-performance(at)lists(dot)postgresql(dot)org" <pgsql-performance(at)lists(dot)postgresql(dot)org>
Subject: RE: pg_upgrade 10.2
Date: 2018-06-12 21:18:07
Message-ID: DM5PR09MB15156F523C5E066175669CB1B87F0@DM5PR09MB1515.namprd09.prod.outlook.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-general pgsql-performance

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 [mailto:adrian(dot)klaver(at)aklaver(dot)com]
Sent: Tuesday, June 12, 2018 4:13 PM
To: Murthy Nunna <mnunna(at)fnal(dot)gov>; pgsql-general(at)lists(dot)postgresql(dot)org; pgsql-admin(at)lists(dot)postgresql(dot)org; pgsql-performance(at)lists(dot)postgresql(dot)org
Subject: Re: pg_upgrade 10.2

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 not be reached when the check option is specified:

if (!user_opts.check)
pg_fatal("There seems to be a postmaster servicing the old cluster.\n"
"Please shutdown that postmaster and try again.\n"); else
*live_check = true;

Can we see the actual command you ran?

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Rui DeSousa 2018-06-12 21:25:40 Re: PostgreSQL 'Corruption & Fragmentation' detection and resolution/fix
Previous Message Adrian Klaver 2018-06-12 21:13:27 Re: pg_upgrade 10.2

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2018-06-12 21:34:52 Re: pg_upgrade 10.2
Previous Message Adrian Klaver 2018-06-12 21:13:27 Re: pg_upgrade 10.2

Browse pgsql-performance by date

  From Date Subject
Next Message Adrian Klaver 2018-06-12 21:34:52 Re: pg_upgrade 10.2
Previous Message Adrian Klaver 2018-06-12 21:13:27 Re: pg_upgrade 10.2