Re: yum repository packages 9.0 and 9.1 libpq conflict

On 03/14/12 11:40 PM, Devrim GÜNDÜZ wrote:
> I have created a ticket for that, but could not close yet. You can see
> the progress from here:
>
> http://wiki.pgrpms.org/ticket/77

I don't see anything but the ticket itself?

anyways, I'm quite sure this is the problem...

# cat /etc/ld.so.conf.d/postgresql-9.0-libs.conf
/usr/pgsql-9.0/lib/

# cat /etc/ld.so.conf.d/postgresql-9.1-libs.conf
/usr/pgsql-9.1/lib/

I'm pretty sure that removing the ld.so.conf.d files will fix this.
I'm setting up a test in a spare VM now.

k, stock centos 6.2 with 9.0.7...

$ rpm -qa |grep postgres
postgresql90-libs-9.0.7-1PGDG.rhel6.x86_64
postgresql90-server-9.0.7-1PGDG.rhel6.x86_64
postgresql90-9.0.7-1PGDG.rhel6.x86_64
postgresql90-contrib-9.0.7-1PGDG.rhel6.x86_64
postgresql90-devel-9.0.7-1PGDG.rhel6.x86_64

$ ldd /usr/pgsql-9.0/bin/psql | grep libpq
libpq.so.5 => /usr/pgsql-9.0/lib/libpq.so.5 (0x00007f340f956000)

so... I install 9.1 ...

# rpm -ivh
http://yum.postgresql.org/9.1/redhat/rhel-6-x86_64/pgdg-centos91-9.1-4.noarch.rpm
Retrieving
http://yum.postgresql.org/9.1/redhat/rhel-6-x86_64/pgdg-centos91-9.1-4.noarch.rpm
Preparing... ###########################################
[100%]
1:pgdg-centos91 ###########################################
[100%]

# yum install postgresql91{-server,-contrib}
....
Installing : postgresql91-libs-9.1.3-1PGDG.rhel6.x86_64 1/4
Installing : postgresql91-9.1.3-1PGDG.rhel6.x86_64 2/4
Installing : postgresql91-server-9.1.3-1PGDG.rhel6.x86_64 3/4
Installing : postgresql91-contrib-9.1.3-1PGDG.rhel6.x86_64 4/4

Installed:
postgresql91-contrib.x86_64 0:9.1.3-1PGDG.rhel6
postgresql91-server.x86_64 0:9.1.3-1PGDG.rhel6

Dependency Installed:
postgresql91.x86_64 0:9.1.3-1PGDG.rhel6
postgresql91-libs.x86_64 0:9.1.3-1PGDG.rhel6

Complete!

and....

# /usr/pgsql-9.1/bin/psql
psql: invalid connection option "client_encoding"

# ldd /usr/pgsql-9.1/bin/psql |grep libpq
libpq.so.5 => /usr/pgsql-9.0/lib/libpq.so.5 (0x00007f989aa20000)

oooops! whats 9.0 doing here??

k, so thats the problem.

so... I got evil. I mv'd /etc/ld.so.conf.d/postgres*.conf to backup.

# ldd /usr/pgsql-9.1/bin/psql |grep libpq
libpq.so.5 => not found

uh oh. that means they weren't linked with -R or -rpath
/usr/pgsql-9.1/lib, which they should have been if --prefix
/usr/pgsql-9.1 was used....

OH.

CONFIGURE = '--disable-rpath' '--prefix=/usr/pgsql-9.1' .....

muh oh. why is that?!?

--
john r pierce N 37, W 122
santa cruz ca mid-left coast