Обсуждение: uuid-ossp

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

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

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

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

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

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

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,