Re: [ADMIN] Upgrading postgres to 10 running with patroni - Mailing list pgsql-admin
From | Debraj Manna |
---|---|
Subject | Re: [ADMIN] Upgrading postgres to 10 running with patroni |
Date | |
Msg-id | CAF6DVKMvdgHRXQ_pGhL1UYUoMDN9EY-UOYV+AbpQXbvsBfEJSg@mail.gmail.com Whole thread Raw |
In response to | Re: [ADMIN] Upgrading postgres to 10 running with patroni (Magnus Hagander <magnus@hagander.net>) |
Responses |
Re: [ADMIN] Upgrading postgres to 10 running with patroni
|
List | pgsql-admin |
Thanks Magnus. I will upgrade patroni and come back with my findings.
Do you find any other faults in the steps that I have been performing.
On Thu, Nov 16, 2017 at 1:10 PM, Magnus Hagander <magnus@hagander.net> wrote:
You need Patroni 1.3 to work with postgresql version 10. My guess is that's where your problem is./MagnusOn Nov 16, 2017 08:34, "Debraj Manna" <subharaj.manna@gmail.com> wrote:--I am attaching my patroni.yml for reference.On Thu, Nov 16, 2017 at 12:59 PM, Debraj Manna <subharaj.manna@gmail.com> wrote:HiI am trying to upgrade postgres 9.5 to postgres 10 running with patroni. I am using patroni 1.0 with single node postgres.The steps that I have been following -Stop patronisudo kill -9 <patroni process id>Install postgres-10sudo 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 updatesudo apt-get install postgresql-10Stop postgresql clusterInit data directory for the new upgradesudo -H -u postgres mkdir -p /var/lib/postgresql/10/data/postgresql0 sudo -H -u postgres /usr/lib/postgresql/10/bin/pg_ctl -D /var/lib/postgresql/10/data/po stgresql0 initdb -o '--data-checksums' -o '--locale=C' -o '--encoding=utf8' Change data_directory in postgresq.conf for both 9.5 & 10data_directory - /var/lib/postgresql/data/postgresql0 # For postgresql-9.5 data_directory - /var/lib/postgresql/10/data/postgresql0 # For postgresql-10 Perform the upgradecd /tmpsudo -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' -k ./analyze_new_cluster.sh reported success.Copy conf filesCopiedpostgresql.base.conf
,p
,ostgresql.conf pg_hba.conf
&postmaster.opts
from 9.5 data directory/var/lib/postgresql/
to the 10 data directorydata/postgresql0 /var/lib/postgresql/
10/data/postgresql0 Changepostmaster.opts
to matchpostgres-10
locations/usr/lib/postgresql/10/bin/postgres "-D" "/var/lib/postgresql/10/data/p ostgresql0" "-p" "50432" "-b" "-c" "config_file=/etc/postgresql/1 0/main/postgresql.conf" "-c" "listen_addresses=" "-c" "unix_socket_permissions=0700" "-c" "unix_socket_directories=/tmp" Changedata_dir
inpatroni.yml
to /var/lib/postgresql/10/data
/postgresql0
On starting patroni I am getting exception like below and also the DB is not accessible.2017-11-16 07:11:18,622 INFO: Connecting to localhost:2181 2017-11-16 07:11:18,624 INFO: Zookeeper connection established, state: CONNECTED 2017-11-16 07:11:19,132 INFO: Closing connection to localhost:2181 2017-11-16 07:11:19,132 INFO: Zookeeper session lost, state: CLOSED 2017-11-16 07:11:19,133 INFO: Connecting to localhost:2181 2017-11-16 07:11:19,135 INFO: Zookeeper connection established, state: CONNECTED Traceback (most recent call last): File "/usr/local/bin/patroni", line 11, in <module> load_entry_point('patroni==1.0
', 'console_scripts', 'patroni')() File "/usr/local/lib/python2.7/dist -packages/patroni/__init__.py" , line 128, in main patroni.run() File "/usr/local/lib/python2.7/dist -packages/patroni/__init__.py" , line 102, in run logger.info(self.ha.run_cycle( )) File "/usr/local/lib/python2.7/dist -packages/patroni/ha.py", line 502, in run_cycle return self._run_cycle() File "/usr/local/lib/python2.7/dist -packages/patroni/ha.py", line 470, in _run_cycle if self.sysid_valid(self.cluster. initialize) and self.cluster.initialize != self.state_handler.sysid: File "/usr/local/lib/python2.7/dist -packages/patroni/postgresql.p y", line 257, in sysid data = self.controldata() File "/usr/local/lib/python2.7/dist -packages/patroni/postgresql.p y", line 675, in controldata result = {l.split(':')[0].replace('Curr ent ', '', 1): l.split(':')[1].strip() for l in data if l} File "/usr/local/lib/python2.7/dist -packages/patroni/postgresql.p y", line 675, in <dictcomp> result = {l.split(':')[0].replace('Curr ent ', '', 1): l.split(':')[1].strip() for l in data if l} IndexError: list index out of range ~ I was able to access the DB before starting patroni. So I think I missed something on patroni side.I am not sure if this is the right forum to ask this question. If anyone has tried this please do let me know your thoughts.
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
pgsql-admin by date: