From: Adrian Klaver <adrian.klaver@aklaver.com>
To: Akshay Ballarpure <akshay.ballarpure@tcs.com>
To: Fabio Pardi <f.pardi@portavita.eu>
Cc: pgsql-general@lists.postgresql.org
Subject: Re: pg_upgrade help
Date: Wed, 18 Apr 2018 07:02:32 -0700
Message-ID: <e6384fa1-0cb0-18fa-77b9-025885befbb7@aklaver.com> (raw)
In-Reply-To: <OFACB70154.78069F6A-ON65258273.0040E9DB-65258273.0042022C@tcs.com>
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>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: adrian.klaver@aklaver.com, akshay.ballarpure@tcs.com, f.pardi@portavita.eu, pgsql-general@lists.postgresql.org
Subject: Re: pg_upgrade help
In-Reply-To: <e6384fa1-0cb0-18fa-77b9-025885befbb7@aklaver.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox