Обсуждение: 8.3 and uuid: unable to run uuid-ossp.sql

Hi all,
I’m trying to enable the uuid module with a SUSE Linux. I’ve
installed the uuid library with the default settings and configured/
compiled/installed pgsql with these flags:

./configure --prefix=/opt/local/pgsql --with-perl --with-tcl --with-
tclconfig=/opt/local/lib --with-openssl --with-readline --with-zlib --
enable-thread-safety --enable-integer-datetimes --with-ossp-uuid

Then I’ve installed the uuid shared library from the contrib
directory and the .so file is located under /opt/local/pgsql/lib/uuid-
ossp.so.
When I try to install the uuid functions I get this error:

psql:share/contrib/uuid-ossp.sql:9: ERROR:  could not load library "/
opt/local/pgsql/lib/uuid-ossp.so": libuuid.so.16: cannot open shared
object file: No such file or directory

Can somebody help me to solve this problem? Or give some hints?

Thank you in advance


--
Giorgio Valoti

Giorgio Valoti wrote:

> When I try to install the uuid functions I get this error:
>
> psql:share/contrib/uuid-ossp.sql:9: ERROR:  could not load library "/
> opt/local/pgsql/lib/uuid-ossp.so": libuuid.so.16: cannot open shared
> object file: No such file or directory

Make sure the libuuid.so.16 file is somewhere the dynamic linker can
find it.  Perhaps the directory where it resides could be added to
/etc/ld.so.conf (and run ldconfig after that), or put it in
LD_LIBRARY_PATH in the postmaster's environment.

Even better, install OSSP's libuuid using your distribution packages,
which would likely put it in /usr/lib or another well-known place where
you won't need any of these additional fixups.

--
Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.