Search Postgresql Archives

Re: Missing uuid_generate_v1()

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



ï
On Wed, Oct 6, 2010 at 7:24 PM, Mike Christensen <mike@xxxxxxxxxxxxx> wrote:
> On Wed, Oct 6, 2010 at 7:21 PM, Adrian Klaver <adrian.klaver@xxxxxxxxx> 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@xxxxxxxxxxxxx> wrote:
>>> > Mike Christensen <mike@xxxxxxxxxxxxx> writes:
>>> >> On Wed, Oct 6, 2010 at 6:48 PM, Tom Lane <tgl@xxxxxxxxxxxxx> 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.klaver@xxxxxxxxx
>>
>
> 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

-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux