Thread: contrib uuid X64
Hi, I am trying to install a new updated machine with REHL 5.5 X64. I get postgresql installed and running no problem but when I install the contrib package which normally contains the uuid-ossp.sql and libuuid.so they are not being installed. I am wondering if this is an X64 issue and if anyone has seen this before?
Roy
On Thu, 2011-10-20 at 15:08 +0000, Morris, Roy wrote: > Hi, I am trying to install a new updated machine with REHL 5.5 X64. I > get postgresql installed and running no problem but when I install the > contrib package which normally contains the uuid-ossp.sql and > libuuid.so they are not being installed. I am wondering if this is an > X64 issue and if anyone has seen this before? How are you installing PostgreSQL? Via RPMs? Which PostgreSQL version? -- Devrim GÜNDÜZ Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr http://www.gunduz.org Twitter: http://twitter.com/devrimgunduz
Attachment
It's installed via yum and installs 8.4.9 which should be fine that's what's running on the X86 boxes. I install at the sametime the contrib package but alas no uuid. -----Original Message----- From: Devrim GÜNDÜZ [mailto:devrim@gunduz.org] Sent: Thursday, October 20, 2011 11:37 AM To: Morris, Roy Cc: pgsql-novice@postgresql.org Subject: Re: [NOVICE] contrib uuid X64 On Thu, 2011-10-20 at 15:08 +0000, Morris, Roy wrote: > Hi, I am trying to install a new updated machine with REHL 5.5 X64. I > get postgresql installed and running no problem but when I install the > contrib package which normally contains the uuid-ossp.sql and > libuuid.so they are not being installed. I am wondering if this is an > X64 issue and if anyone has seen this before? How are you installing PostgreSQL? Via RPMs? Which PostgreSQL version? -- Devrim GÜNDÜZ Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com PostgreSQL Danışmanı/Consultant, Red Hat CertifiedEngineer Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr http://www.gunduz.org Twitter: http://twitter.com/devrimgunduz The information contained in this e-mail and in any attachments is intended only for the person or entity to which it isaddressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other useof, or taking of any action in reliance upon, this information by persons or entities other than the intended recipientis prohibited. This message has been scanned for known computer viruses.
"Morris, Roy" <rmorris@internetsecure.com> writes:
> It's installed via yum and installs 8.4.9 which should be fine that's what's running on the X86 boxes. I install at
thesame time the contrib package but alas no uuid.
If you're speaking of the Red Hat-provided "postgresql84" RPMs, they
don't include contrib/uuid because Red Hat doesn't ship the underlying
uuid package in RHEL5.
I think it's available in EPEL, and possibly Devrim's packaging of PG
for RHEL5 relies on that copy ... but I can't very well ship a RHEL core
package with an EPEL dependency :-(
regards, tom lane
I'm confused. So you're saying that I need to install which extra package to get uuid going? I have installed uuid-1.6
compiledon the box with the ./configure --with-pgsql and it all goes fine and make install works. I run the uuid.sql
scriptand it's not happy.
psql:/home/rmorris/uuid-ossp.sql:14: ERROR: could not find function "uuid_ns_dns" in file "/usr/lib64/pgsql/uuid.so"
psql:/home/rmorris/uuid-ossp.sql:19: ERROR: could not find function "uuid_ns_url" in file "/usr/lib64/pgsql/uuid.so"
psql:/home/rmorris/uuid-ossp.sql:24: ERROR: could not find function "uuid_ns_oid" in file "/usr/lib64/pgsql/uuid.so"
psql:/home/rmorris/uuid-ossp.sql:29: ERROR: could not find function "uuid_ns_x500" in file "/usr/lib64/pgsql/uuid.so"
psql:/home/rmorris/uuid-ossp.sql:34: ERROR: could not find function "uuid_generate_v1" in file
"/usr/lib64/pgsql/uuid.so"
psql:/home/rmorris/uuid-ossp.sql:39: ERROR: could not find function "uuid_generate_v1mc" in file
"/usr/lib64/pgsql/uuid.so"
Any help or advice would be great. I'd hate to have to reinstall 10 servers with FC14 or something to get this working.
Roy
-----Original Message-----
From: Tom Lane [mailto:tgl@sss.pgh.pa.us]
Sent: Thursday, October 20, 2011 1:20 PM
To: Morris, Roy
Cc: Devrim GÜNDÜZ; pgsql-novice@postgresql.org
Subject: Re: [NOVICE] contrib uuid X64
"Morris, Roy" <rmorris@internetsecure.com> writes:
> It's installed via yum and installs 8.4.9 which should be fine that's what's running on the X86 boxes. I install at
thesame time the contrib package but alas no uuid.
If you're speaking of the Red Hat-provided "postgresql84" RPMs, they
don't include contrib/uuid because Red Hat doesn't ship the underlying
uuid package in RHEL5.
I think it's available in EPEL, and possibly Devrim's packaging of PG
for RHEL5 relies on that copy ... but I can't very well ship a RHEL core
package with an EPEL dependency :-(
regards, tom lane
The information contained in this e-mail and in any attachments is intended only for the person or entity to which it
isaddressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other
useof, or taking of any action in reliance upon, this information by persons or entities other than the intended
recipientis prohibited. This message has been scanned for known computer viruses.
"Morris, Roy" <rmorris@internetsecure.com> writes:
> I'm confused. So you're saying that I need to install which extra
> package to get uuid going?
The Red Hat postgresql84 RPMs do not include contrib/uuid, period.
Installing a copy of libuuid won't change that.
If you need contrib/uuid, and don't want to build it from source, I'd
suggest looking into using the PGDG postgresql RPMs. I'm not 100% sure
that those include contrib/uuid either, but you have a better chance
than you do with postgresql84.
regards, tom lane
On Thu, 2011-10-20 at 13:20 -0400, Tom Lane wrote: > If you're speaking of the Red Hat-provided "postgresql84" RPMs, they > don't include contrib/uuid because Red Hat doesn't ship the underlying > uuid package in RHEL5. > > I think it's available in EPEL, and possibly Devrim's packaging of PG > for RHEL5 relies on that copy ... but I can't very well ship a RHEL > core package with an EPEL dependency :-( We actually have uuid in the PGDG repo, to avoid dependency to EPEL repo... -- Devrim GÜNDÜZ Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr http://www.gunduz.org Twitter: http://twitter.com/devrimgunduz
Attachment
On Thu, 2011-10-20 at 16:26 +0000, Morris, Roy wrote: > It's installed via yum and installs 8.4.9 which should be fine that's > what's running on the X86 boxes. I install at the same time the > contrib package but alas no uuid. It is there? $ rpm -qlp postgresql-contrib-8.4.9-1PGDG.rhel5.i386.rpm |grep uuid /usr/lib/pgsql/uuid-ossp.so /usr/share/doc/postgresql-contrib-8.4.9/uninstall_uuid-ossp.sql /usr/share/doc/postgresql-contrib-8.4.9/uuid-ossp.sql /usr/share/pgsql/contrib/uninstall_uuid-ossp.sql /usr/share/pgsql/contrib/uuid-ossp.sql You need to run uuid-ossp.sql in the database to actually be able to use it . -- Devrim GÜNDÜZ Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr http://www.gunduz.org Twitter: http://twitter.com/devrimgunduz
Attachment
Thanks all. I compiled from source and it all just worked! Thanks again. -----Original Message----- From: Devrim GÜNDÜZ [mailto:devrim@gunduz.org] Sent: Friday, October 21, 2011 4:50 AM To: Morris, Roy Cc: pgsql-novice@postgresql.org Subject: Re: [NOVICE] contrib uuid X64 On Thu, 2011-10-20 at 16:26 +0000, Morris, Roy wrote: > It's installed via yum and installs 8.4.9 which should be fine that's > what's running on the X86 boxes. I install at the same time the > contrib package but alas no uuid. It is there? $ rpm -qlp postgresql-contrib-8.4.9-1PGDG.rhel5.i386.rpm |grep uuid /usr/lib/pgsql/uuid-ossp.so /usr/share/doc/postgresql-contrib-8.4.9/uninstall_uuid-ossp.sql /usr/share/doc/postgresql-contrib-8.4.9/uuid-ossp.sql /usr/share/pgsql/contrib/uninstall_uuid-ossp.sql /usr/share/pgsql/contrib/uuid-ossp.sql You need to run uuid-ossp.sql in the database to actually be able to use it . -- Devrim GÜNDÜZ Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com PostgreSQL Danışmanı/Consultant, Red Hat CertifiedEngineer Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr http://www.gunduz.org Twitter: http://twitter.com/devrimgunduz The information contained in this e-mail and in any attachments is intended only for the person or entity to which it isaddressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other useof, or taking of any action in reliance upon, this information by persons or entities other than the intended recipientis prohibited. This message has been scanned for known computer viruses.