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

Поиск
Список
Период
Сортировка
От Scott Chapman
Тема EnterpriseDB install of Postgres on Ubuntu 10.04 library path issues - no version information available (required by /lib/libblkid.so.1)
Дата
Msg-id CA+R6tEKAFPUitNwRB2Qys_pO8bnCe0n6CBjpub3SU7mDP4Wwvg@mail.gmail.com
обсуждение исходный текст
Ответы Re: EnterpriseDB install of Postgres on Ubuntu 10.04 library path issues - no version information available (required by /lib/libblkid.so.1)
Список pgsql-general
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?

If I undo the ldconfig change, the error goes away, but psycopg2 won't load.

Clues appreciated!

Scott

В списке pgsql-general по дате отправления:

Предыдущее
От: Eric.Kamradt
Дата:
Сообщение: Can postgres be configure for GSS/Kerberos authentication without a keyfile?
Следующее
От: "iihero"
Дата:
Сообщение: Re: PostgreSQL 8.4 crash on user defined C language function