Re: [ADMIN] Upgrade 9.5 cluster with non default data directory with checksum

Поиск
Список
Период
Сортировка
От Debraj Manna
Тема Re: [ADMIN] Upgrade 9.5 cluster with non default data directory with checksum
Дата
Msg-id CAF6DVKOq3vQD--k1b8fQgCpuxFQovC5_tTe-d2q4Exywj_e6vw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: [ADMIN] Upgrade 9.5 cluster with non default data directory with checksum  (Keith <keith@keithf4.com>)
Ответы Re: [ADMIN] Upgrade 9.5 cluster with non default data directory with checksum
Список pgsql-admin
Thanks Keith for your prompt reply. 

But on trying to execute the below command
sudo -H -u postgres /usr/lib/postgresql/10/bin/pg_upgrade \
   -b /usr/lib/postgresql/9.5/bin \
   -B /usr/lib/postgresql/10/bin \
   -d /var/lib/postgresql/data/postgresql0 \
   -D /var/lib/postgresql/10/data/postgresql0 \
   -o ' -c config_file=/etc/postgresql/9.5/main/postgresql.conf' \
   -O ' -c config_file=/etc/postgresql/10/main/postgresql.conf' --check 

It is failing with the below error in pg_upgrade_server.log

command: "/usr/lib/postgresql/9.5/bin/pg_ctl" -w -l "pg_upgrade_server.log" -D "/var/lib/postgresql/data/postgresql0" -o "-p 50432 -b  -c config_file=/etc/postgresql/9.5/main/postgresql.conf -c listen_addresses='' -c unix_socket_permissions=0700 -c unix_socket_directories='/tmp'" start >> "pg_upgrade_server.log" 2>&1
waiting for server to start....2017-11-14 15:27:31 UTC [16239-1] LOG:  database system was shut down at 2017-11-14 15:16:43 UTC
2017-11-14 15:27:31 UTC [16239-2] LOG:  MultiXact member wraparound protections are now enabled
2017-11-14 15:27:31 UTC [16238-1] LOG:  database system is ready to accept connections
........................................................... stopped waiting
pg_ctl: could not start server

I have attached the entire installation log.

Can you let me know what I am doing wrong? Looks like some issue with the port conflict. I have not modified any configuration during the installation 9.5 is running on 5432 and 10 on 5433 as per postgresql.conf.



On Tue, Nov 14, 2017 at 8:29 PM, Keith <keith@keithf4.com> wrote:
I highly advise not using pg_upgradecluster. It's a wrapper script for debian based systems and it obfuscates way too much of the upgrade process as you're seeing yourself with this question. You can use pg_createcluster to create the upgrade target version. Copy your config files over as needed but then just use pg_upgrade itself so it's clear what is getting upgraded and you'll get much better feedback about the process itself if there is a problem.

Keith

On Tue, Nov 14, 2017 at 9:28 AM, Debraj Manna <subharaj.manna@gmail.com> wrote:
Hi

I am trying to upgrade 9.5.4 cluster with data directory as /var/lib/postgresql/data/postgresql0 and have checksum enabled

Can someone let me know is it possible to upgrade this cluster to latest 10.1 using pg_upgradecluster

In pg_upgradecluster man page I am not seeing any option to pass the data directory for the old cluster and also to pass the checksum enabled option?

Thanks,
Debraj


Вложения

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

Предыдущее
От: Keith
Дата:
Сообщение: Re: [ADMIN] Upgrade 9.5 cluster with non default data directory with checksum
Следующее
От: Debraj Manna
Дата:
Сообщение: Re: [ADMIN] Upgrade 9.5 cluster with non default data directory with checksum