Thread: uuid-ossp

uuid-ossp

From
Chris spotts
Date:
I’m brand new to Postgresql and working on moving an existing large DB
into it.  I’m trying to get uuid-ossp functions to work.  I know the
UUID type is installed, but I need the generate functions.  I’ve
installed postgresql-server and postgresql-contrib from the postgresql
yum repos (working with Oracle Unbreakable Linux – which is TERRIBLE,
but I don’t have a choice in the matter) and everything is good.  I just
cannot for the life of me figure out how to install the uuid-ossp
functions.  I’ve seen stuff about a .sql query to run, but I’ve done an
updatedb/locate and cannot find it.  It is not in the contrib folder.
Any help would be much appreciated.



Thanks for any ideas,

Chris



Re: uuid-ossp

From
Chris spotts
Date:
Well, the only file that shows up is the uninstall file? Thats a little
odd.
Looks like I'll be rebuilding from source on monday...joyous.
On Sat, 2009-04-04 at 11:40 -0400, Tom Lane wrote:
> Chris spotts <rfusca@gmail.com> writes:
> > I’m brand new to Postgresql and working on moving an
> > existing large DB into it.  I’m trying to get uuid-ossp
> > functions to work.  I know the UUID type is installed, but I need the
> > generate functions.  I’ve installed postgresql-server andRP
> > postgresql-contrib from the postgresql yum repos (working with Oracle
> > Unbreakable Linux – which is TERRIBLE, but I
> > don’t have a choice in the matter) and everything is good.
> > I just cannot for the life of me figure out how to install the
> > uuid-ossp functions.  I’ve seen stuff about a .sql query to
> > run, but I’ve done an updatedb/locate and cannot find it.
> > It is not in the contrib folder.  Any help would be much appreciated.
>
> Well, if Oracle haven't managed to totally break the rpm infrastructure,
> then "rpm -ql postgresql-contrib" should give you a list of all the
> files installed by that rpm.  On my machine grepping that for uuid shows
>
> /usr/lib64/pgsql/uuid-ossp.so
> /usr/share/pgsql/contrib/uninstall_uuid-ossp.sql
> /usr/share/pgsql/contrib/uuid-ossp.sql
>
> (obviously it might be lib not lib64 if not a 64-bit install).  The
> third of these is the SQL script you need to run to install the
> functions in a particular database.
>
> It's possible that the PGDG RPMs don't build uuid support, in which case
> you won't see those files.  In that case the answer would be to nag
> Devrim about including it, or rebuild from the SRPMs for yourself ...
>
>             regards, tom lane


Re: uuid-ossp

From
Chris spotts
Date:
Thanks, I got it installed from source and  got uuid-ossp working.   One
of the easier installs from source for a major app that I've done.
Appreciate the help.

Chris
On Sat, 2009-04-04 at 11:40 -0400, Tom Lane wrote:
> Chris spotts <rfusca@gmail.com> writes:
> > I’m brand new to Postgresql and working on moving an
> > existing large DB into it.  I’m trying to get uuid-ossp
> > functions to work.  I know the UUID type is installed, but I need the
> > generate functions.  I’ve installed postgresql-se
> rver and
> > postgresql-contrib from the postgresql yum repos (working with Oracle
> > Unbreakable Linux – which is TERRIBLE, but I
> > don’t have a choice in the matter) and everything is good.
> > I just cannot for the life of me figure out how to install the
> > uuid-ossp functions.  I’ve seen stuff about a .sql query to
> > run, but I’ve done an updatedb/locate and cannot find it.
> > It is not in the contrib folder.  Any help would be much appreciated.
>
> Well, if Oracle haven't managed to totally break the rpm infrastructure,
> then "rpm -ql postgresql-contrib" should give you a list of all the
> files installed by that rpm.  On my machine grepping that for uuid shows
>
> /usr/lib64/pgsql/uuid-ossp.so
> /usr/share/pgsql/contrib/uninstall_uuid-ossp.sql
> /usr/share/pgsql/contrib/uuid-ossp.sql
>
> (obviously it might be lib not lib64 if not a 64-bit install).  The
> third of these is the SQL script you need to run to install the
> functions in a particular database.
>
> It's possible that the PGDG RPMs don't build uuid support, in which case
> you won't see those files.  In that case the answer would be to nag
> Devrim about including it, or rebuild from the SRPMs for yourself ...
>
>             regards, tom lane


Re: uuid-ossp

From
Devrim GÜNDÜZ
Date:
On Sat, 2009-04-04 at 11:36 -0500, Chris spotts wrote:
> Well, the only file that shows up is the uninstall file? Thats a
> little odd.

I see these files on my 8.4 :

/usr/share/pgsql/contrib/uninstall_uuid-ossp.sql
/usr/share/pgsql/contrib/uuid-ossp.sql

See second one. It is there. uuid support is enabled in PGDG RPMs.

Regards,
--
Devrim GÜNDÜZ, RHCE
devrim~gunduz.org, devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr
                   http://www.gunduz.org

Attachment

Re: uuid-ossp

From
David Kerr
Date:
FWIW it's not in contrib on SLES 11 or on opensuse 11 for 8.3

I'm planning on rolling my own from source as well.

Dave Kerr

Chris spotts wrote:
> Thanks, I got it installed from source and  got uuid-ossp working.   One
> of the easier installs from source for a major app that I've done.
> Appreciate the help.
>
> Chris
> On Sat, 2009-04-04 at 11:40 -0400, Tom Lane wrote:
>> Chris spotts <rfusca@gmail.com> writes:
>>> I’m brand new to Postgresql and working on moving an
>>> existing large DB into it.  I’m trying to get uuid-ossp
>>> functions to work.  I know the UUID type is installed, but I need the
>>> generate functions.  I’ve installed postgresql-se
>> rver and
>>> postgresql-contrib from the postgresql yum repos (working with Oracle
>>> Unbreakable Linux – which is TERRIBLE, but I
>>> don’t have a choice in the matter) and everything is good.
>>> I just cannot for the life of me figure out how to install the
>>> uuid-ossp functions.  I’ve seen stuff about a .sql query to
>>> run, but I’ve done an updatedb/locate and cannot find it.
>>> It is not in the contrib folder.  Any help would be much appreciated.
>> Well, if Oracle haven't managed to totally break the rpm infrastructure,
>> then "rpm -ql postgresql-contrib" should give you a list of all the
>> files installed by that rpm.  On my machine grepping that for uuid shows
>>
>> /usr/lib64/pgsql/uuid-ossp.so
>> /usr/share/pgsql/contrib/uninstall_uuid-ossp.sql
>> /usr/share/pgsql/contrib/uuid-ossp.sql
>>
>> (obviously it might be lib not lib64 if not a 64-bit install).  The
>> third of these is the SQL script you need to run to install the
>> functions in a particular database.
>>
>> It's possible that the PGDG RPMs don't build uuid support, in which case
>> you won't see those files.  In that case the answer would be to nag
>> Devrim about including it, or rebuild from the SRPMs for yourself ...
>>
>>             regards, tom lane
>
>


Re: uuid-ossp

From
Devrim GÜNDÜZ
Date:
On Sat, 2009-04-04 at 13:03 -0700, David Kerr wrote:
> FWIW it's not in contrib on SLES 11 or on opensuse 11 for 8.3

I am about to announce OpenSuSE 11+ and SLES 10+ RPMs soon, really soon,
which will include all features that PGDG Fedora/RH/CentOS RPMs have. If
you are not in a hurry, you may wait for them. For details, please keep
looking at Planet PostgreSQL: http://www.planetpostgresql.org and/or
http://yum.pgsqlrpms.org .

Regards,
--
Devrim GÜNDÜZ, RHCE
devrim~gunduz.org, devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr
                   http://www.gunduz.org

Attachment

Re: uuid-ossp

From
Chris spotts
Date:
Go figure, eh?  It wasn't there when I installed the RHEL version.  But
its all good.

Chris
On Sat, 2009-04-04 at 22:28 +0300, Devrim GÜNDÜZ wrote:
> On Sat, 2009-04-04 at 11:36 -0500, Chris spotts wrote:
> > Well, the only file that shows up is the uninstall file? Thats a
> > little odd.
>
> I see these files on my 8.4 :
>
> /usr/share/pgsql/contrib/uninstall_uuid-ossp.sql
> /usr/share/pgsql/contrib/uuid-ossp.sql
>
> See second one. It is there. uuid support is enabled in PGDG RPMs.
>
> Regards,