The following bug has been logged online:
Bug reference: 5677
Logged by: Andrew Geery
Email address: andrew.geery@gmail.com
PostgreSQL version: 9.0
Operating system: Ubuntu 10.10
Description: missing libuuid.so.16 library
Details:
In 8.4, the one-click installer for Linux from EDB included the libuuid.so*
libraries in the PGLIB directory. However, in the 9.0 one-click installer
for Linux from EDB, these libraries are no longer included. On Ubuntu
10.10, attempting to run the uuid-ossp.sql script produces this error
because of the missing libuuid* libraries:
ERROR: could not load library
"/opt/PostgreSQL/9.0/lib/postgresql/uuid-ossp.so": libuuid.so.16: cannot
open shared object file: No such file or directory
SQL state: 58P01
The workaround is to copy the libuuid* libraries from the 8.4 installation
into the 9.0 PGLIB directory.
Not sure why those libraries were removed in 9.0 -- I was unable to find an
Ubuntu package that supplied libuuid.so.16. In /lib, there are libuuid.so.1
and libuuid.so.1.3.0, but symbolically linking them to libuuid.so.16
failed.
Thanks
Andrew