Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1eLo8w-0001sP-9M for pgsql-pkg-debian@arkaria.postgresql.org; Mon, 04 Dec 2017 10:38:34 +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 1eLo8v-0008SO-0B for pgsql-pkg-debian@arkaria.postgresql.org; Mon, 04 Dec 2017 10:38:33 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1eLo8u-0008SF-LN for pgsql-pkg-debian@lists.postgresql.org; Mon, 04 Dec 2017 10:38:32 +0000 Received: from mail-wr0-x236.google.com ([2a00:1450:400c:c0c::236]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1eLo8m-00083I-4I for pgsql-pkg-debian@lists.postgresql.org; Mon, 04 Dec 2017 10:38:31 +0000 Received: by mail-wr0-x236.google.com with SMTP id z34so16685782wrz.10 for ; Mon, 04 Dec 2017 02:38:23 -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=3EC6mSWJ6lGeN5SBiazMN55X0QLR9KpApEfM+ix5Wng=; b=Xr9iyULKtRcYwv0FGKai7NSxOHIWeH+7X4suWcWPX+h/szWXg+gcaU63tuk8WUKcUh JMQc7sSQxq0cfrNA1Bc8C+L7+dX3dkhKaxY7FaKFBxXl3RG2PWrxG4lz4c3K1JqI7AsB 2KTeLSB6Jk1sQYbLVNOF9wlohib22QRY8zrWM= 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=3EC6mSWJ6lGeN5SBiazMN55X0QLR9KpApEfM+ix5Wng=; b=V4pkAI9mK4P+6KD/RUUSWzyfoGcPxBZg/xMehqi9t54HDfIfXgopcqLWaiCrLw5+eE 4SQ468KzRmzBY5yOO2nrCIeL2ZSZghI4fPXrecHJY4vrORIl7F5r01q6S/rhPZJesjuW g94g1nN5FsIh/H51TmodxiFS7hyFnz8T7htaPiuvctSeQ5+8hb/CiroK4ZVVC/1thfv7 Q6zcHgda3o+uq174i3sTTofG6wFykGQKNG/00qfP1Z6xdR5O0vTgzxaBKrAaqd2IrkQW Y+rOs+CWRWcQPSiSr7txM8qx23GJIIoA9QnvNgtkiaimxfLLg/Qyg7kkI9ddNpjbtwEM Zrkw== X-Gm-Message-State: AJaThX76+mlmM7wDq/DY5d/E5oPpjOoXePFanPc6qagqW0PqybmQgyjH JUhtHhwavUicxsUlgL1As1hIOGepTaE0Jj7+MXLVoMX8XqBZETGbtOJ29khXPhV3BmtPp4jJesw mQbCbuNoEQm0q8OXNrisbiv7is95GaBAfFOhtLO+EL5FYCy1oe7lDd/ZPMEmNYZgrIT913Erv8W 9i7QfXSp0uLhNlvw664AGOwu8i2ww= X-Google-Smtp-Source: AGs4zMaAB06KfRZtZRGkvYupFnKI/opymG2dbLlEds1p+uXSOIBfxJhOD96okT1dTorJ/uL1xk6Bjg== X-Received: by 10.223.156.133 with SMTP id d5mr13235346wre.43.1512383901354; Mon, 04 Dec 2017 02:38:21 -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 v23sm517603wmh.30.2017.12.04.02.38.20 for (version=TLS1_2 cipher=ECDHE-RSA-AES128-GCM-SHA256 bits=128/128); Mon, 04 Dec 2017 02:38:20 -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> From: Marco Nenciarini Message-ID: <234e635d-47cc-c5a8-6981-93f66dc99fa7@2ndquadrant.it> Date: Mon, 4 Dec 2017 11:38:16 +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: <746b7cd4-fda9-cbfb-5374-ba259b4a35ac@devinfotech.co.uk> Content-Type: multipart/signed; micalg=pgp-sha256; protocol="application/pgp-signature"; boundary="1QbRqEFxWxxFrUUKeU6luBcIkApheCLXG" 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) --1QbRqEFxWxxFrUUKeU6luBcIkApheCLXG Content-Type: multipart/mixed; boundary="9XbgdNKNSqFwqKl0Fp2sFI9uathxiAXbR"; protected-headers="v1" From: Marco Nenciarini To: pgsql-pkg-debian@lists.postgresql.org Message-ID: <234e635d-47cc-c5a8-6981-93f66dc99fa7@2ndquadrant.it> Subject: Re: repmgr 3.x releases in Postgres PPA for Ubuntu Trusty References: <746b7cd4-fda9-cbfb-5374-ba259b4a35ac@devinfotech.co.uk> In-Reply-To: <746b7cd4-fda9-cbfb-5374-ba259b4a35ac@devinfotech.co.uk> --9XbgdNKNSqFwqKl0Fp2sFI9uathxiAXbR Content-Type: text/plain; charset=utf-8 Content-Language: en-US Content-Transfer-Encoding: quoted-printable Il 04/12/17 11:19, Jonathan Heard ha scritto: > Hi Folks, >=20 > =C2=A0 We use Puppet in our environments to be able to quickly roll out= > identical Postgres clusters with repmgr - we've not built one for a > while but had a business need to do so on Friday and the build failed. > The root cause of this is because the Postgres PPA has completely > removed repmgr 3.3.2=C2=A0 for Ubuntu 'Trusty' (14.04) and replaced it = with > repmgr 4.x which is a major release update with breaking changes to bot= h > its configuration files and its schema requirements. >=20 > Is it intentional that the older version has been completely removed? > Version 2.x is still present so it seems to me like it's an oversight > that a 3.x package isn't there. >=20 > This is unfortunately a major headache for me because I cannot simply > upgrade to version 4.0 without updating our Puppet automation and > significant testing. For a consistent environment I'd also need to > upgrade all live databases in order to build just one new one :-( >=20 > I can't even find an old copy for the 3.3.2 package at the moment so I'= m > faced with the prospect of building it from source which could easily > result in a slightly different binary unless I can replicate build > environment and configure options used for the original package. >=20 > Is anyone able to resurrect the 3.x release in the Postgres PPA please?= > I suspect I'm not the only person who's going to be bitten by this :-/ >=20 > Any help would be very much appreciated >=20 Hi Jonathan, you can find the old repmgr packages in http://atalia.postgresql.org/morg= ue/ For convenience 2ndQuadrant has created a repository using the rempgr 3.3.2 packages from the morgue. Beware that these packages will not be updated, and are there only to facilitate the migration to repmgr4. Instructions follows: apt-key adv --fetch-keys http://packages.2ndquadrant.com/repmgr3/apt/0xD3FA41F6.asc echo deb http://packages.2ndquadrant.com/repmgr3/apt/ $(lsb_release -cs)-2ndquadrant main > /etc/apt/sources.list.d/repmgr3.list Regards, Marco --=20 Marco Nenciarini - 2ndQuadrant Italy PostgreSQL Training, Services and Support marco.nenciarini@2ndQuadrant.it | www.2ndQuadrant.it --9XbgdNKNSqFwqKl0Fp2sFI9uathxiAXbR-- --1QbRqEFxWxxFrUUKeU6luBcIkApheCLXG Content-Type: application/pgp-signature; name="signature.asc" Content-Description: OpenPGP digital signature Content-Disposition: attachment; filename="signature.asc" -----BEGIN PGP SIGNATURE----- iQIzBAEBCAAdFiEEfCO4BD5l0pgKIbbiWJ8D8BulUDgFAlolJZsACgkQWJ8D8Bul UDgrbQ//RNgk+rGw7kTySn0Hn55P/8n7o+v+zJBJUVDq64VGcUIgXJwrh+nzbygp FZIS2sf1Z3wbvzXDMU6QnRix22yLB+V8612GsbhGa4kmwSOAL46XBUApVTjkqHeg OMLDPYVR91WrhZHovuoauoKlErPbDu+aYX0tcXuKh0J7kxY9vhZfQYI7WTKLwCuT OBv5F2bGtfvhH0nLmAoUb9PbfcyuPzgwr+C6NgcWLQgtXJajU6dgwM0yOB/YX13K KZrOZ1V2Yh8rWHJBNsgZ3ejI//Gdx7cClZwklHq/SpXW9RnJ0LtXJBqiev1c8hpg XLgUaP6F6ZVgucqq9IVYBLqHpr8fQTVAnl3wZezowo72DqD7z5Q1hgZOKw0i3QzD dU0QetJeeYrye0iR28jQBk7ZUOSb3u0BG/5Lc29KEPcGxR8Qf/mG6EsRVSGKYeX5 bgJfoLEGQWeZ3vOoXz8M4im4/94JVOJ6Q+g5BLuBdWpUifiuMCtCclj4Y4pyKXu5 ngwlClKZB+oyZByNGS/z0GZaSLHPYKqQKIWpfntOuDbyBeEkmFk02Ie8gRDzi1We /T51AQmL9HJlMRdZdEbdGGOouimLDsXdeE+sRJDCApJ8zy3No/4H5ZXgqVsrnIj4 JC6VO4gjgUttrYFSBrdczJbwg0nf8W1m5IFWUy5Z5P0ZWqOCac4= =v3lQ -----END PGP SIGNATURE----- --1QbRqEFxWxxFrUUKeU6luBcIkApheCLXG--