Re: Missing uuid_generate_v1()

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..