Subject: Re: pg_upgrade help
To: Akshay Ballarpure <akshay.ballarpure@tcs.com>,
 Fabio Pardi <f.pardi@portavita.eu>
Cc: pgsql-general@lists.postgresql.org
References: 
 <OFCDF011F0.3CF96533-ON65258273.002856FC-65258273.002913C0@tcs.com>
 <5657f0ad-2510-d589-f860-92b306da475b@portavita.eu>
 <OFC72ADD38.56AF86B7-ON65258273.002DC235-65258273.002EEC8C@tcs.com>
 <8ba65c19-be07-676b-98c5-f1368ecaae92@portavita.eu>
 <OFACB70154.78069F6A-ON65258273.0040E9DB-65258273.0042022C@tcs.com>
From: Adrian Klaver <adrian.klaver@aklaver.com>
Message-ID: <e6384fa1-0cb0-18fa-77b9-025885befbb7@aklaver.com>
Date: Wed, 18 Apr 2018 07:02:32 -0700
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:52.0) Gecko/20100101
 Thunderbird/52.7.0
MIME-Version: 1.0
In-Reply-To: 
 <OFACB70154.78069F6A-ON65258273.0040E9DB-65258273.0042022C@tcs.com>
Content-Type: text/plain; charset=windows-1252; format=flowed
Content-Language: en-US
Content-Transfer-Encoding: 8bit
Precedence: bulk

On 04/18/2018 05:02 AM, Akshay Ballarpure wrote:
> Hi Fabio,
> sorry to bother you again, its still failing with stopping both server 
> (8.4 and 9.4)

Actually according to the command show at bottom of post it is failing 
trying to start the 8.4 server. In your previous post that was because 
it was already running:

-bash-4.2$ ps -eaf | grep postgres
postgres  9778     1  0 09:17 ?        00:00:00 /usr/bin/postgres -p 
50432 -D /var/ericsson/esm-data/postgresql-data/

FATAL:  lock file "postmaster.pid" already exists
HINT:  Is another postmaster (PID 9778) running in data directory 
"/var/ericsson/esm-data/postgresql-data"?
pg_ctl: could not start server


Make sure both servers are stopped before running pg_upgrade. Per a 
previous suggestion follow the check list here:

https://www.postgresql.org/docs/10/static/pgupgrade.html
"
Usage

These are the steps to perform an upgrade with pg_upgrade:

...

"

> 
> -bash-4.2$ /opt/rh/rh-postgresql94/root/usr/bin/pg_upgrade 
> --old-bindir=/usr/bin --new-bindir=/opt/rh/rh-postgresql94/root/usr/bin 
> --old-datadir=$OLDCLUSTER --new-datadir=$NEWCLUSTER
> 
> connection to database failed: could not connect to server: No such file 
> or directory
>          Is the server running locally and accepting
>          connections on Unix domain socket 
> "/var/run/postgresql/.s.PGSQL.50432"?
> 
> 
> could not connect to old postmaster started with the command:
> "/usr/bin/pg_ctl" -w -l "pg_upgrade_server.log" -D 
> "/var/ericsson/esm-data/postgresql-data" -o "-p 50432 -c autovacuum=off 
> -c autovacuum_freeze_max_age=2000000000  -c listen_addresses='' -c 
> unix_socket_permissions=0700" start
> Failure, exiting
> 
> 
> With Best Regards
> Akshay


-- 
Adrian Klaver
adrian.klaver@aklaver.com