pg_upgrade help

Поиск
Список
Период
Сортировка
От Akshay Ballarpure
Тема pg_upgrade help
Дата
Msg-id OFCDF011F0.3CF96533-ON65258273.002856FC-65258273.002913C0@tcs.com
обсуждение исходный текст
Ответы Re: pg_upgrade help  (Fabio Pardi <f.pardi@portavita.eu>)
Re: pg_upgrade help  (Sergei Kornilov <sk@zsrv.org>)
Re: pg_upgrade help  (Sergei Kornilov <sk@zsrv.org>)
Re: pg_upgrade help  (Sergei Kornilov <sk@zsrv.org>)
Список pgsql-general
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

В списке pgsql-general по дате отправления:

Предыдущее
От: vaibhav zaveri
Дата:
Сообщение: How to fetch data from tables in PostgreSQL
Следующее
От: Thomas Kellerer
Дата:
Сообщение: Re: How to fetch data from tables in PostgreSQL