Installing uuid-ossp on 9.2

On Sat, Sep 29, 2012 at 5:07 PM, Adrian Klaver <adrian.klaver@gmail.com> wrote:

On 09/29/2012 04:54 PM, Mike Christensen wrote:

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

http://www.postgresql.org/docs/9.2/interactive/uuid-ossp.html

This module depends on the OSSP UUID library, which can be found at
http://www.ossp.org/pkg/lib/uuid/.

--
Adrian Klaver
adrian.klaver@gmail.com

On Sat, Sep 29, 2012 at 5:12 PM, Mike Christensen <mike@kitchenpc.com> wrote:

Yea, this is already installed.. I can type "uuid" from the command
line and get a UUID generated..

On Sat, Sep 29, 2012 at 5:07 PM, Adrian Klaver <adrian.klaver@gmail.com> wrote:

On 09/29/2012 04:54 PM, Mike Christensen wrote:

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

http://www.postgresql.org/docs/9.2/interactive/uuid-ossp.html

This module depends on the OSSP UUID library, which can be found at
http://www.ossp.org/pkg/lib/uuid/.

--
Adrian Klaver
adrian.klaver@gmail.com

On Sat, Sep 29, 2012 at 5:24 PM, Mike Christensen <mike@kitchenpc.com> wrote:

I built 1.6 directly from the source and ran a make install. I'm
pretty sure this library is installed:

root@Database:~# locate libuuid.so
/lib/x86_64-linux-gnu/libuuid.so.1
/lib/x86_64-linux-gnu/libuuid.so.1.3.0
/root/uuid/uuid-1.6.0/.libs/libuuid.so
/root/uuid/uuid-1.6.0/.libs/libuuid.so.16
/root/uuid/uuid-1.6.0/.libs/libuuid.so.16.0.20
/usr/lib/x86_64-linux-gnu/libuuid.so
/usr/local/lib/libuuid.so
/usr/local/lib/libuuid.so.16
/usr/local/lib/libuuid.so.16.0.20
root@Database:~#

Is Postgres just not finding it? Do I need to make a symlink to it somewhere?

On Sat, Sep 29, 2012 at 5:12 PM, Mike Christensen <mike@kitchenpc.com> wrote:

Yea, this is already installed.. I can type "uuid" from the command
line and get a UUID generated..

On Sat, Sep 29, 2012 at 5:07 PM, Adrian Klaver <adrian.klaver@gmail.com> wrote:

On 09/29/2012 04:54 PM, Mike Christensen wrote:

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

http://www.postgresql.org/docs/9.2/interactive/uuid-ossp.html

This module depends on the OSSP UUID library, which can be found at
http://www.ossp.org/pkg/lib/uuid/.

--
Adrian Klaver
adrian.klaver@gmail.com