Thread: 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
Attachment
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
Attachment
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,