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 CAF6DVKPnW48RayrA6ahgbYFf30DBvRW5v3KJNrSEyPyBszP0sQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: [ADMIN] Upgrade 9.5 cluster with non default data directory with checksum  (Debraj Manna <subharaj.manna@gmail.com>)
Ответы Re: [ADMIN] Upgrade 9.5 cluster with non default data directory with checksum
Список pgsql-admin
Дерево обсуждения
At a high level I am following the below steps

Install postgres10

sudo add-apt-repository "deb http://apt.postgresql.org/pub/repos/apt/ trusty-pgdg main"
wget --quiet -O - https://www.postgresql.org/media/keys/ACCC4CF8.asc | sudo apt-key add -
sudo apt-get update
sudo apt-get install postgresql-10

Stop postgresql

sudo service postgresql stop

Create new data directory

sudo -H -u postgres mkdir -p /var/lib/postgresql/10/data/postgresql0

Enable Checksum on the newly created directory

sudo -H -u postgres /usr/lib/postgresql/10/bin/pg_ctl -D /var/lib/postgresql/10/data/postgresql0 initdb -o '--data-checksums'

Then trying to check for upgrade viability with 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 full installation log again.

On Tue, Nov 14, 2017 at 9:13 PM, Debraj Manna <subharaj.manna@gmail.com> wrote:
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 по дате отправления:

Предыдущее
От: Debraj Manna
Дата:
Сообщение: Re: [ADMIN] Upgrade 9.5 cluster with non default data directory with checksum
Следующее
От: Arjun Ranade
Дата:
Сообщение: [ADMIN] PG10 - Out of shared memory / invalid memory alloc request size