Thread: 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.