Re: Missing uuid_generate_v1()

My production server is running Postgres 9.0 on Ubuntu Server, and I'm
getting some errors in sprocs that call uuid_generate_v1().. This is
because the function is missing.

On my Windows box, this function would automatically be installed as
part of the database.. If I try to create the function with:

CREATE OR REPLACE FUNCTION uuid_generate_v1()
RETURNS uuid AS
'$libdir/uuid-ossp', 'uuid_generate_v1'
LANGUAGE c VOLATILE STRICT
COST 1;

I get:

ERROR: could not load library
"/opt/PostgreSQL/9.0/lib/postgresql/uuid-ossp.so": libuuid.so.16:
cannot open shared object file: No such file or directory
SQL state: 58P01

How do I get this working under Linux? Thanks!!

Mike

On Wed, Oct 6, 2010 at 7:18 PM, Mike Christensen <mike(at)kitchenpc(dot)com> wrote:
> My production server is running Postgres 9.0 on Ubuntu Server, and I'm
> getting some errors in sprocs that call uuid_generate_v1()..  This is
> because the function is missing.
>
> On my Windows box, this function would automatically be installed as
> part of the database..  If I try to create the function with:
>
>
> CREATE OR REPLACE FUNCTION uuid_generate_v1()
>  RETURNS uuid AS
> '$libdir/uuid-ossp', 'uuid_generate_v1'
>  LANGUAGE c VOLATILE STRICT
>  COST 1;
>
> I get:
>
> ERROR: could not load library
> "/opt/PostgreSQL/9.0/lib/postgresql/uuid-ossp.so": libuuid.so.16:
> cannot open shared object file: No such file or directory
> SQL state: 58P01
>
> How do I get this working under Linux?  Thanks!!

Have you installed the contrib package? Often there's an associated
.sql file to turn a contrib module on in a given database. It'll be
in something like /usr/share usually

On Wed, Oct 6, 2010 at 6:25 PM, Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com> wrote:
> On Wed, Oct 6, 2010 at 7:18 PM, Mike Christensen <mike(at)kitchenpc(dot)com> wrote:
>> My production server is running Postgres 9.0 on Ubuntu Server, and I'm
>> getting some errors in sprocs that call uuid_generate_v1()..  This is
>> because the function is missing.
>>
>> On my Windows box, this function would automatically be installed as
>> part of the database..  If I try to create the function with:
>>
>>
>> CREATE OR REPLACE FUNCTION uuid_generate_v1()
>>  RETURNS uuid AS
>> '$libdir/uuid-ossp', 'uuid_generate_v1'
>>  LANGUAGE c VOLATILE STRICT
>>  COST 1;
>>
>> I get:
>>
>> ERROR: could not load library
>> "/opt/PostgreSQL/9.0/lib/postgresql/uuid-ossp.so": libuuid.so.16:
>> cannot open shared object file: No such file or directory
>> SQL state: 58P01
>>
>> How do I get this working under Linux?  Thanks!!
>
> Have you installed the contrib package?  Often there's an associated
> .sql file to turn a contrib module on in a given database.  It'll be
> in something like /usr/share usually

Yup, I tried that - Here's what I get:

# ./psql -d ****** -U ****** -f
/opt/PostgreSQL/9.0/share/postgresql/contrib/uuid-ossp.sql
Password for user root:
SET
psql:/opt/PostgreSQL/9.0/share/postgresql/contrib/uuid-ossp.sql:9:
ERROR: could not load library
"/opt/PostgreSQL/9.0/lib/postgresql/uuid-ossp.so": libuuid.so.16:
cannot open shared object file: No such file or directory
psql:/opt/PostgreSQL/9.0/share/postgresql/contrib/uuid-ossp.sql:14:
ERROR: could not load library
"/opt/PostgreSQL/9.0/lib/postgresql/uuid-ossp.so": libuuid.so.16:
cannot open shared object file: No such file or directory
psql:/opt/PostgreSQL/9.0/share/postgresql/contrib/uuid-ossp.sql:19:
ERROR: could not load library
"/opt/PostgreSQL/9.0/lib/postgresql/uuid-ossp.so": libuuid.so.16:
cannot open shared object file: No such file or directory
psql:/opt/PostgreSQL/9.0/share/postgresql/contrib/uuid-ossp.sql:24:
ERROR: could not load library
"/opt/PostgreSQL/9.0/lib/postgresql/uuid-ossp.so": libuuid.so.16:
cannot open shared object file: No such file or directory
psql:/opt/PostgreSQL/9.0/share/postgresql/contrib/uuid-ossp.sql:29:
ERROR: could not load library
"/opt/PostgreSQL/9.0/lib/postgresql/uuid-ossp.so": libuuid.so.16:
cannot open shared object file: No such file or directory
psql:/opt/PostgreSQL/9.0/share/postgresql/contrib/uuid-ossp.sql:34:
ERROR: could not load library
"/opt/PostgreSQL/9.0/lib/postgresql/uuid-ossp.so": libuuid.so.16:
cannot open shared object file: No such file or directory
psql:/opt/PostgreSQL/9.0/share/postgresql/contrib/uuid-ossp.sql:39:
ERROR: could not load library
"/opt/PostgreSQL/9.0/lib/postgresql/uuid-ossp.so": libuuid.so.16:
cannot open shared object file: No such file or directory
psql:/opt/PostgreSQL/9.0/share/postgresql/contrib/uuid-ossp.sql:44:
ERROR: could not load library
"/opt/PostgreSQL/9.0/lib/postgresql/uuid-ossp.so": libuuid.so.16:
cannot open shared object file: No such file or directory
psql:/opt/PostgreSQL/9.0/share/postgresql/contrib/uuid-ossp.sql:49:
ERROR: could not load library
"/opt/PostgreSQL/9.0/lib/postgresql/uuid-ossp.so": libuuid.so.16:
cannot open shared object file: No such file or directory
psql:/opt/PostgreSQL/9.0/share/postgresql/contrib/uuid-ossp.sql:54:
ERROR: could not load library
"/opt/PostgreSQL/9.0/lib/postgresql/uuid-ossp.so": libuuid.so.16:
cannot open shared object file: No such file or directory

On Wed, Oct 6, 2010 at 6:27 PM, Mike Christensen <mike(at)kitchenpc(dot)com> wrote:
> On Wed, Oct 6, 2010 at 6:25 PM, Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com> wrote:
>> On Wed, Oct 6, 2010 at 7:18 PM, Mike Christensen <mike(at)kitchenpc(dot)com> wrote:
>>> My production server is running Postgres 9.0 on Ubuntu Server, and I'm
>>> getting some errors in sprocs that call uuid_generate_v1()..  This is
>>> because the function is missing.
>>>
>>> On my Windows box, this function would automatically be installed as
>>> part of the database..  If I try to create the function with:
>>>
>>>
>>> CREATE OR REPLACE FUNCTION uuid_generate_v1()
>>>  RETURNS uuid AS
>>> '$libdir/uuid-ossp', 'uuid_generate_v1'
>>>  LANGUAGE c VOLATILE STRICT
>>>  COST 1;
>>>
>>> I get:
>>>
>>> ERROR: could not load library
>>> "/opt/PostgreSQL/9.0/lib/postgresql/uuid-ossp.so": libuuid.so.16:
>>> cannot open shared object file: No such file or directory
>>> SQL state: 58P01
>>>
>>> How do I get this working under Linux?  Thanks!!
>>
>> Have you installed the contrib package?  Often there's an associated
>> .sql file to turn a contrib module on in a given database.  It'll be
>> in something like /usr/share usually
>
> Yup, I tried that - Here's what I get:
>
> # ./psql -d ****** -U ****** -f
> /opt/PostgreSQL/9.0/share/postgresql/contrib/uuid-ossp.sql
> Password for user root:
> SET
> psql:/opt/PostgreSQL/9.0/share/postgresql/contrib/uuid-ossp.sql:9:
> ERROR:  could not load library
> "/opt/PostgreSQL/9.0/lib/postgresql/uuid-ossp.so": libuuid.so.16:
> cannot open shared object file: No such file or directory
> psql:/opt/PostgreSQL/9.0/share/postgresql/contrib/uuid-ossp.sql:14:
> ERROR:  could not load library
> "/opt/PostgreSQL/9.0/lib/postgresql/uuid-ossp.so": libuuid.so.16:
> cannot open shared object file: No such file or directory
> psql:/opt/PostgreSQL/9.0/share/postgresql/contrib/uuid-ossp.sql:19:
> ERROR:  could not load library
> "/opt/PostgreSQL/9.0/lib/postgresql/uuid-ossp.so": libuuid.so.16:
> cannot open shared object file: No such file or directory
> psql:/opt/PostgreSQL/9.0/share/postgresql/contrib/uuid-ossp.sql:24:
> ERROR:  could not load library
> "/opt/PostgreSQL/9.0/lib/postgresql/uuid-ossp.so": libuuid.so.16:
> cannot open shared object file: No such file or directory
> psql:/opt/PostgreSQL/9.0/share/postgresql/contrib/uuid-ossp.sql:29:
> ERROR:  could not load library
> "/opt/PostgreSQL/9.0/lib/postgresql/uuid-ossp.so": libuuid.so.16:
> cannot open shared object file: No such file or directory
> psql:/opt/PostgreSQL/9.0/share/postgresql/contrib/uuid-ossp.sql:34:
> ERROR:  could not load library
> "/opt/PostgreSQL/9.0/lib/postgresql/uuid-ossp.so": libuuid.so.16:
> cannot open shared object file: No such file or directory
> psql:/opt/PostgreSQL/9.0/share/postgresql/contrib/uuid-ossp.sql:39:
> ERROR:  could not load library
> "/opt/PostgreSQL/9.0/lib/postgresql/uuid-ossp.so": libuuid.so.16:
> cannot open shared object file: No such file or directory
> psql:/opt/PostgreSQL/9.0/share/postgresql/contrib/uuid-ossp.sql:44:
> ERROR:  could not load library
> "/opt/PostgreSQL/9.0/lib/postgresql/uuid-ossp.so": libuuid.so.16:
> cannot open shared object file: No such file or directory
> psql:/opt/PostgreSQL/9.0/share/postgresql/contrib/uuid-ossp.sql:49:
> ERROR:  could not load library
> "/opt/PostgreSQL/9.0/lib/postgresql/uuid-ossp.so": libuuid.so.16:
> cannot open shared object file: No such file or directory
> psql:/opt/PostgreSQL/9.0/share/postgresql/contrib/uuid-ossp.sql:54:
> ERROR:  could not load library
> "/opt/PostgreSQL/9.0/lib/postgresql/uuid-ossp.so": libuuid.so.16:
> cannot open shared object file: No such file or directory
>

Oh btw, the file does actually exist.. Maybe it's missing some
permission or something?

ls -l /opt/PostgreSQL/9.0/lib/postgresql/uuid-ossp.so
-rwxr-xr-x 1 root daemon 12648 Oct 3 20:03
/opt/PostgreSQL/9.0/lib/postgresql/uuid-ossp.so

Mike Christensen <mike(at)kitchenpc(dot)com> writes:
> Oh btw, the file does actually exist.. Maybe it's missing some
> permission or something?

> ls -l /opt/PostgreSQL/9.0/lib/postgresql/uuid-ossp.so
> -rwxr-xr-x 1 root daemon 12648 Oct 3 20:03
> /opt/PostgreSQL/9.0/lib/postgresql/uuid-ossp.so

What does "ldd /opt/PostgreSQL/9.0/lib/postgresql/uuid-ossp.so"
say?

regards, tom lane

On Wed, Oct 6, 2010 at 6:42 PM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> Mike Christensen <mike(at)kitchenpc(dot)com> writes:
>> Oh btw, the file does actually exist..  Maybe it's missing some
>> permission or something?
>
>> ls -l /opt/PostgreSQL/9.0/lib/postgresql/uuid-ossp.so
>> -rwxr-xr-x 1 root daemon 12648 Oct  3 20:03
>> /opt/PostgreSQL/9.0/lib/postgresql/uuid-ossp.so
>
> What does "ldd /opt/PostgreSQL/9.0/lib/postgresql/uuid-ossp.so"
> say?
>
>                        regards, tom lane
>

# ldd /opt/PostgreSQL/9.0/lib/postgresql/uuid-ossp.so
linux-vdso.so.1 => (0x00007fff5a5ff000)
libuuid.so.16 => not found
libc.so.6 => /lib/libc.so.6 (0x00007f5398e08000)
/lib64/ld-linux-x86-64.so.2 (0x00007f5399392000)

Mike Christensen <mike(at)kitchenpc(dot)com> writes:
> On Wed, Oct 6, 2010 at 6:42 PM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
>> What does "ldd /opt/PostgreSQL/9.0/lib/postgresql/uuid-ossp.so"
>> say?

> # ldd /opt/PostgreSQL/9.0/lib/postgresql/uuid-ossp.so
> linux-vdso.so.1 => (0x00007fff5a5ff000)
> libuuid.so.16 => not found
> libc.so.6 => /lib/libc.so.6 (0x00007f5398e08000)
> /lib64/ld-linux-x86-64.so.2 (0x00007f5399392000)

So you don't have libuuid installed. Go forth and get it ...

regards, tom lane

On Wed, Oct 6, 2010 at 6:48 PM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> Mike Christensen <mike(at)kitchenpc(dot)com> writes:
>> On Wed, Oct 6, 2010 at 6:42 PM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
>>> What does "ldd /opt/PostgreSQL/9.0/lib/postgresql/uuid-ossp.so"
>>> say?
>
>> # ldd /opt/PostgreSQL/9.0/lib/postgresql/uuid-ossp.so
>>       linux-vdso.so.1 =>  (0x00007fff5a5ff000)
>>       libuuid.so.16 => not found
>>       libc.so.6 => /lib/libc.so.6 (0x00007f5398e08000)
>>       /lib64/ld-linux-x86-64.so.2 (0x00007f5399392000)
>
> So you don't have libuuid installed.  Go forth and get it ...
>
>                        regards, tom lane
>

What's the easiest way to do that? Is there a .bin file I can run?
Or a URL I can wget? Thanks!

Mike Christensen <mike(at)kitchenpc(dot)com> writes:
> On Wed, Oct 6, 2010 at 6:48 PM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
>> So you don't have libuuid installed. Go forth and get it ...

> What's the easiest way to do that? Is there a .bin file I can run?
> Or a URL I can wget? Thanks!

I'd expect it'd be available as a standard package for your platform ---
see yum or apt-get or whatever you use there.

regards, tom lane

On Wed, Oct 6, 2010 at 6:51 PM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> Mike Christensen <mike(at)kitchenpc(dot)com> writes:
>> On Wed, Oct 6, 2010 at 6:48 PM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
>>> So you don't have libuuid installed.  Go forth and get it ...
>
>> What's the easiest way to do that?  Is there a .bin file I can run?
>> Or a URL I can wget?  Thanks!
>
> I'd expect it'd be available as a standard package for your platform ---
> see yum or apt-get or whatever you use there.
>
>                        regards, tom lane
>

Ok I just installed anything that looked relevant:

apt-get install libuuid1 uuid-dev uuid-runtime

It said libuuid1 was already installed, but installed the other two.
However, libuuid.so.16 is still "not found"..

Mike Christensen <mike(at)kitchenpc(dot)com> writes:
> However, libuuid.so.16 is still "not found"..

So have you got libuuid.anything in /usr/lib (or /usr/lib64 as the case
may be)?

regards, tom lane

On Wed, Oct 6, 2010 at 6:59 PM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> Mike Christensen <mike(at)kitchenpc(dot)com> writes:
>> However, libuuid.so.16 is still "not found"..
>
> So have you got libuuid.anything in /usr/lib (or /usr/lib64 as the case
> may be)?
>
>                        regards, tom lane
>

/usr/lib# ls -l libuuid*
-rw-r--r-- 1 root root 28068 Mar 22 2010 libuuid.a
lrwxrwxrwx 1 root root 21 Oct 7 01:54 libuuid.so -> /lib/libuuid.so.1.3.0

/usr/lib64# ls -l libuuid*
-rw-r--r-- 1 root root 28068 Mar 22 2010 libuuid.a
lrwxrwxrwx 1 root root 21 Oct 7 01:54 libuuid.so -> /lib/libuuid.so.1.3.0

Mike Christensen <mike(at)kitchenpc(dot)com> writes:
> On Wed, Oct 6, 2010 at 6:59 PM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
>> Mike Christensen <mike(at)kitchenpc(dot)com> writes:
>>> However, libuuid.so.16 is still "not found"..
>>
>> So have you got libuuid.anything in /usr/lib (or /usr/lib64 as the case
>> may be)?

> /usr/lib# ls -l libuuid*
> -rw-r--r-- 1 root root 28068 Mar 22 2010 libuuid.a
> lrwxrwxrwx 1 root root 21 Oct 7 01:54 libuuid.so -> /lib/libuuid.so.1.3.0

Well, apparently the copy of Postgres you have was built on a different
platform than you're using ... one where libuuid is thought to be at
major version 16. I don't know where that would've been exactly ---
on my Fedora box, libuuid is libuuid.so.1.3.0 also.

You need to get those version numbers to match up, either by finding a
version of PG that *was* built on your platform, or by rebuilding PG
locally.

I have heard of people hacking this type of situation by creating a
symlink from one library version to the other, but that seems pretty
risky to me.

regards, tom lane

On Wednesday 06 October 2010 6:56:22 pm Mike Christensen wrote:
> On Wed, Oct 6, 2010 at 6:51 PM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> > Mike Christensen <mike(at)kitchenpc(dot)com> writes:
> >> On Wed, Oct 6, 2010 at 6:48 PM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> >>> So you don't have libuuid installed.  Go forth and get it ...
> >>
> >> What's the easiest way to do that?  Is there a .bin file I can run?
> >> Or a URL I can wget?  Thanks!
> >
> > I'd expect it'd be available as a standard package for your platform ---
> > see yum or apt-get or whatever you use there.
> >
> >                        regards, tom lane
>
> Ok I just installed anything that looked relevant:
>
> apt-get install libuuid1 uuid-dev uuid-runtime
>
> It said libuuid1 was already installed, but installed the other two.
> However, libuuid.so.16 is still "not found"..

What version of Ubuntu and libuuid are you running? The stock version of uuid
that came with my Ubuntu 8.04 does not work. I downloaded a newer
version(1.6.2) from:
http://www.ossp.org/pkg/lib/uuid/
I compiled it and Postgres was happy.

--
Adrian Klaver
adrian(dot)klaver(at)gmail(dot)com

On Wed, Oct 6, 2010 at 7:15 PM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> Mike Christensen <mike(at)kitchenpc(dot)com> writes:
>> On Wed, Oct 6, 2010 at 6:59 PM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
>>> Mike Christensen <mike(at)kitchenpc(dot)com> writes:
>>>> However, libuuid.so.16 is still "not found"..
>>>
>>> So have you got libuuid.anything in /usr/lib (or /usr/lib64 as the case
>>> may be)?
>
>> /usr/lib# ls -l libuuid*
>> -rw-r--r-- 1 root root 28068 Mar 22  2010 libuuid.a
>> lrwxrwxrwx 1 root root    21 Oct  7 01:54 libuuid.so -> /lib/libuuid.so.1.3.0
>
> Well, apparently the copy of Postgres you have was built on a different
> platform than you're using ... one where libuuid is thought to be at
> major version 16.  I don't know where that would've been exactly ---
> on my Fedora box, libuuid is libuuid.so.1.3.0 also.
>
> You need to get those version numbers to match up, either by finding a
> version of PG that *was* built on your platform, or by rebuilding PG
> locally.
>
> I have heard of people hacking this type of situation by creating a
> symlink from one library version to the other, but that seems pretty
> risky to me.
>
>                        regards, tom lane
>

I got it working..

I just built libuuid 1.6 from the source and installed that :)

BTW, I installed Postgres 9 from the .bin file downloadable at
enterprisedb.com..

On Wed, Oct 6, 2010 at 7:21 PM, Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com> wrote:
> On Wednesday 06 October 2010 6:56:22 pm Mike Christensen wrote:
>> On Wed, Oct 6, 2010 at 6:51 PM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
>> > Mike Christensen <mike(at)kitchenpc(dot)com> writes:
>> >> On Wed, Oct 6, 2010 at 6:48 PM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
>> >>> So you don't have libuuid installed.  Go forth and get it ...
>> >>
>> >> What's the easiest way to do that?  Is there a .bin file I can run?
>> >> Or a URL I can wget?  Thanks!
>> >
>> > I'd expect it'd be available as a standard package for your platform ---
>> > see yum or apt-get or whatever you use there.
>> >
>> >                        regards, tom lane
>>
>> Ok I just installed anything that looked relevant:
>>
>> apt-get install libuuid1 uuid-dev uuid-runtime
>>
>> It said libuuid1 was already installed, but installed the other two.
>> However, libuuid.so.16 is still "not found"..
>
> What version of Ubuntu and libuuid are you running?  The stock version of uuid
> that came with my Ubuntu 8.04 does not work. I downloaded a newer
> version(1.6.2) from:
> http://www.ossp.org/pkg/lib/uuid/
> I compiled it and Postgres was happy.
>
> --
> Adrian Klaver
> adrian(dot)klaver(at)gmail(dot)com
>

Yup that's exactly what I did.. I'm on 10.04, which doesn't have
libuuid 1.6 in the software repository, go figure..

I greatly appreciate everyone's help..


On Wed, Oct 6, 2010 at 7:24 PM, Mike Christensen <mike(at)kitchenpc(dot)com> wrote:
> On Wed, Oct 6, 2010 at 7:21 PM, Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com> wrote:
>> On Wednesday 06 October 2010 6:56:22 pm Mike Christensen wrote:
>>> On Wed, Oct 6, 2010 at 6:51 PM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
>>> > Mike Christensen <mike(at)kitchenpc(dot)com> writes:
>>> >> On Wed, Oct 6, 2010 at 6:48 PM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
>>> >>> So you don't have libuuid installed.  Go forth and get it ...
>>> >>
>>> >> What's the easiest way to do that?  Is there a .bin file I can run?
>>> >> Or a URL I can wget?  Thanks!
>>> >
>>> > I'd expect it'd be available as a standard package for your platform ---
>>> > see yum or apt-get or whatever you use there.
>>> >
>>> >                        regards, tom lane
>>>
>>> Ok I just installed anything that looked relevant:
>>>
>>> apt-get install libuuid1 uuid-dev uuid-runtime
>>>
>>> It said libuuid1 was already installed, but installed the other two.
>>> However, libuuid.so.16 is still "not found"..
>>
>> What version of Ubuntu and libuuid are you running?  The stock version of uuid
>> that came with my Ubuntu 8.04 does not work. I downloaded a newer
>> version(1.6.2) from:
>> http://www.ossp.org/pkg/lib/uuid/
>> I compiled it and Postgres was happy.
>>
>> --
>> Adrian Klaver
>> adrian(dot)klaver(at)gmail(dot)com
>>
>
> Yup that's exactly what I did..  I'm on 10.04, which doesn't have
> libuuid 1.6 in the software repository, go figure..
>
> I greatly appreciate everyone's help..
>

Oh BTW, in case anyone stumbles across this thread archived in the
future, once you do this, be sure to do a postgres restart, or PG
apparently just crashes and burns when you call uuid_generate_v1() :)

Once I restarted the server, I could generate UUIDs all day long..

Mike

Mike Christensen <mike(at)kitchenpc(dot)com> writes:
> Yup that's exactly what I did.. I'm on 10.04, which doesn't have
> libuuid 1.6 in the software repository, go figure..

Oh ... we're in package-naming hell, is where we are. Poking around
some more on my Fedora 13 box, I find I have two different, similarly
named packages:

$ rpm -qa | grep uuid
uuid-1.6.1-11.fc13.x86_64
libuuid-2.17.2-8.fc13.x86_64
uuid-devel-1.6.1-11.fc13.x86_64
libuuid-devel-2.17.2-8.fc13.x86_64
$ rpm -ql uuid-1.6.1-11.fc13.x86_64
/usr/bin/uuid
/usr/lib64/libossp-uuid.so.16
/usr/lib64/libossp-uuid.so.16.0.21
... and some doc files ...
$ rpm -ql libuuid-2.17.2-8.fc13.x86_64
/lib64/libuuid.so.1
/lib64/libuuid.so.1.3.0

The file you actually want, on Fedora (and, I bet, on Ubuntu),
is libossp-uuid.so.16. But apparently EDB's package was built on some
platform where uuid's library is installed as just "libuuid.so.16".
Maybe they used a homebuilt copy instead of an official platform
distribution?

If you have a libossp-uuid.so.16, you might try symlinking libuuid.so.16
to that instead of carrying a separate file.

regards, tom lane

On Wed, Oct 6, 2010 at 7:38 PM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> Mike Christensen <mike(at)kitchenpc(dot)com> writes:
>> Yup that's exactly what I did..  I'm on 10.04, which doesn't have
>> libuuid 1.6 in the software repository, go figure..
>
> Oh ... we're in package-naming hell, is where we are.  Poking around
> some more on my Fedora 13 box, I find I have two different, similarly
> named packages:
>
> $ rpm -qa | grep uuid
> uuid-1.6.1-11.fc13.x86_64
> libuuid-2.17.2-8.fc13.x86_64
> uuid-devel-1.6.1-11.fc13.x86_64
> libuuid-devel-2.17.2-8.fc13.x86_64
> $ rpm -ql uuid-1.6.1-11.fc13.x86_64
> /usr/bin/uuid
> /usr/lib64/libossp-uuid.so.16
> /usr/lib64/libossp-uuid.so.16.0.21
> ... and some doc files ...
> $ rpm -ql libuuid-2.17.2-8.fc13.x86_64
> /lib64/libuuid.so.1
> /lib64/libuuid.so.1.3.0
>
> The file you actually want, on Fedora (and, I bet, on Ubuntu),
> is libossp-uuid.so.16.  But apparently EDB's package was built on some
> platform where uuid's library is installed as just "libuuid.so.16".
> Maybe they used a homebuilt copy instead of an official platform
> distribution?
>
> If you have a libossp-uuid.so.16, you might try symlinking libuuid.so.16
> to that instead of carrying a separate file.
>
>                        regards, tom lane
>

So now what you're saying is if it's not broke, fix it till it is :)

Mike Christensen <mike(at)kitchenpc(dot)com> writes:
> On Wed, Oct 6, 2010 at 7:38 PM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
>> If you have a libossp-uuid.so.16, you might try symlinking libuuid.so.16
>> to that instead of carrying a separate file.

> So now what you're saying is if it's not broke, fix it till it is :)

Well, it's hard to argue with that position ;-). But I'll try anyway:
the platform-provided version of the library will be updated for bug
fixes, compatibility rebuilds, etc. Your private copy won't be, unless
you remember to do it. Eventually that's gonna bite ya.

Of course the best fix would be for EDB to ship a build of Postgres
that actually follows the platform-standard naming convention for this
library. I'm still wondering why they're linking to libuuid.so.
Dave?

regards, tom lane

On Wed, Oct 6, 2010 at 7:56 PM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> Mike Christensen <mike(at)kitchenpc(dot)com> writes:
>> On Wed, Oct 6, 2010 at 7:38 PM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
>>> If you have a libossp-uuid.so.16, you might try symlinking libuuid.so.16
>>> to that instead of carrying a separate file.
>
>> So now what you're saying is if it's not broke, fix it till it is :)
>
> Well, it's hard to argue with that position ;-).  But I'll try anyway:
> the platform-provided version of the library will be updated for bug
> fixes, compatibility rebuilds, etc.  Your private copy won't be, unless
> you remember to do it.  Eventually that's gonna bite ya.
>
> Of course the best fix would be for EDB to ship a build of Postgres
> that actually follows the platform-standard naming convention for this
> library.  I'm still wondering why they're linking to libuuid.so.
> Dave?
>
>                        regards, tom lane
>

Agreed. However, if you go to
http://www.postgresql.org/download/linux then it points you right to
EnterpriseDB to download a bin installer. So your choices are:

1) Use apt-get: This won't give you 9.0 yet (I think 10.04 only has 8.4)
2) Build it yourself (I'm not enough of a hacker to do this, probably
the case with most "novice" users)
3) One click installer maintained by EDB.
4) Some other repository out there? Dunno if anyone maintains one.

I agree, EDB needs to make this "just work" on the latest Ubuntu.

Mike

On Thu, Oct 7, 2010 at 05:09, Mike Christensen <mike(at)kitchenpc(dot)com> wrote:
> On Wed, Oct 6, 2010 at 7:56 PM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
>> Mike Christensen <mike(at)kitchenpc(dot)com> writes:
>>> On Wed, Oct 6, 2010 at 7:38 PM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
>>>> If you have a libossp-uuid.so.16, you might try symlinking libuuid.so.16
>>>> to that instead of carrying a separate file.
>>
>>> So now what you're saying is if it's not broke, fix it till it is :)
>>
>> Well, it's hard to argue with that position ;-).  But I'll try anyway:
>> the platform-provided version of the library will be updated for bug
>> fixes, compatibility rebuilds, etc.  Your private copy won't be, unless
>> you remember to do it.  Eventually that's gonna bite ya.
>>
>> Of course the best fix would be for EDB to ship a build of Postgres
>> that actually follows the platform-standard naming convention for this
>> library.  I'm still wondering why they're linking to libuuid.so.
>> Dave?
>>
>>                        regards, tom lane
>>
>
> Agreed.  However, if you go to
> http://www.postgresql.org/download/linux then it points you right to
> EnterpriseDB to download a bin installer.  So your choices are:

The very first paragraph says we recommend you use apt packages.

I wanted to move the packages higher up in the actual list, but was
voted down ;)

>
> 1) Use apt-get: This won't give you 9.0 yet (I think 10.04 only has 8.4)

It is. You need to enable the PPA at
https://launchpad.net/~pitti/+archive/postgresql, per
http://www.piware.de/2010/09/postgresql-9-0-final-released/.

We should probably add a link to that PPA from the donwload page.
Martin - any reason *not* to do that?

> 2) Build it yourself (I'm not enough of a hacker to do this, probably
> the case with most "novice" users)

Yeah, that's definitely not recommended.

> 3) One click installer maintained by EDB.
> 4) Some other repository out there?  Dunno if anyone maintains one.
>
> I agree, EDB needs to make this "just work" on the latest Ubuntu.

Yes, in this case it looks like a bug in the EDB installer that should be fixed.

But even when that is fixed, the recommendation is still to use the
APT packages since you get all the package management integration etc.

BTW - Dave, I notice the edb page says only ubuntu 8.04 and up, fedora
10 and up, etc are supported by the installers from 9.0 and newer -
the download page on pg.org should probably be updated with that
information.

--
 Magnus Hagander
 Me: http://www.hagander.net/
 Work: http://www.redpill-linpro.com/

On Wed, Oct 6, 2010 at 10:47 PM, Magnus Hagander <magnus(at)hagander(dot)net> wrote:
> On Thu, Oct 7, 2010 at 05:09, Mike Christensen <mike(at)kitchenpc(dot)com> wrote:
>> On Wed, Oct 6, 2010 at 7:56 PM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
>>> Mike Christensen <mike(at)kitchenpc(dot)com> writes:
>>>> On Wed, Oct 6, 2010 at 7:38 PM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
>>>>> If you have a libossp-uuid.so.16, you might try symlinking libuuid.so.16
>>>>> to that instead of carrying a separate file.
>>>
>>>> So now what you're saying is if it's not broke, fix it till it is :)
>>>
>>> Well, it's hard to argue with that position ;-).  But I'll try anyway:
>>> the platform-provided version of the library will be updated for bug
>>> fixes, compatibility rebuilds, etc.  Your private copy won't be, unless
>>> you remember to do it.  Eventually that's gonna bite ya.
>>>
>>> Of course the best fix would be for EDB to ship a build of Postgres
>>> that actually follows the platform-standard naming convention for this
>>> library.  I'm still wondering why they're linking to libuuid.so.
>>> Dave?
>>>
>>>                        regards, tom lane
>>>
>>
>> Agreed.  However, if you go to
>> http://www.postgresql.org/download/linux then it points you right to
>> EnterpriseDB to download a bin installer.  So your choices are:
>
> The very first paragraph says we recommend you use apt packages.
>
> I wanted to move the packages higher up in the actual list, but was
> voted down ;)
>
>>
>> 1) Use apt-get: This won't give you 9.0 yet (I think 10.04 only has 8.4)
>
> It is. You need to enable the PPA at
> https://launchpad.net/~pitti/+archive/postgresql, per
> http://www.piware.de/2010/09/postgresql-9-0-final-released/.
>
> We should probably add a link to that PPA from the donwload page.
> Martin - any reason *not* to do that?
>
>
>
>> 2) Build it yourself (I'm not enough of a hacker to do this, probably
>> the case with most "novice" users)
>
> Yeah, that's definitely not recommended.
>
>> 3) One click installer maintained by EDB.
>> 4) Some other repository out there?  Dunno if anyone maintains one.
>>
>> I agree, EDB needs to make this "just work" on the latest Ubuntu.
>
> Yes, in this case it looks like a bug in the EDB installer that should be fixed.
>
> But even when that is fixed, the recommendation is still to use the
> APT packages since you get all the package management integration etc.
>
> BTW - Dave, I notice the edb page says only ubuntu 8.04 and up, fedora
> 10 and up, etc  are supported by the installers from 9.0 and newer -
> the download page on pg.org should probably be updated with that
> information.
>
> --
>  Magnus Hagander
>  Me: http://www.hagander.net/
>  Work: http://www.redpill-linpro.com/
>

Thanks! In the future, I'll use the apt package.. I prefer this
option when available..

On ons, 2010-10-06 at 18:18 -0700, Mike Christensen wrote:
> ERROR: could not load library
> "/opt/PostgreSQL/9.0/lib/postgresql/uuid-ossp.so": libuuid.so.16:
> cannot open shared object file: No such file or directory
> SQL state: 58P01

apt-get install libossp-uuid16

On Thu, Oct 7, 2010 at 3:56 AM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> Mike Christensen <mike(at)kitchenpc(dot)com> writes:
>> On Wed, Oct 6, 2010 at 7:38 PM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
>>> If you have a libossp-uuid.so.16, you might try symlinking libuuid.so.16
>>> to that instead of carrying a separate file.
>
>> So now what you're saying is if it's not broke, fix it till it is :)
>
> Well, it's hard to argue with that position ;-).  But I'll try anyway:
> the platform-provided version of the library will be updated for bug
> fixes, compatibility rebuilds, etc.  Your private copy won't be, unless
> you remember to do it.  Eventually that's gonna bite ya.
>
> Of course the best fix would be for EDB to ship a build of Postgres
> that actually follows the platform-standard naming convention for this
> library.  I'm still wondering why they're linking to libuuid.so.
> Dave?

Because that's what comes with ossp-uuid 1.6.2, and I assume is what
configure chooses when we use --with-ossp-uuid:

[buildfarm(at)bf2-linux ~]$ uuid-config --libs
-luuid

FYI, there was also a bug in the installer which didn't copy the
library properly, which has been fixed for 9.0.2.

--
Dave Page
PostgreSQL Core Team
http://www.postgresql.org/