pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedUpgrading postgres to 10 running with patroni
8+ messages / 3 participants
[nested] [flat]
* Upgrading postgres to 10 running with patroni
@ 2017-11-16 07:29 Debraj Manna <subharaj.manna@gmail.com>
0 siblings, 1 reply; 8+ messages in thread
From: Debraj Manna @ 2017-11-16 07:29 UTC (permalink / raw)
To: pgsql-admin
Hi
I 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 patroni*
sudo kill -9 <patroni process id>
*Install postgres-10*
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 cluster*
*Init data directory for the new upgrade*
sudo -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/postgresql0 initdb -o '--data-checksums' -o
'--locale=C' -o '--encoding=utf8'
*Change data_directory in postgresq.conf for both 9.5 & 10*
data_directory - /var/lib/postgresql/data/postgresql0 # For
postgresql-9.5
data_directory - /var/lib/postgresql/10/data/postgresql0 # For
postgresql-10
*Perform the upgrade*
cd /tmp
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' -k
*./analyze_new_cluster.sh reported success.*
*Copy conf files*
Copied postgresql.base.conf, postgresql.conf , pg_hba.conf &
postmaster.opts from
9.5 data directory /var/lib/postgresql/data/postgresql0 to the 10 data
directory /var/lib/postgresql/10/data/postgresql0
*Change postmaster.opts to match postgres-10 locations*
/usr/lib/postgresql/10/bin/postgres "-D"
"/var/lib/postgresql/10/data/postgresql0" "-p" "50432" "-b" "-c"
"config_file=/etc/postgresql/10/main/postgresql.conf" "-c"
"listen_addresses=" "-c" "unix_socket_permissions=0700" "-c"
"unix_socket_directories=/tmp"
*Change data_dir in patroni.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.py",
line 257, in sysid
data = self.controldata()
File "/usr/local/lib/python2.7/dist-packages/patroni/postgresql.py",
line 675, in controldata
result = {l.split(':')[0].replace('Current ', '', 1):
l.split(':')[1].strip() for l in data if l}
File "/usr/local/lib/python2.7/dist-packages/patroni/postgresql.py",
line 675, in <dictcomp>
result = {l.split(':')[0].replace('Current ', '', 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.
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: Upgrading postgres to 10 running with patroni
@ 2017-11-16 07:32 Debraj Manna <subharaj.manna@gmail.com>
parent: Debraj Manna <subharaj.manna@gmail.com>
0 siblings, 1 reply; 8+ messages in thread
From: Debraj Manna @ 2017-11-16 07:32 UTC (permalink / raw)
To: pgsql-admin
I am attaching my patroni.yml for reference.
On Thu, Nov 16, 2017 at 12:59 PM, Debraj Manna <subharaj.manna@gmail.com>
wrote:
> Hi
>
> I 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 patroni*
> sudo kill -9 <patroni process id>
>
>
> *Install postgres-10*
> 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 cluster*
>
> *Init data directory for the new upgrade*
> sudo -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/postgresql0 initdb -o '--data-checksums' -o
> '--locale=C' -o '--encoding=utf8'
>
> *Change data_directory in postgresq.conf for both 9.5 & 10*
> data_directory - /var/lib/postgresql/data/postgresql0 # For
> postgresql-9.5
> data_directory - /var/lib/postgresql/10/data/postgresql0 # For
> postgresql-10
>
> *Perform the upgrade*
> cd /tmp
> 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' -k
>
> *./analyze_new_cluster.sh reported success.*
>
> *Copy conf files*
> Copied postgresql.base.conf, postgresql.conf , pg_hba.conf &
> postmaster.opts from 9.5 data directory /var/lib/postgresql/
> data/postgresql0 to the 10 data directory /var/lib/postgresql/
> 10/data/postgresql0
>
>
> *Change postmaster.opts to match postgres-10 locations*
> /usr/lib/postgresql/10/bin/postgres "-D" "/var/lib/postgresql/10/data/postgresql0"
> "-p" "50432" "-b" "-c" "config_file=/etc/postgresql/10/main/postgresql.conf"
> "-c" "listen_addresses=" "-c" "unix_socket_permissions=0700" "-c"
> "unix_socket_directories=/tmp"
>
> *Change data_dir in patroni.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.py", line 257, in sysid
> data = self.controldata()
> File "/usr/local/lib/python2.7/dist-packages/patroni/postgresql.py", line 675, in controldata
> result = {l.split(':')[0].replace('Current ', '', 1): l.split(':')[1].strip() for l in data if l}
> File "/usr/local/lib/python2.7/dist-packages/patroni/postgresql.py", line 675, in <dictcomp>
> result = {l.split(':')[0].replace('Current ', '', 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
Attachments:
patroni.yml (application/octet-stream, 2.4K) download
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: Upgrading postgres to 10 running with patroni
@ 2017-11-16 07:40 Magnus Hagander <magnus@hagander.net>
parent: Debraj Manna <subharaj.manna@gmail.com>
0 siblings, 1 reply; 8+ messages in thread
From: Magnus Hagander @ 2017-11-16 07:40 UTC (permalink / raw)
To: Debraj Manna <subharaj.manna@gmail.com>; +Cc: pgsql-admin
You need Patroni 1.3 to work with postgresql version 10. My guess is that's
where your problem is.
/Magnus
On 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:
>
>> Hi
>>
>> I 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 patroni*
>> sudo kill -9 <patroni process id>
>>
>>
>> *Install postgres-10*
>> 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 cluster*
>>
>> *Init data directory for the new upgrade*
>> sudo -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/postgresql0 initdb -o '--data-checksums' -o
>> '--locale=C' -o '--encoding=utf8'
>>
>> *Change data_directory in postgresq.conf for both 9.5 & 10*
>> data_directory - /var/lib/postgresql/data/postgresql0 # For
>> postgresql-9.5
>> data_directory - /var/lib/postgresql/10/data/postgresql0 # For
>> postgresql-10
>>
>> *Perform the upgrade*
>> cd /tmp
>> 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' -k
>>
>> *./analyze_new_cluster.sh reported success.*
>>
>> *Copy conf files*
>> Copied postgresql.base.conf, postgresql.conf , pg_hba.conf &
>> postmaster.opts from 9.5 data directory /var/lib/postgresql/
>> data/postgresql0 to the 10 data directory /var/lib/postgresql/
>> 10/data/postgresql0
>>
>>
>> *Change postmaster.opts to match postgres-10 locations*
>> /usr/lib/postgresql/10/bin/postgres "-D" "/var/lib/postgresql/10/data/postgresql0"
>> "-p" "50432" "-b" "-c" "config_file=/etc/postgresql/10/main/postgresql.conf"
>> "-c" "listen_addresses=" "-c" "unix_socket_permissions=0700" "-c"
>> "unix_socket_directories=/tmp"
>>
>> *Change data_dir in patroni.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.py", line 257, in sysid
>> data = self.controldata()
>> File "/usr/local/lib/python2.7/dist-packages/patroni/postgresql.py", line 675, in controldata
>> result = {l.split(':')[0].replace('Current ', '', 1): l.split(':')[1].strip() for l in data if l}
>> File "/usr/local/lib/python2.7/dist-packages/patroni/postgresql.py", line 675, in <dictcomp>
>> result = {l.split(':')[0].replace('Current ', '', 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
>
>
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: Upgrading postgres to 10 running with patroni
@ 2017-11-16 08:34 Debraj Manna <subharaj.manna@gmail.com>
parent: Magnus Hagander <magnus@hagander.net>
0 siblings, 1 reply; 8+ messages in thread
From: Debraj Manna @ 2017-11-16 08:34 UTC (permalink / raw)
To: Magnus Hagander <magnus@hagander.net>; +Cc: 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.
>
> /Magnus
>
> On 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:
>>
>>> Hi
>>>
>>> I 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 patroni*
>>> sudo kill -9 <patroni process id>
>>>
>>>
>>> *Install postgres-10*
>>> 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 cluster*
>>>
>>> *Init data directory for the new upgrade*
>>> sudo -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/postgresql0 initdb -o '--data-checksums' -o
>>> '--locale=C' -o '--encoding=utf8'
>>>
>>> *Change data_directory in postgresq.conf for both 9.5 & 10*
>>> data_directory - /var/lib/postgresql/data/postgresql0 # For
>>> postgresql-9.5
>>> data_directory - /var/lib/postgresql/10/data/postgresql0 # For
>>> postgresql-10
>>>
>>> *Perform the upgrade*
>>> cd /tmp
>>> 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' -k
>>>
>>> *./analyze_new_cluster.sh reported success.*
>>>
>>> *Copy conf files*
>>> Copied postgresql.base.conf, postgresql.conf , pg_hba.conf &
>>> postmaster.opts from 9.5 data directory /var/lib/postgresql/
>>> data/postgresql0 to the 10 data directory /var/lib/postgresql/
>>> 10/data/postgresql0
>>>
>>>
>>> *Change postmaster.opts to match postgres-10 locations*
>>> /usr/lib/postgresql/10/bin/postgres "-D" "/var/lib/postgresql/10/data/postgresql0"
>>> "-p" "50432" "-b" "-c" "config_file=/etc/postgresql/10/main/postgresql.conf"
>>> "-c" "listen_addresses=" "-c" "unix_socket_permissions=0700" "-c"
>>> "unix_socket_directories=/tmp"
>>>
>>>
>>> *Change data_dir in patroni.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.py", line 257, in sysid
>>> data = self.controldata()
>>> File "/usr/local/lib/python2.7/dist-packages/patroni/postgresql.py", line 675, in controldata
>>> result = {l.split(':')[0].replace('Current ', '', 1): l.split(':')[1].strip() for l in data if l}
>>> File "/usr/local/lib/python2.7/dist-packages/patroni/postgresql.py", line 675, in <dictcomp>
>>> result = {l.split(':')[0].replace('Current ', '', 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
>>
>>
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: Upgrading postgres to 10 running with patroni
@ 2017-11-16 19:25 Debraj Manna <subharaj.manna@gmail.com>
parent: Debraj Manna <subharaj.manna@gmail.com>
0 siblings, 2 replies; 8+ messages in thread
From: Debraj Manna @ 2017-11-16 19:25 UTC (permalink / raw)
To: Magnus Hagander <magnus@hagander.net>; +Cc: pgsql-admin
After upgrading my patroni to 1.3.6 I am not seeing any exception. But on
trying to start patroini I am seeing logs like below
ubuntu@vrni-platform:/var/log/postgresql$ patroni /etc/patroni/patroni.yml
2017-11-16 19:19:38,036 INFO: Connecting to localhost:2181
2017-11-16 19:19:38,040 INFO: Zookeeper connection established, state: CONNECTED
2017-11-16 19:19:38,053 INFO: Lock owner: None; I am postgresql0
2017-11-16 19:19:38,058 INFO: waiting for leader to bootstrap
2017-11-16 19:19:38,061 INFO: Lock owner: None; I am postgresql0
2017-11-16 19:19:38,061 INFO: waiting for leader to bootstrap
Also postgres is not running
psql -U postgres -d vnera -p 5432 -h 127.0.0.1
psql: could not connect to server: Connection refused
Is the server running on host "127.0.0.1" and accepting
TCP/IP connections on port 5432?
Can someone let me know how can I get around this? Do I have to make
any changes in `patroni.yml` after upgrading to 1.3.6 ?
On Thu, Nov 16, 2017 at 2:04 PM, Debraj Manna <subharaj.manna@gmail.com>
wrote:
> 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.
>>
>> /Magnus
>>
>> On 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:
>>>
>>>> Hi
>>>>
>>>> I 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 patroni*
>>>> sudo kill -9 <patroni process id>
>>>>
>>>>
>>>> *Install postgres-10*
>>>> 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 cluster*
>>>>
>>>> *Init data directory for the new upgrade*
>>>> sudo -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/postgresql0 initdb -o '--data-checksums'
>>>> -o '--locale=C' -o '--encoding=utf8'
>>>>
>>>> *Change data_directory in postgresq.conf for both 9.5 & 10*
>>>> data_directory - /var/lib/postgresql/data/postgresql0 # For
>>>> postgresql-9.5
>>>> data_directory - /var/lib/postgresql/10/data/postgresql0 # For
>>>> postgresql-10
>>>>
>>>> *Perform the upgrade*
>>>> cd /tmp
>>>> 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' -k
>>>>
>>>> *./analyze_new_cluster.sh reported success.*
>>>>
>>>> *Copy conf files*
>>>> Copied postgresql.base.conf, postgresql.conf , pg_hba.conf &
>>>> postmaster.opts from 9.5 data directory /var/lib/postgresql/
>>>> data/postgresql0 to the 10 data directory /var/lib/postgresql/
>>>> 10/data/postgresql0
>>>>
>>>>
>>>> *Change postmaster.opts to match postgres-10 locations*
>>>> /usr/lib/postgresql/10/bin/postgres "-D" "/var/lib/postgresql/10/data/postgresql0"
>>>> "-p" "50432" "-b" "-c" "config_file=/etc/postgresql/10/main/postgresql.conf"
>>>> "-c" "listen_addresses=" "-c" "unix_socket_permissions=0700" "-c"
>>>> "unix_socket_directories=/tmp"
>>>>
>>>>
>>>> *Change data_dir in patroni.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.py", line 257, in sysid
>>>> data = self.controldata()
>>>> File "/usr/local/lib/python2.7/dist-packages/patroni/postgresql.py", line 675, in controldata
>>>> result = {l.split(':')[0].replace('Current ', '', 1): l.split(':')[1].strip() for l in data if l}
>>>> File "/usr/local/lib/python2.7/dist-packages/patroni/postgresql.py", line 675, in <dictcomp>
>>>> result = {l.split(':')[0].replace('Current ', '', 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
>>>
>>>
>
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: Upgrading postgres to 10 running with patroni
@ 2017-11-17 07:46 Debraj Manna <subharaj.manna@gmail.com>
parent: Debraj Manna <subharaj.manna@gmail.com>
1 sibling, 0 replies; 8+ messages in thread
From: Debraj Manna @ 2017-11-17 07:46 UTC (permalink / raw)
To: ; +Cc: pgsql-admin
Any one any thoughts?
Sent from GMail on Android
On Nov 17, 2017 12:55 AM, "Debraj Manna" <subharaj.manna@gmail.com> wrote:
> After upgrading my patroni to 1.3.6 I am not seeing any exception. But on
> trying to start patroini I am seeing logs like below
>
> ubuntu@vrni-platform:/var/log/postgresql$ patroni /etc/patroni/patroni.yml
> 2017-11-16 19:19:38,036 INFO: Connecting to localhost:2181
> 2017-11-16 19:19:38,040 INFO: Zookeeper connection established, state: CONNECTED
> 2017-11-16 19:19:38,053 INFO: Lock owner: None; I am postgresql0
> 2017-11-16 19:19:38,058 INFO: waiting for leader to bootstrap
> 2017-11-16 19:19:38,061 INFO: Lock owner: None; I am postgresql0
> 2017-11-16 19:19:38,061 INFO: waiting for leader to bootstrap
>
> Also postgres is not running
>
> psql -U postgres -d vnera -p 5432 -h 127.0.0.1
> psql: could not connect to server: Connection refused
> Is the server running on host "127.0.0.1" and accepting
> TCP/IP connections on port 5432?
>
> Can someone let me know how can I get around this? Do I have to make any changes in `patroni.yml` after upgrading to 1.3.6 ?
>
>
>
> On Thu, Nov 16, 2017 at 2:04 PM, Debraj Manna <subharaj.manna@gmail.com>
> wrote:
>
>> 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.
>>>
>>> /Magnus
>>>
>>> On 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:
>>>>
>>>>> Hi
>>>>>
>>>>> I 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 patroni*
>>>>> sudo kill -9 <patroni process id>
>>>>>
>>>>>
>>>>> *Install postgres-10*
>>>>> 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 cluster*
>>>>>
>>>>> *Init data directory for the new upgrade*
>>>>> sudo -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/postgresql0 initdb -o '--data-checksums'
>>>>> -o '--locale=C' -o '--encoding=utf8'
>>>>>
>>>>> *Change data_directory in postgresq.conf for both 9.5 & 10*
>>>>> data_directory - /var/lib/postgresql/data/postgresql0 # For
>>>>> postgresql-9.5
>>>>> data_directory - /var/lib/postgresql/10/data/postgresql0 # For
>>>>> postgresql-10
>>>>>
>>>>> *Perform the upgrade*
>>>>> cd /tmp
>>>>> 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' -k
>>>>>
>>>>> *./analyze_new_cluster.sh reported success.*
>>>>>
>>>>> *Copy conf files*
>>>>> Copied postgresql.base.conf, postgresql.conf , pg_hba.conf &
>>>>> postmaster.opts from 9.5 data directory /var/lib/postgresql/
>>>>> data/postgresql0 to the 10 data directory /var/lib/postgresql/
>>>>> 10/data/postgresql0
>>>>>
>>>>>
>>>>> *Change postmaster.opts to match postgres-10 locations*
>>>>> /usr/lib/postgresql/10/bin/postgres "-D"
>>>>> "/var/lib/postgresql/10/data/postgresql0" "-p" "50432" "-b" "-c"
>>>>> "config_file=/etc/postgresql/10/main/postgresql.conf" "-c"
>>>>> "listen_addresses=" "-c" "unix_socket_permissions=0700" "-c"
>>>>> "unix_socket_directories=/tmp"
>>>>>
>>>>>
>>>>> *Change data_dir in patroni.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.py", line 257, in sysid
>>>>> data = self.controldata()
>>>>> File "/usr/local/lib/python2.7/dist-packages/patroni/postgresql.py", line 675, in controldata
>>>>> result = {l.split(':')[0].replace('Current ', '', 1): l.split(':')[1].strip() for l in data if l}
>>>>> File "/usr/local/lib/python2.7/dist-packages/patroni/postgresql.py", line 675, in <dictcomp>
>>>>> result = {l.split(':')[0].replace('Current ', '', 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
>>>>
>>>>
>>
>
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: [ADMIN] Upgrading postgres to 10 running with patroni
@ 2017-12-01 10:17 Alex Kliukin <alexk@hintbits.com>
parent: Debraj Manna <subharaj.manna@gmail.com>
1 sibling, 1 reply; 8+ messages in thread
From: Alex Kliukin @ 2017-12-01 10:17 UTC (permalink / raw)
To: Debraj Manna <subharaj.manna@gmail.com>; Magnus Hagander <magnus@hagander.net>; +Cc: pgsql-admin
Hello,
On Thu, Nov 16, 2017, at 08:32, Debraj Manna 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:>> Hi
>>
>> I am trying to upgrade postgres 9.5 to postgres 10 running with
>> patroni. I am using patroni 1.0 with single node postgres.
Patroni 1.0 is very old. Use the latest version.
The simplest course of actions is to shut down Patroni altogether (it
will also shut down PostgreSQL), upgrade your database using pg_upgrade,
making sure it starts afterwards and then rewrite your patroni.yaml to
match the new cluster (changing at least the data directory and the
bin_dir pointing to the server binaries, but also any other
configuration options from the older version that are incompatible with
the new ones).
Once you do this, start Patroni - it will start your PostgreSQL cluster.
>>
>> The steps that I have been following -
>>
>> *_Stop patroni_*
>> sudo kill -9 <patroni process id>
Don't do it. If you want Patroni to stop managing your cluster your can
put it into the standby mode (patronict pause cluster_name). It will not
do auto failovers for your afterwards, until you resume it. But given
you are running a single node and you need to stop PostgreSQL anyway -
there is no reason to detach Patroni instead of just shutting it down
(it will also shut down PostgreSQL).
>>
>>
>> *_Install postgres-10_*
>> 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 cluster_*
>>
>> *_Init data directory for the new upgrade_*
>> sudo -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/postgresql0 initdb -o '--data-checksums'
>> -o '--locale=C' -o '--encoding=utf8'>>
>> _*Change data_directory in postgresq.conf for both 9.5 & 10*_
>> data_directory - /var/lib/postgresql/data/postgresql0 # For
>> postgresql-9.5>> data_directory - /var/lib/postgresql/10/data/postgresql0 # For
>> postgresql-10>>
>> *_Perform the upgrade_*
>> cd /tmp
>> 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' -k
>>
>> *_./analyze_new_cluster.sh reported success._*
>>
>> *_Copy conf files_*
>> Copied postgresql.base.conf, postgresql.conf , pg_hba.conf &
>> postmaster.opts from 9.5 data directory
>> /var/lib/postgresql/data/postgresql0 to the 10 data directory
>> /var/lib/postgresql/10/data/postgresql0
The last step is definitely wrong. You should not copy postmaster.opts,
postgresql.base.conf and postgresql.conf. Instead, you should configure
the postgresql.conf in the PostgreSQL 10 data directory to match the
parameters of your old cluster. Copying pg_hba.conf seems alright, since
the one from 9.5 is compatible with 10.
After doing so, make sure your PostgreSQL 10 cluster starts on its own,
without Patroni, and there are no complaints about invalid PostgreSQL
parameters.
>>
>>
>> *_Change postmaster.opts to match postgres-10 locations_*
>> /usr/lib/postgresql/10/bin/postgres "-D"
>> "/var/lib/postgresql/10/data/postgresql0" "-p" "50432" "-b" "-c"
>> "config_file=/etc/postgresql/10/main/postgresql.conf" "-c"
>> "listen_addresses=" "-c" "unix_socket_permissions=0700" "-c"
>> "unix_socket_directories=/tmp"
Do not meddle with postmaster.opts altogether.
>>
>> *_Change data_dir in patroni.yml
>> to/var/lib/postgresql/10/data/postgresql0_*
You should use your old patroni.yaml as a reference and write the new
one. Namely, the data_dir and the bin_dir, and the config_dir (if set in
the old one) should point to the new version.
>>
>> 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.py", line 257, in sysid data =
>> self.controldata() File "/usr/local/lib/python2.7/dist-
>> packages/patroni/postgresql.py", line 675, in controldata result =
>> {l.split(':')[0].replace('Current ', '', 1): l.split(':')[1].strip()
>> for l in data if l} File "/usr/local/lib/python2.7/dist-
>> packages/patroni/postgresql.py", line 675, in <dictcomp> result =
>> {l.split(':')[0].replace('Current ', '', 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.
The right place is to ask is https://github.com/zalando/patroni/
--
Sincerely,
Alex
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: [ADMIN] Upgrading postgres to 10 running with patroni
@ 2017-12-01 10:29 Alex Kliukin <alexk@hintbits.com>
parent: Alex Kliukin <alexk@hintbits.com>
0 siblings, 0 replies; 8+ messages in thread
From: Alex Kliukin @ 2017-12-01 10:29 UTC (permalink / raw)
To: Debraj Manna <subharaj.manna@gmail.com>; Magnus Hagander <magnus@hagander.net>; +Cc: pgsql-admin
On Fri, Dec 1, 2017, at 11:17, Alex Kliukin wrote:
> Hello,
>
>
> The last step is definitely wrong. You should not copy
> postmaster.opts, postgresql.base.conf and postgresql.conf. Instead,
> you should configure the postgresql.conf in the PostgreSQL 10 data
> directory to match the parameters of your old cluster. Copying
> pg_hba.conf seems alright, since the one from 9.5 is compatible
> with 10.
Correction: since your configuration files are clearly not in the data directory, but in /etc/... you should edit them (and copy pg_hba.conf) there, not to the data directory.
Sincerely,
Alex
^ permalink raw reply [nested|flat] 8+ messages in thread
end of thread, other threads:[~2017-12-01 10:29 UTC | newest]
Thread overview: 8+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2017-11-16 07:29 Upgrading postgres to 10 running with patroni Debraj Manna <subharaj.manna@gmail.com>
2017-11-16 07:32 ` Debraj Manna <subharaj.manna@gmail.com>
2017-11-16 07:40 ` Magnus Hagander <magnus@hagander.net>
2017-11-16 08:34 ` Debraj Manna <subharaj.manna@gmail.com>
2017-11-16 19:25 ` Debraj Manna <subharaj.manna@gmail.com>
2017-11-17 07:46 ` Debraj Manna <subharaj.manna@gmail.com>
2017-12-01 10:17 ` Alex Kliukin <alexk@hintbits.com>
2017-12-01 10:29 ` Alex Kliukin <alexk@hintbits.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox