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
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
