From: Marco Nenciarini <marco.nenciarini@2ndquadrant.it>
To: pgsql-pkg-debian@lists.postgresql.org
Subject: Re: repmgr 3.x releases in Postgres PPA for Ubuntu Trusty
Date: Tue, 5 Dec 2017 16:46:24 +0100
Message-ID: <b68fdeb5-c004-74b6-55a6-2db34cfb9502@2ndquadrant.it> (raw)
In-Reply-To: <55e70e16-ad21-4965-9e3a-70bc1886581c@devinfotech.co.uk>
References: <746b7cd4-fda9-cbfb-5374-ba259b4a35ac@devinfotech.co.uk>
<234e635d-47cc-c5a8-6981-93f66dc99fa7@2ndquadrant.it>
<55e70e16-ad21-4965-9e3a-70bc1886581c@devinfotech.co.uk>
Il 05/12/17 16:30, Jonathan Heard ha scritto:
> Hi Marco,
>
> We've taken the decision to upgrade to repmgr 4.x because sticking
> with the old version is complex and leaves us 'frozen in time' without
> any updates etc..
>
> Unfortunately, I've hit a show-stopped bug in version 4 :-( The repo
> gives us 4.0.0-2.pgdg14.04+2 but the SQL query for 'repmgr cluster show'
> is broken. We don't use the 'repmgr' user and have fallen foul of the
> oversight which is fixed the following commit:
>
> | * commit 3e4a5e6ff5f386391c06aa639fbd8ff6299e1db6
> | | Author: Martín Marqués <martin.marques@2ndquadrant.com>
> | | Date: Wed Nov 22 17:13:58 2017 -0300
> | |
> | | Fix missing FQN for the nodes table.
> | |
> | | This bug was not detected before because most users work with
> the repmgr
> | | user. For that reason, the repmgr schema is already in the
> search_path
> | | by default.
> | |
> | | Add the repmgr schema to the nodes table in the LEFT JOIN used for
> | | cluster show (and in other places)
>
> The above commit is is rolled up into v4.0.1 so do you know when this
> will be released to the PPA please?
>
AFAIK the 4.0.1 release is scheduled for the next week.
Regards,
Marco
--
Marco Nenciarini - 2ndQuadrant Italy
PostgreSQL Training, Services and Support
marco.nenciarini@2ndQuadrant.it | www.2ndQuadrant.it
Attachments:
signature.asc (application/pgp-signature, 832B) download
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-pkg-debian@postgresql.org
Cc: marco.nenciarini@2ndquadrant.it
Subject: Re: repmgr 3.x releases in Postgres PPA for Ubuntu Trusty
In-Reply-To: <b68fdeb5-c004-74b6-55a6-2db34cfb9502@2ndquadrant.it>
References: <746b7cd4-fda9-cbfb-5374-ba259b4a35ac@devinfotech.co.uk> <234e635d-47cc-c5a8-6981-93f66dc99fa7@2ndquadrant.it> <55e70e16-ad21-4965-9e3a-70bc1886581c@devinfotech.co.uk> <b68fdeb5-c004-74b6-55a6-2db34cfb9502@2ndquadrant.it>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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