Thread: BUG #7822: PGDG packaged postgresql92 binaries do not find their libraries

The following bug has been logged on the website:

Bug reference:      7822
Logged by:          Georgi Georgiev
Email address:      georgi-georgiev-pgsql@japannext.co.jp
PostgreSQL version: 9.2.2
Operating system:   CentOS 6.3
Description:        =


The postgresql92 package would configure the postgresql92-libs libraries for
system-wide use (using update-alternatives in the post-install scriptlet),
but it does not run ldconfig, so the binaries cannot find their libraries.
In short, "psql" is unusable.

Steps to reproduce:

Remove all postgresql libraries:
$ sudo yum remove -y postgresql\*

Install the PGDG 9.2 binaries
$ sudo yum install -y postgresql92

Verify that the psql binary is not properly linked:
$ ldd /usr/bin/psql  | head -n2
        linux-vdso.so.1 =3D>  (0x00007fffb27ff000)
        libpq.so.5 =3D> not found


The ld.so.conf.d update should probably be moved to the postgresql92-libs
packages, as this would allow other packages that require libpq.so.5 to keep
working (like php-pgsql and perl-DBD-Pg).

Hi,

On Tue, 2013-01-22 at 17:08 +0000, georgi-georgiev-pgsql@japannext.co.jp
wrote:
> The following bug has been logged on the website:
>
> Bug reference:      7822
> Logged by:          Georgi Georgiev
> Email address:      georgi-georgiev-pgsql@japannext.co.jp
> PostgreSQL version: 9.2.2
> Operating system:   CentOS 6.3
> Description:
>
> The postgresql92 package would configure the postgresql92-libs libraries for
> system-wide use (using update-alternatives in the post-install scriptlet),
> but it does not run ldconfig, so the binaries cannot find their libraries.
> In short, "psql" is unusable.

There is already an open bug for this:

http://wiki.pgrpms.org/ticket/82

the problem is the wrong place for the creating/removing alternatives
entries for the ld.so.conf file. I fixed it in my local copy, will
commit it in a few days.

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