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
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? |
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 |
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 |