Re: Missing uuid_generate_v1()


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