pg.ddx.io  pgsql-pkg-debian@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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

view thread (6+ messages)  latest in thread

Message-ID: <b68fdeb5-c004-74b6-55a6-2db34cfb9502@2ndquadrant.it>
Permalink:  ../b68fdeb5-c004-74b6-55a6-2db34cfb9502@2ndquadrant.it/
Also on:    postgresql.org/message-id/b68fdeb5-c004-74b6-55a6-2db34cfb9502@2ndquadrant.it

 · 

reply

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