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