Re: [BUGS] BUG #7823: PGDG packaged pgadmin3_92 removes its /usr/bin/pgadmin3 link
Quoting Georgi Georgiev at 03/02/2013-13:36:54(+0900): ... By the way, I see that the postgresql92 packages do the update-alternatives cleanup in %postun. I am not sure why pgadmin3_92 does it in %preun, nor does it seem to make much of a difference, but it may be a good idea to consistently do it in the same scriptlet - either %preun or %postun. Just to follow up that pgadmin3_92-1.16.1-4.rhel6.x86_64 has a new problem now. This version creates (and installs) only a pgadmin3 binary. There is no mention of pgadmin3_92 anymore. However, the .desktop file is still pointing to /usr/bin/pgadmin3_92 (which is now missing). -- \Georgi Georgiev \ If you fail to plan, plan to fail. \ / Sysadmin Head/ / \-SBI Japannext- \ \ -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
Re: [BUGS] BUG #7823: PGDG packaged pgadmin3_92 removes its /usr/bin/pgadmin3 link
Quoting Georgi Georgiev at 03/02/2013-13:19:52(+0900): Quoting Georgi Georgiev at 24/01/2013-12:55:31(+0900): Quoting Devrim GÜNDÜZ at 23/01/2013-21:11:09(+0200): ... Should be fixed with 1.16.1-2. Please check. Thanks for the quick turnaround. But there seems to be a typo now, so the %post is not working: 1.16.1-3 does not throw errors, but it still reliably wipes out the symlink on an upgrade. A fresh install or a reinstall would create the symlink, but that is only because the %preun does not run in that case (there is no old version to uninstall in this case). This can be fixed with a 'if [ $1 = 0 ]; then' in the %preun. To test all these cases, I used rpmrebuild to create different releases of this package. I made a -2.5 which is identical to -3. And I made a -2.8 with the %preun modified like this: $ rpm -q pgadmin3_92-1.16.1-2.8.rhel6.x86_64 --scripts postinstall scriptlet (using /bin/sh): /usr/sbin/update-alternatives --install /usr/bin/pgadmin3 pgadmin3 /usr/pgsql-9.2/bin/pgadmin3 920 preuninstall scriptlet (using /bin/sh): if [ $1 = 0 ]; then /usr/sbin/update-alternatives --remove pgadmin3 /usr/pgsql-9.2/bin/pgadmin3 fi Test results: - Upgrade from 2.5 - symlink missing (wrong) - Upgrade from 2.8 - symlink present (correct) - Fresh install of any version - symlink present (correct) - Uninstall any version - symlink missing (correct) So, please, if you can fix the %preun as above, that should solve all pending issues. By the way, I see that the postgresql92 packages do the update-alternatives cleanup in %postun. I am not sure why pgadmin3_92 does it in %preun, nor does it seem to make much of a difference, but it may be a good idea to consistently do it in the same scriptlet - either %preun or %postun. -- (Georgi Georgiev ( Despite all appearances, your boss is a( )Sysadmin Head ) thinking, feeling, human being. ) (-SBI Japannext- ( ( -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
Re: [BUGS] BUG #7823: PGDG packaged pgadmin3_92 removes its /usr/bin/pgadmin3 link
Quoting Devrim GÜNDÜZ at 23/01/2013-21:11:09(+0200): Hi, On Tue, 2013-01-22 at 17:13 +, georgi-georgiev-pg...@japannext.co.jp wrote: The following bug has been logged on the website: Bug reference: 7823 Logged by: Georgi Georgiev Email address: georgi-georgiev-pg...@japannext.co.jp PostgreSQL version: 9.2.2 Operating system: CentOS 6.3 Description: Updating pgadmin3_92 removes the /usr/bin/pgadmin3 symlink. There is also a harmless warning from the post-install scriptlet when it tries to create that symlink and it is already there (happens on an update). Should be fixed with 1.16.1-2. Please check. Thanks for the quick turnaround. But there seems to be a typo now, so the %post is not working: $ sudo yum update pgadmin3_92 Running Transaction Updating : pgadmin3_92-1.16.1-2.rhel6.x86_641/2 Non-fatal POSTIN scriptlet failure in rpm package pgadmin3_92-1.16.1-2.rhel6.x86_64 /var/tmp/rpm-tmp.uHi9h7: line 1: {_sbindir}/update-alternatives: No such file or directory warning: %post(pgadmin3_92-1.16.1-2.rhel6.x86_64) scriptlet failed, exit status 127 ... $ rpm -q pgadmin3_92 --scripts postinstall scriptlet (using /bin/sh): {_sbindir}/update-alternatives --install /usr/bin/pgadmin3 pgadmin3 /usr/pgsql-9.2/bin/pgadmin3 920 preuninstall scriptlet (using /bin/sh): /usr/sbin/update-alternatives --remove pgadmin3 /usr/pgsql-9.2/bin/pgadmin3 -- / Georgi Georgiev/ I go on working for the same reason a hen / \ Sysadmin Head\ goes on laying eggs. -- H.L. Mencken \ / -SBI Japannext-/ / -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
Re: [BUGS] BUG #7823: PGDG packaged pgadmin3_92 removes its /usr/bin/pgadmin3 link
Hi, On Tue, 2013-01-22 at 17:13 +, georgi-georgiev-pg...@japannext.co.jp wrote: The following bug has been logged on the website: Bug reference: 7823 Logged by: Georgi Georgiev Email address: georgi-georgiev-pg...@japannext.co.jp PostgreSQL version: 9.2.2 Operating system: CentOS 6.3 Description: Updating pgadmin3_92 removes the /usr/bin/pgadmin3 symlink. There is also a harmless warning from the post-install scriptlet when it tries to create that symlink and it is already there (happens on an update). Should be fixed with 1.16.1-2. Please check. Regards, -- Devrim GÜNDÜZ Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr http://www.gunduz.org Twitter: http://twitter.com/devrimgunduz signature.asc Description: This is a digitally signed message part
[BUGS] BUG #7823: PGDG packaged pgadmin3_92 removes its /usr/bin/pgadmin3 link
The following bug has been logged on the website: Bug reference: 7823 Logged by: Georgi Georgiev Email address: georgi-georgiev-pg...@japannext.co.jp PostgreSQL version: 9.2.2 Operating system: CentOS 6.3 Description: Updating pgadmin3_92 removes the /usr/bin/pgadmin3 symlink. There is also a harmless warning from the post-install scriptlet when it tries to create that symlink and it is already there (happens on an update). Running Transaction Updating : pgadmin3_92-1.16.1-1.rhel6.x86_64 1/2 Non-fatal POSTIN scriptlet failure in rpm package pgadmin3_92-1.16.1-1.rhel6.x86_64 ln: creating symbolic link `/usr/bin/pgadmin3': File exists warning: %post(pgadmin3_92-1.16.1-1.rhel6.x86_64) scriptlet failed, exit status 1 Cleanup: pgadmin3_92-1.16.0-1.rhel6.x86_64 2/2 And after this /usr/bin/pgadmin3 is gone. -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs