Thread: Installing uuid-ossp on 9.2

Installing uuid-ossp on 9.2

From
Mike Christensen
Date:
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


Re: Installing uuid-ossp on 9.2

From
Adrian Klaver
Date:
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


Re: Installing uuid-ossp on 9.2

From
Mike Christensen
Date:
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


Re: Installing uuid-ossp on 9.2

From
Mike Christensen
Date:
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


[FIXED] Re: Installing uuid-ossp on 9.2

From
Mike Christensen
Date:
Ack!  This fixed it:

ln -s /usr/local/lib/libuuid.so.16 /lib/x86_64-linux-gnu/libuuid.so.16

I dream of the day where UUIDs just work out of the box in Postgres..

Mike

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


Re: Installing uuid-ossp on 9.2

From
Alban Hertroys
Date:
On 30 Sep 2012, at 2:24, Mike Christensen 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
> /usr/lib/x86_64-linux-gnu/libuuid.so

Looks like you have an old version lying around that's earlier in the library-path.
Does Linux have ldd? To see where the OS is looking, check the output of:
    ldd /opt/PostgreSQL/9.2/lib/postgresql/uuid-ossp.so

> /usr/local/lib/libuuid.so
> /usr/local/lib/libuuid.so.16
> /usr/local/lib/libuuid.so.16.0.20

Alban Hertroys

--
The scale of a problem often equals the size of an ego.