I'm having problems installing the uuid-ossp extension on 9.2, running
on Ubuntu. This is a fresh install, and I downloaded the binaries off
of EnterpriseDB (I did not build from source).. According to:
select * from pg_available_extensions;
The extension is available. However, when I run:
CREATE EXTENSION "uuid-ossp";
I get:
ERROR: could not load library
"/opt/PostgreSQL/9.2/lib/postgresql/uuid-ossp.so": libuuid.so.16:
cannot open shared object file: No such file or directory
********** Error **********
ERROR: could not load library
"/opt/PostgreSQL/9.2/lib/postgresql/uuid-ossp.so": libuuid.so.16:
cannot open shared object file: No such file or directory
SQL state: 58P01