[FIXED] Re: Installing uuid-ossp on 9.2

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(at)kitchenpc(dot)com> wrote:
> I built 1.6 directly from the source and ran a make install. I'm
> pretty sure this library is installed:
>
> root(at)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(at)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(at)kitchenpc(dot)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(dot)klaver(at)gmail(dot)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(dot)klaver(at)gmail(dot)com