Re: Upgrade 9.5 cluster with non default data directory with checksum

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(dot)manna(at)gmail(dot)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(at)keithf4(dot)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(dot)manna(at)gmail(dot)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
>>>
>>
>>
>