Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1eQwVf-00061g-GN for pgsql-pkg-debian@arkaria.postgresql.org; Mon, 18 Dec 2017 14:35:15 +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 1eQwVe-0003ys-JB for pgsql-pkg-debian@arkaria.postgresql.org; Mon, 18 Dec 2017 14:35:14 +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 1eQwVe-0003xo-06 for pgsql-pkg-debian@lists.postgresql.org; Mon, 18 Dec 2017 14:35:14 +0000 Received: from mail-eopbgr50040.outbound.protection.outlook.com ([40.107.5.40] helo=EUR03-VE1-obe.outbound.protection.outlook.com) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1eQwVZ-00012M-B8 for pgsql-pkg-debian@lists.postgresql.org; Mon, 18 Dec 2017 14:35:12 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=MetInfoTech.onmicrosoft.com; s=selector1-devinfotech-co-uk; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version; bh=3e+NRK0xQUYJRopW7r5ti2X2wiojtnwsrt4HoQG07nE=; b=VVv5Y0KQywR+5PayFH2tX3wbSLcCgTBvqOSUX07jsuKKqDx3dALknFUyBR1W62FCkfYfPdS+/XnQERYT73x3bFL6iK+acyYqeX9zU8NtIu7PvXd3gXD3C9KKJ4pZyks8bbPyBKWA8NnMXlcPew4ZH/niqbEMhUY1cffXeOiucwc= Authentication-Results: spf=none (sender IP is ) smtp.mailfrom=jonathan.heard@devinfotech.co.uk; Received: from [172.16.32.255] (81.145.238.131) by HE1PR0101MB2474.eurprd01.prod.exchangelabs.com (2603:10a6:3:7d::11) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_CBC_SHA384_P256) id 15.20.302.9; Mon, 18 Dec 2017 14:35:05 +0000 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: Jonathan Heard Message-ID: <76ad0bb5-2f2a-8f18-a6f0-9d03d13aa8b0@devinfotech.co.uk> Date: Mon, 18 Dec 2017 14:35:02 +0000 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:52.0) Gecko/20100101 Thunderbird/52.5.0 MIME-Version: 1.0 In-Reply-To: Content-Type: text/plain; charset=utf-8; format=flowed Content-Transfer-Encoding: 8bit Content-Language: en-US X-Originating-IP: [81.145.238.131] X-ClientProxiedBy: CWLP265CA0050.GBRP265.PROD.OUTLOOK.COM (2603:10a6:401:12::14) To HE1PR0101MB2474.eurprd01.prod.exchangelabs.com (2603:10a6:3:7d::11) X-MS-PublicTrafficType: Email X-MS-Office365-Filtering-Correlation-Id: 0e4abf8b-0850-45ec-fbf1-08d546248806 X-Microsoft-Antispam: UriScan:;BCL:0;PCL:0;RULEID:(5600026)(4604075)(4534020)(4602075)(4627115)(201703031133081)(201702281549075)(2017052603307);SRVR:HE1PR0101MB2474; X-Microsoft-Exchange-Diagnostics: 1;HE1PR0101MB2474;3:Wzpj+6/FKbX5Q8/C3l+ImeiMFbIR9lHBxA9xNj8BUH4XZnjVYrc5OkFQHSj4EpkNnxcrSBGEbBmXnJbF214E3213K5fBKwGARK78X36/E5kDBoN49TTvYO3iJxkL0QReyuC4v7Qc25SIAwar9smDgC8lL4mXgpovdv1Z53UpN896xFQzmrOpns9ZcPE4znXkhDfb4iOATaU6rvSRLXZBpAEdUbqMCviMx8elaQWNL04gtvm2j9RKrnaZOgCfILQo;25:DHm0wMfRX4/FJcnECEUu+vwSBQFGvw+9Sgaxvsm18Wokw8wEmzJbe+42QkG8Qf9VliT8/mhcXaA7vjlkXQyQiyMimeNqeAq6klySUx4TlB77aL5UIS8l6//usY5KRHqcZDApmeD+lyd00rl/m4o9s9cVbV54e3zxuG1JGzKUq97TPcyiMLdAyWAdGIn3sMlJXrTUTI/sDdxK8GGqR9F1P768WRkvBJnjMNJ6mhMPGFfaZlcVf0BPidmntSFn10LyTBlznd+RUj2HGQxIb9hf7DaggtzfCYE6hdoDI4z79BfBHuGVOwjiJQZ3j8IZPFv7JEobMbZ6k/ThVbG19Pk2yQ==;31:9fu/qWyjFBm1ydTy4pOgopsIJkF7M7XyN5rqD7GSVSZWopcrGnS7zGFW1+U0K6NdW/McXBl3NAbNLY4DTytXf5juJf3+Mi0RNCI5G82ve7kndANYRZ0oby7Z5Wbh/J9eV0f2Zn3t7ayNhtvOjhScKm9rcYlUpILcbS+OoqrZ6mulUGdKCN+sxcNeVjqanrkBzdZQhzfwMBmc2dYEijeLrOce4Jyu6DA5o7Z6zX9kOUg= X-MS-TrafficTypeDiagnostic: HE1PR0101MB2474: X-Microsoft-Antispam-PRVS: X-Exchange-Antispam-Report-Test: UriScan:; X-Exchange-Antispam-Report-CFA-Test: BCL:0;PCL:0;RULEID:(6040450)(2401047)(5005006)(8121501046)(93006095)(93001095)(3002001)(3231023)(10201501046)(6041248)(20161123555025)(20161123564025)(20161123562025)(20161123560025)(201703131423075)(201702281528075)(201703061421075)(201703061406153)(20161123558100)(6072148)(201708071742011);SRVR:HE1PR0101MB2474;BCL:0;PCL:0;RULEID:(100000803101)(100110400095);SRVR:HE1PR0101MB2474; X-Microsoft-Exchange-Diagnostics: 1;HE1PR0101MB2474;4:EQqH1NKXNqnTcQlgidphUds3DXs/jcEu0B1/I3CqM591H4ij35dQwRpnD5i7J0ONV5UYXd4KUqhjouCrS1ybZyGX1YE3Y2uZuctSSH168qZC7H3DiSsYhJWcBxOX3mUjm+hUVmb0zO7sU7VJw34/0u86NOpiW1beQBzb8nBarwV5+GOXYCJDa7soVYjdDnBsAy4XuC0kKkroUzCY7hqZhJ6Fkn61F8hkKPEVCLQTkH0RdTk1QtpUc6APBnPvHBgGUG6I67vzRyTlP/0fD82pUg== X-Forefront-PRVS: 0525BB0ADF X-Forefront-Antispam-Report: SFV:NSPM;SFS:(10009020)(6049001)(376002)(366004)(39840400004)(396003)(346002)(199004)(69234005)(189003)(24454002)(8936002)(6666003)(53546011)(6246003)(52146003)(65956001)(97736004)(316002)(105586002)(65826007)(25786009)(2950100002)(42882006)(31686004)(58126008)(106356001)(2486003)(16576012)(77096006)(229853002)(23676004)(31696002)(86362001)(6916009)(386003)(93886005)(52116002)(6486002)(5660300001)(64126003)(66066001)(2870700001)(76176011)(83506002)(47776003)(67846002)(2906002)(478600001)(50466002)(3846002)(305945005)(59450400001)(7736002)(65806001)(8676002)(2351001)(6116002)(81166006)(16526018)(81156014)(74482002)(53936002)(36756003)(68736007)(2361001);DIR:OUT;SFP:1101;SCL:1;SRVR:HE1PR0101MB2474;H:[172.16.32.255];FPR:;SPF:None;PTR:InfoNoRecords;A:0;MX:1;LANG:en; Received-SPF: None (protection.outlook.com: devinfotech.co.uk does not designate permitted sender hosts) X-Microsoft-Exchange-Diagnostics: =?utf-8?B?MTtIRTFQUjAxMDFNQjI0NzQ7MjM6aXBKLy9WYXZLSnFlMk1sRXA0WjV0ZDhF?= =?utf-8?B?eEE1YUJHdE5NTG0xNTYvZXZZeUV0TytWbzMrRXpXTDg3ZldzOXR5U1I2QTY3?= =?utf-8?B?QnBnSkNaNStZaWF4UlVxa25WRVF1VFBQbFM5bm5QbEJyeGhValNPUjFvL1c3?= =?utf-8?B?N0h4VlloQTJvQ3V5UjlyUy85WTV0SHkwMk5ncmp0NjdwTEliTmg3TFRzdC93?= =?utf-8?B?WkdYTkloN0ppblFibjFOMk5FclpZV1plTFdGdkFQZElXL25EczI5UW5WZVVn?= =?utf-8?B?ZXV5cUp2eTUwRVl1L1pNM2oxblVQK3ZtRytUREtkTCswUm1lTkdYdE12RDhR?= =?utf-8?B?WHRRYUR4M0ljdDl3NmdqOFhQekVFdGFDMDJML3lGZ3JyNVhYVm5sZzFuREJI?= =?utf-8?B?MWN1YWNJUjI3azlSK0FzcDdycDU1RVF2dHByWU9zZ01RN3pBMEpqWlBxUVp1?= =?utf-8?B?MlI2UXh0UWhmbUtxckhXTmM0OVdPOEdhb1BwdG1FTEw3eVpKNW9qUHArV2tr?= =?utf-8?B?bUdEVVFodE1TTmwxN3ZzaE54V2ZDRjZXSHRoTlBwNHNXUTJkaE1SbE9ZTE9w?= =?utf-8?B?KzB3U1UwaXp5U0pSeWhWV2QzVlZ6OU1iQ2YzVGYrZjVMYk5BbDdISnJsTEta?= =?utf-8?B?Ni8xNStlbU8wRDkrY1hieTd2OFJveVcrbzVTcWZnOXB3RU5oUlYyYlM4Q2tk?= =?utf-8?B?S1FNblo4WFhIa3UyL0IyZWR4QlpQck5jS2ZHVnV5UGdYNTF5QW1LeVNwcVd4?= =?utf-8?B?K2FMbStpZmJJbUxmREFCaHdHZms2QUI0N3JUWCtYcGxLSGVMVkZPTWhKNGJ0?= =?utf-8?B?N2pPa0pkeTM3aERIaUwyTmY3dnZCb1dZVndKb2xxR2dSRFROajVBT2REZDM3?= =?utf-8?B?UmwwcE9jNXlvR0RJbHk1WTlvdmJiOWZlM0Z2Um5FSTVRWDVVNW5KYTRNMWtj?= =?utf-8?B?TlU1QnB5TnJnUjRMVjk3UStvbW83TENQa2ZzZzBzSEt5dlM3YTFrNDdQcnZM?= =?utf-8?B?Y3FyL3FhTXMxUzJSTHg4RlA2RTBmUWZMaU1iL2NxUlhuaHJpWUdzdnRsVWpF?= =?utf-8?B?WEo3V0J5QjJsU3FSU3JQUmdySC9PSjYrTU9xbytDbTVzSnFpS2QwcVZ2cjli?= =?utf-8?B?ODhQZjV3K2grTzhOY21mQjRrYkJ1SHNxbG5JbFk2bmljMHdjbENqRFdRcWo0?= =?utf-8?B?Q05Jbms4SUJsZ3I1azUrWUhjTHhDQUUvOXpOLzhjNG03MHpHQjlqc0NVTG14?= =?utf-8?B?LzRRaFdkckVZcXNzS1RpaHBhdWR4eStlQTkvMnBwait6MzY1bnlQNWxaYnV5?= =?utf-8?B?cEkxL21RSGQwd3FvcGZVakt6MkxnbjdTdUs0VlNoOEFxZlY4dUhnWVR0RFh6?= =?utf-8?B?ZUFha0tyTHpKUlBuNVNQajNsT1grUE5YeFlBRDZseXhnbDQwRHloM3V0R0Nt?= =?utf-8?B?Vm5uZ25FU01kNHN6L0V4Q1NSS0hEeFhhdk9BYlZUNmxORWt1ZUk3SzFNWGxX?= =?utf-8?B?TlZ3OVFiWW9rbURMb1lsbzFYdWs5R1lsdU9aK3JCM0FmaldoTUhSYmxlK0x5?= =?utf-8?B?NHdDcm9abVcvWGo0bmZnSitQY1ZDb2xCdDdVUEJ6bE1nS0NWZHJlSWJlZUZU?= =?utf-8?B?V1JLallsTUhQNlJzbnlwSElHT0NTM0pnQkxweUJmdGtMZWpIdE4vbUxoclNn?= =?utf-8?B?ZHdwL0laTWpFRlY4UE5yVDcrZkI4MWxTVGtVNHFGVS8yeFc5QXhBcEFJWmtS?= =?utf-8?B?RUliRFY0RlBrT1ZjemZWaCtrNXk1WE4zclVJcW5DcW16Ym5IWWxFUHd6ZEtX?= =?utf-8?B?aWwzZGFVcDFFR0VlUGdySTdZVklTRENOcTEzZCtjaFNueGhCbHJxWlNmOVZt?= =?utf-8?B?L2xIZElzaWFwZjZmTUROMXh4Q1Q1TUZiZFlib25OSHUvREFNNFJzT1ZFOU1u?= =?utf-8?B?NTRITDZEK2xCRVF1QkNDRG1mdVh4cmtsNlVmV2gxdHRab202K3N1YzFNaFZt?= =?utf-8?B?cUJZYzB5UjE2NGQwSzZRdFdkWW1VaDhjMVdWd2R3PT0=?= X-Microsoft-Exchange-Diagnostics: 1;HE1PR0101MB2474;6:kNjmJrkZKooBpjtoTaOdDHXHUsnmMB5XuFRlwLSlAoaNlIG35Ed9L+rOZq2NU8D6a87srFw4LYSCLz+RwetxVdrXMJ9ok6h3CDO0woi0sfmbx+ytMeGKvwTuGy9gHgK4EJhsP+MlJD4e0v8ZaaxLhF1fRihhVd7/sjFxCS7v4h5sIQ1vsyEhvJNDujILFR6AEuKDiK4HzGK+21d6FwW6w/fdKGzSHXD+PsDZsf1sAaaQnw91oYrn+jWJVOiLNj4nY6i2bgTeD6umwNTIHGC01w7mdo1CRViSThHOwx5XHnok0G34Fa9tebfGPZeyilH/NsLC1ucf6c7Fx+w+Yx0KmpFzKgfoVitvw1cBsXFv2X8=;5:Q+YnuHRuxuHxD8n0c6oeFdy3qH9kMNL8pwQXEGOBmL/zvlNu9JW9A4HiHNTYrrFB9sWxPNENdTzjnJlDRPCo5ta6XlxK5jDUAjTaONSard6RFAGlydIhB74BgqNVxwBvwmTaObLBiNaLLB+JfRiNbRq6jCroiYItEDokwqsv4m0=;24:Va+PA8+Fqoqm4IrgN0jSHWA8GVDagnErpn/Fkk7efM4qL4dZhzuAbxvfPt0NMw4IQhP37yx0o2NL3MWBFeife7JvBJvbOl4SXOWzS7C4eYc=;7:Qm/C/hl6alxjmI3TW53GPaePYyRS16imwlNtfoituFYscfB1nsNB/q2H88VAyiv+7w0PmQA7kz2p3L17Eay3qq1KeP+RmJi7nSqKe56o+vxUzxXxUEozQq032sCRKLMVwukldgYDwEJRuJFQ3VWMYn6+KUGW3UyFYi2ZHR72oSgYtFiJPYU2cuwQ7T8dtrBbI7KkT+0Hj1RsS89o5FIVRjOXXrnFxx/Q/ydz2ZDjMHjxCG3iHAtA6LPRYsMHb2Yd SpamDiagnosticOutput: 1:99 SpamDiagnosticMetadata: NSPM X-OriginatorOrg: devinfotech.co.uk X-MS-Exchange-CrossTenant-OriginalArrivalTime: 18 Dec 2017 14:35:05.6313 (UTC) X-MS-Exchange-CrossTenant-Network-Message-Id: 0e4abf8b-0850-45ec-fbf1-08d546248806 X-MS-Exchange-CrossTenant-FromEntityHeader: Hosted X-MS-Exchange-CrossTenant-Id: 84638ef3-8527-4d05-81be-3e5e20e93bdf X-MS-Exchange-Transport-CrossTenantHeadersStamped: HE1PR0101MB2474 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk Hi Marco,   Just FYI there appears to be a bug in the package's scripts as per the below output. If I manually delete the dead symlink at '/etc/rc2.d/S20repmgrd' then it upgrades from 4.0.0 to 4.0.1 without any errors. Thanks Jonathan # apt-get install postgresql-9.5-repmgr Reading package lists... Done Building dependency tree Reading state information... Done postgresql-9.5-repmgr is already the newest version. The following packages will be upgraded:   repmgr-common 1 upgraded, 0 newly installed, 0 to remove and 69 not upgraded. 2 not fully installed or removed. Need to get 0 B/87.1 kB of archives. After this operation, 4,096 B of additional disk space will be used. (Reading database ... 40843 files and directories currently installed.) Preparing to unpack .../repmgr-common_4.0.1-1.pgdg14.04+1_all.deb ... invoke-rc.d: dangling symlink: /etc/rc2.d/S20repmgrd dpkg: warning: subprocess old pre-removal script returned error exit status 102 dpkg: trying script from the new package instead ... invoke-rc.d: dangling symlink: /etc/rc2.d/S20repmgrd dpkg: error processing archive /var/cache/apt/archives/repmgr-common_4.0.1-1.pgdg14.04+1_all.deb (--unpack):  subprocess new pre-removal script returned error exit status 102 invoke-rc.d: dangling symlink: /etc/rc2.d/S20repmgrd dpkg: error while cleaning up:  subprocess installed post-installation script returned error exit status 102 Errors were encountered while processing:  /var/cache/apt/archives/repmgr-common_4.0.1-1.pgdg14.04+1_all.deb E: Sub-process /usr/bin/dpkg returned an error code (1) On 05/12/17 15:46, Marco Nenciarini wrote: > 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 >> | | 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 >