pg_upgrade help

From: Akshay Ballarpure <akshay(dot)ballarpure(at)tcs(dot)com>
To: 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: pg_upgrade help
Date: 2018-04-18 07:30:38
Message-ID: OFCDF011F0.3CF96533-ON65258273.002856FC-65258273.002913C0@tcs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-general pgsql-performance

Hi all,
I need help on pg_upgrade from 8.4 to 9.4 version. Appreciate urgent
response.
Installed both version and stopped it. Do i need to run both version or
only one 8.4 or 9.4 . Both should run on 50432 ?

-bash-4.2$ id
uid=26(postgres) gid=26(postgres) groups=26(postgres)
context=unconfined_u:unconfined_r:unconfined_t:s0-s0:c0.c1023

-bash-4.2$ export OLDCLUSTER=/var/ericsson/esm-data/postgresql-data --
8.4 data
-bash-4.2$ export NEWCLUSTER=/var/ericsson/esm-data/postgresql-data-9.4
-- 9.4 data

-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
=====-----=====-----=====
Notice: The information contained in this e-mail
message and/or attachments to it may contain
confidential or privileged information. If you are
not the intended recipient, any dissemination, use,
review, distribution, printing or copying of the
information contained in this e-mail message
and/or attachments to it are strictly prohibited. If
you have received this communication in error,
please notify us by reply e-mail or telephone and
immediately and permanently delete the message
and any attachments. Thank you

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Fabio Pardi 2018-04-18 07:35:52 Re: pg_upgrade help
Previous Message Tom Lane 2018-04-17 18:57:52 Re: Dropping constraints on a table locks referenced table... why?

Browse pgsql-general by date

  From Date Subject
Next Message Thomas Kellerer 2018-04-18 07:31:29 Re: How to fetch data from tables in PostgreSQL
Previous Message vaibhav zaveri 2018-04-18 07:22:16 How to fetch data from tables in PostgreSQL

Browse pgsql-performance by date

  From Date Subject
Next Message Fabio Pardi 2018-04-18 07:35:52 Re: pg_upgrade help
Previous Message Deepak Somaiya 2018-04-17 21:05:54 Citext Performance