Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1eMFQf-0002H9-Eo for pgsql-pkg-debian@arkaria.postgresql.org; Tue, 05 Dec 2017 15:46:41 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1eMFQe-0005Hh-9s for pgsql-pkg-debian@arkaria.postgresql.org; Tue, 05 Dec 2017 15:46:40 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1eMFQd-0005HY-MT for pgsql-pkg-debian@lists.postgresql.org; Tue, 05 Dec 2017 15:46:40 +0000 Received: from mail-wm0-x231.google.com ([2a00:1450:400c:c09::231]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1eMFQW-0004No-4I for pgsql-pkg-debian@lists.postgresql.org; Tue, 05 Dec 2017 15:46:38 +0000 Received: by mail-wm0-x231.google.com with SMTP id 9so2110320wme.4 for ; Tue, 05 Dec 2017 07:46:31 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=2ndquadrant.it; s=google; h=subject:to:references:from:message-id:date:user-agent:mime-version :in-reply-to; bh=CfRNWFh1qK3adQOOTbww2c85zz7u+Cuu+arL4Q1pq6g=; b=PnpCeM1Mp0kXLtFfNMise9kNsO8FZM/LntgcVPJWQ3aFVmX39onCxMM5h3R9mHfxoo Edl5v865rh0+16+Otjdn/FJKekdh7slTpSPnpVgAL8c8pHechXDmnMpkXrPqun0BwGq6 qFu+PF+DkZajLvo6Hcko7Nmcm/XQMEWDPSOTM= X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:subject:to:references:from:message-id:date :user-agent:mime-version:in-reply-to; bh=CfRNWFh1qK3adQOOTbww2c85zz7u+Cuu+arL4Q1pq6g=; b=nFb0snj4TN92tXoMOxv92ekxEMxobinBXkVV/8iSQg2gmx18wCgaZYJBuePRMxlejx 7gElps55MKu0eDIFSQ6kipjaXjP0klvzK4rV+H/DqMQUQ8AzSe0K6T+o1KRHHfEquvL3 xjU1zgvrZ1rzC0YmAFHJf5Wk9zPmCvvsb5ThKVfPKHP87/9UlkTKEe6PMMHsyweElCoQ yqNDYq1fwzIpBqsZlea5N8QAzbKvJbku6Z0NuAfSyRCf2+LBRvKy9zfYDQ+X+i3RjvmJ vfeTB8vrn2X0BTNQ+CWZhQ3Vw+HTHLE4M/Q17lEFX5YH1ZqO4bqZXlCzSNDGFegaWooJ zn3A== X-Gm-Message-State: AKGB3mL4eCIEdHg3qVhMTROc1OivaE03qJBhZYi/t1MmR9uimXow8w74 FhXu7isNT5ftZXxrCrgOGoxkn700agVsPu/72rM4sHH+1comQut0veZjxIRoHsPwqmWIJG5ueKr 9oWN+1yKJex/DfOHhwWvtPR0k1F/2uUuldeEPR2ODHmU5jaXQ+yv+zPXDq9m2ffZ8AdIXXXjWSG Et7xsqQtHk3ZCzrHEd4DYXlzOt8jQ= X-Google-Smtp-Source: AGs4zMaPbuOJn6wCf3P+OFp+lP2EqFRErmKuUK7PSzXkeeaa8G4nuE344a663SS6VRll9uDdnxW8TQ== X-Received: by 10.28.133.142 with SMTP id h136mr9338703wmd.122.1512488789164; Tue, 05 Dec 2017 07:46:29 -0800 (PST) Received: from titanium.local (net-37-182-231-222.cust.vodafonedsl.it. [37.182.231.222]) by smtp.googlemail.com with ESMTPSA id a126sm755312wma.11.2017.12.05.07.46.28 for (version=TLS1_2 cipher=ECDHE-RSA-AES128-GCM-SHA256 bits=128/128); Tue, 05 Dec 2017 07:46:28 -0800 (PST) Subject: Re: repmgr 3.x releases in Postgres PPA for Ubuntu Trusty To: pgsql-pkg-debian@lists.postgresql.org References: <746b7cd4-fda9-cbfb-5374-ba259b4a35ac@devinfotech.co.uk> <234e635d-47cc-c5a8-6981-93f66dc99fa7@2ndquadrant.it> <55e70e16-ad21-4965-9e3a-70bc1886581c@devinfotech.co.uk> From: Marco Nenciarini Message-ID: Date: Tue, 5 Dec 2017 16:46:24 +0100 User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.13; rv:52.0) Gecko/20100101 Thunderbird/52.5.0 MIME-Version: 1.0 In-Reply-To: <55e70e16-ad21-4965-9e3a-70bc1886581c@devinfotech.co.uk> Content-Type: multipart/signed; micalg=pgp-sha256; protocol="application/pgp-signature"; boundary="6VlKHXvTUs5BtR6eHKiC4fO31De4vu1Ub" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk This is an OpenPGP/MIME signed message (RFC 4880 and 3156) --6VlKHXvTUs5BtR6eHKiC4fO31De4vu1Ub Content-Type: multipart/mixed; boundary="1mlBCECJWhqctrHDbw0okP7c8jxBKKTc0"; protected-headers="v1" From: Marco Nenciarini To: pgsql-pkg-debian@lists.postgresql.org Message-ID: Subject: Re: repmgr 3.x releases in Postgres PPA for Ubuntu Trusty References: <746b7cd4-fda9-cbfb-5374-ba259b4a35ac@devinfotech.co.uk> <234e635d-47cc-c5a8-6981-93f66dc99fa7@2ndquadrant.it> <55e70e16-ad21-4965-9e3a-70bc1886581c@devinfotech.co.uk> In-Reply-To: <55e70e16-ad21-4965-9e3a-70bc1886581c@devinfotech.co.uk> --1mlBCECJWhqctrHDbw0okP7c8jxBKKTc0 Content-Type: text/plain; charset=utf-8 Content-Language: en-US Content-Transfer-Encoding: quoted-printable Il 05/12/17 16:30, Jonathan Heard ha scritto: > Hi Marco, >=20 > =C2=A0=C2=A0 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.. >=20 > Unfortunately, I've hit a show-stopped bug in version 4 :-(=C2=A0=C2=A0= 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: >=20 > | * commit 3e4a5e6ff5f386391c06aa639fbd8ff6299e1db6 > | | Author: Mart=C3=ADn Marqu=C3=A9s > | | Date:=C2=A0=C2=A0 Wed Nov 22 17:13:58 2017 -0300 > | | > | |=C2=A0=C2=A0=C2=A0=C2=A0 Fix missing FQN for the nodes table. > | | > | |=C2=A0=C2=A0=C2=A0=C2=A0 This bug was not detected before because mo= st users work with > the repmgr > | |=C2=A0=C2=A0=C2=A0=C2=A0 user. For that reason, the repmgr schema is= already in the > search_path > | |=C2=A0=C2=A0=C2=A0=C2=A0 by default. > | | > | |=C2=A0=C2=A0=C2=A0=C2=A0 Add the repmgr schema to the nodes table in= the LEFT JOIN used for > | |=C2=A0=C2=A0=C2=A0=C2=A0 cluster show (and in other places) >=20 > The above commit is is rolled up into v4.0.1 so do you know when this > will be released to the PPA please? >=20 AFAIK the 4.0.1 release is scheduled for the next week. Regards, Marco --=20 Marco Nenciarini - 2ndQuadrant Italy PostgreSQL Training, Services and Support marco.nenciarini@2ndQuadrant.it | www.2ndQuadrant.it --1mlBCECJWhqctrHDbw0okP7c8jxBKKTc0-- --6VlKHXvTUs5BtR6eHKiC4fO31De4vu1Ub Content-Type: application/pgp-signature; name="signature.asc" Content-Description: OpenPGP digital signature Content-Disposition: attachment; filename="signature.asc" -----BEGIN PGP SIGNATURE----- iQIzBAEBCAAdFiEEfCO4BD5l0pgKIbbiWJ8D8BulUDgFAlomv1AACgkQWJ8D8Bul UDi+fw/6AzMJtYC546sqUyLWHGg+m0lf6r7HGwH6/t3y/iHiQWYc8zv0TVnS9hjG WLBOOJQg9sdgO3vM4LNO9VsjkzzJxKkRdRxnwBAGUcxkFM20uLB4O3bcBUSvXec9 2++nWdvPoYa1GnL754kGFxj8QV43Nsxv7UoDNfdf/IWzbsW6uC3gK3Jo6S/1Wo5t Lat39z63POd/JiN5uGF1NM8tk/ODsNi6jBjXxl81VGmU1Sd2SMptm4gVaEEEaXQe qyTI1DD2nCdaUCdLqZuLF2tGlBMRHtd46+Rw0FBmp+OfVAvuNvgglrev123cNmEB odq5/TswTE13qWRCoIMOPAlFBFpgh/paeM7nakxTMJKv/Ele/h06C8ELFxhCh9Mz FDiasJ85r+u3NE6XbW0e1KvACP2XjFwOF8/FNItJ+lH7hjMTOaJGBrr1S8iRm98f ANO8UsFJE3QjDEmGZK3KX2Pk1JwNfAf7sYJdBGy2Gqj1djb4gEd9D32dWwdb6pW8 xLB6LtSPSMXlaAKBg8yx7bZMNSrR6cAauBy7lGeZo28Lu9FwwfZOAr4ps4g+QG6x arkDSyVQd0Vmd6T6b2GYmQXy1aWbp7BJjV2wLOci/GKw1mBwgI4YjSMi3ihE4gZU NsECqd9h+m/NkKazYTmJmFGNpD/fgYBmScD1bZGoFy69ZKgqAqw= =BkaA -----END PGP SIGNATURE----- --6VlKHXvTUs5BtR6eHKiC4fO31De4vu1Ub--