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