From: Jonathan Heard <jonathan.heard@devinfotech.co.uk>
To: pgsql-pkg-debian@lists.postgresql.org
Subject: Re: repmgr 3.x releases in Postgres PPA for Ubuntu Trusty
Date: Mon, 18 Dec 2017 14:35:02 +0000
Message-ID: <76ad0bb5-2f2a-8f18-a6f0-9d03d13aa8b0@devinfotech.co.uk> (raw)
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>
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 <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
>
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: jonathan.heard@devinfotech.co.uk
Subject: Re: repmgr 3.x releases in Postgres PPA for Ubuntu Trusty
In-Reply-To: <76ad0bb5-2f2a-8f18-a6f0-9d03d13aa8b0@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> <b68fdeb5-c004-74b6-55a6-2db34cfb9502@2ndquadrant.it> <76ad0bb5-2f2a-8f18-a6f0-9d03d13aa8b0@devinfotech.co.uk>
* 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