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.