Re: EnterpriseDB install of Postgres on Ubuntu 10.04 library path issues - no version information available (required by /lib/libblkid.so.1)

Thanks! That worked great.

On Wed, Apr 4, 2012 at 11:39 PM, Ashesh Vashi
<ashesh.vashi@enterprisedb.com> wrote:
> On Thu, Apr 5, 2012 at 4:11 AM, Scott Chapman <scott@mischko.com> wrote:
>>
>> Downloaded
>> http://get.enterprisedb.com/postgresql/postgresql-9.1.3-1-linux.run
>> Ran it.  Install went fine.
>> StackBuilder install of PostGIS 1.5 failed.  No error given.  I can't
>> find it in the logs. So I ran /tmp/edb_postgis_1_5_pg91.bin by hand.
>> Everything went fine there.
>>
>> Then I wanted to install psycopg2 (2.4.5) so I can use PG with Python:
>>
>> $ python setup.py build
>> running build
>> running build_py
>> running build_ext
>> Error: pg_config executable not found.
>>
>> Please add the directory containing pg_config to the PATH
>> or specify the full executable path with the option:
>>
>>    python setup.py build_ext --pg-config /path/to/pg_config build ...
>>
>> or with the pg_config option in 'setup.cfg'.
>>
>> $ export PATH=$PATH:/opt/PostgreSQL/9.1/bin/
>>
>> Then the build worked fine.
>>
>> # export PATH=$PATH:/opt/PostgreSQL/9.1/bin/
>> # python setup.py install
>>
>> That worked.
>>
>> Then try to import it in Python:
>>
>> $ python
>> Python 2.6.5 (r265:79063, Apr 16 2010, 13:09:56)
>> [GCC 4.4.3] on linux2
>> Type "help", "copyright", "credits" or "license" for more information.
>> >>> import psycopg2
>> Traceback (most recent call last):
>>  File "<stdin>", line 1, in <module>
>>  File "/usr/local/lib/python2.6/dist-packages/psycopg2/__init__.py",
>> line 67, in <module>
>>    from psycopg2._psycopg import BINARY, NUMBER, STRING, DATETIME, ROWID
>> ImportError: libpq.so.5: cannot open shared object file: No such file
>> or directory
>> >>>
>>
>> So I think I need to add the library path to ldconfig.
>>
>> /etc/ld.so.conf.d# echo "/opt/PostgreSQL/9.1/lib/">postgresql.conf
>> root@schapman-desktop:/etc/ld.so.conf.d# ldconfig
>> /sbin/ldconfig.real: /opt/PostgreSQL/9.1/lib/libproj.so.0 is not a
>> symbolic link
>>
>> /sbin/ldconfig.real: /opt/PostgreSQL/9.1/lib/libpgtypes.so.3 is not a
>> symbolic link
>>
>> /sbin/ldconfig.real: /opt/PostgreSQL/9.1/lib/libgeos-3.3.0.so is not a
>> symbolic link
>>
>> /sbin/ldconfig.real: /opt/PostgreSQL/9.1/lib/libgeos_c.so.1 is not a
>> symbolic link
>>
>> /sbin/ldconfig.real: /opt/PostgreSQL/9.1/lib/libpq.so.5 is not a symbolic
>> link
>>
>> /sbin/ldconfig.real: /opt/PostgreSQL/9.1/lib/libecpg.so.6 is not a
>> symbolic link
>>
>> /sbin/ldconfig.real: /opt/PostgreSQL/9.1/lib/libecpg_compat.so.3 is
>> not a symbolic link
>>
>> Now I can import psycopg2 into Python and all seems well.
>>
>> So I was working with stuff and went to unmount my usb stick:
>>
>> $ umount /media/patriot
>>
>> and I got this wierd error:
>> umount: /opt/PostgreSQL/9.1/lib/libuuid.so.1: no version information
>> available (required by /lib/libblkid.so.1)
>>
>> And I'm stumped.  I think the EnterpriseDB build is using a different
>> version of some library than Ubuntu 10.04 has?
>
> Yeah.
> That's the case.
> And, one of the reason, we (EnterpriseDB Installer team) do not include the
> PostgreSQL path in the ldconfig.
>>
>>
>> If I undo the ldconfig change, the error goes away, but psycopg2 won't
>> load.
>
> Can reconfigure the psycopg2 with this rpath?
>   python setup.py clean
>   python setup.py build_ext --pg-config <PG_CONFIG_PATH> --rpath
> <PG_LIB_DIR> ..
>
> i.e.
>   python setup.py build_ext --pg-config /opt/PostgreSQL/9.0/bin/pg_config
> --rpath /opt/PostgreSQL/9.0/lib ...
>
> Hope - this will help.
>
> --
>
> Thanks & Regards,
>
> Ashesh Vashi
> EnterpriseDB INDIA: Enterprise PostgreSQL Company
>
>
>
> http://www.linkedin.com/in/asheshvashi
>
>
>> Clues appreciated!
>>
>> Scott
>>
>> --
>> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
>> To make changes to your subscription:
>> http://www.postgresql.org/mailpref/pgsql-general
>
>