Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1VUG02-0000nh-Sb for pgsql-admin@arkaria.postgresql.org; Thu, 10 Oct 2013 13:09:55 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1VUG02-0007LL-5S for pgsql-admin@arkaria.postgresql.org; Thu, 10 Oct 2013 13:09:54 +0000 Received: from makus.postgresql.org ([2001:4800:7903:4::125]) by malur.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1VUG00-0007LE-R1 for pgsql-admin@postgresql.org; Thu, 10 Oct 2013 13:09:53 +0000 Received: from nm28.bullet.mail.bf1.yahoo.com ([98.139.212.187]) by makus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1VUFzj-0002F4-Tm for pgsql-admin@postgresql.org; Thu, 10 Oct 2013 13:09:52 +0000 Received: from [66.196.81.174] by nm28.bullet.mail.bf1.yahoo.com with NNFMP; 10 Oct 2013 13:09:34 -0000 Received: from [98.139.212.236] by tm20.bullet.mail.bf1.yahoo.com with NNFMP; 10 Oct 2013 13:09:29 -0000 Received: from [127.0.0.1] by omp1045.mail.bf1.yahoo.com with NNFMP; 10 Oct 2013 13:09:29 -0000 X-Yahoo-Newman-Property: ymail-3 X-Yahoo-Newman-Id: 793571.15043.bm@omp1045.mail.bf1.yahoo.com Received: (qmail 35795 invoked by uid 60001); 10 Oct 2013 13:09:28 -0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s1024; t=1381410568; bh=28HKCePsQiaiS6X8yENkTAkKPwSoeKZYU6d1xlbU2UU=; h=X-YMail-OSG:Received:X-Rocket-MIMEInfo:X-Mailer:References:Message-ID:Date:From:Reply-To:Subject:To:In-Reply-To:MIME-Version:Content-Type; b=d1H0tJG71QpWX49RjWZBnie/VL9bu6bmYVAHOu5Vh2/2ozMoyX2T/3ePpM0/eEQlcrmNdlDExcUbtjtBTRc0e2lxt6FHboB9z012W+8jOi+Y91NeMSzEHMf2/kSPTOjkpu+uPMu9Kb1xH221HCK9MtMTEW+W1hTxhgvF1Pmx9q4= DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=X-YMail-OSG:Received:X-Rocket-MIMEInfo:X-Mailer:References:Message-ID:Date:From:Reply-To:Subject:To:In-Reply-To:MIME-Version:Content-Type; b=ekIfGF4L3UAIAIq9RAvoJnoISDG0XX5g3weRk98gHUZZPNoXCByAuU9CKnGBCYCnuH3GmSPZOYZO9bvnmb/1Rv+wkVDFm/DctyKV+OTlqz28tGH/xuhemSWL6wf2usq16zvflIxEmK1kfJdnG1CiSbO2Xkv4d7US2l89B3eJOyU=; X-YMail-OSG: LNJ30yMVM1ljyoqXf8sUlXFXpCgDSpo21BCi2JsyjZFdAgX VHHuPVtCgRBDEsEYiECAYKGI3OTMzdXJvHZ20n.gpzt4nKr8VPNcqKY0WfES mNGRvkP4out65sC_7aknUf0Lqta4ra1fbCzOol6OMICIUvB1qIU6PY7U1BmR jCFd79z4y36Zy.LDvNX59VkWUGkVev.8Xx1jIiXu1YTx.su8GzVVz9pe.Gcg 2t3UgRZbgs7vUBfTriRaSyMK6AA51MqRB6XPj6DErm.qH7tgzYH2Cv7vh9Bp kHXYKeR1rg3oRe1vX9kHXe57vO3HFKdh3jNR7AZOZlEMfmjEPU2ghuGsZwbQ XWhAzPjKpuAYMQuyutjJL5ELl_T3k1Fm5UYDzq691YyZ.zbXHv4w1z4yQle_ 37On7PuO9kZf.7oNdNaXP7fmukVbXTOh5UoT6n5FfSR37tFokzQhy1z_iXIs h.IGlqpyUXXO.StALFdUI34..IOxwRr3Ekj5YONcl3OaBR29uf0XRktlzI4x KbrJmvmOvTPrnzFHBQUUwCS6tXmcg558Z6BZvGXAiMLuFEZdpySYKbVl2NHn aNZJ.lD_w_PZOBmeinKdvN5mfMQUqz7E7rXF5 Received: from [50.241.80.25] by web125001.mail.ne1.yahoo.com via HTTP; Thu, 10 Oct 2013 06:09:27 PDT X-Rocket-MIMEInfo: 002.001, SGksCsKgCkkgcmFuIHRoZSBmb2xsb3dpbmcgY29tbWFuZCBvbiBteSBzZXJ2ZXI6CsKgCnl1bSBzZWFyY2ggcG9zdGdyZXNxbMKgIArCoAp0aGlzIGxpc3RlZCBwb3N0Z3Jlc3FsOTItY29udHJpYi54ODZfNjQgcGFja2FnZS4KwqAKSSB0cmllZCB0byBkbyBhIHl1bSBpbnN0YWxsIG9mIHRoaXMgcGFja2FnZSBidXQgdGhhdCB0aHJldyBhbiBlcnJvciB0aGF0IGl0IHJlcXVpcmVzIGxpYm9zc3AtdXVpZC5zby4xNigpKDY0Yml0KS4KwqAKwqAKW3Jvb3RAcGVyZjI3NyB.XSMgeXVtIGluc3RhbGwgcG9zdGdyZXMBMAEBAQE- X-Mailer: YahooMailWebService/0.8.160.587 References: <1381408933.15336.YahooMailNeo@web125001.mail.ne1.yahoo.com> Message-ID: <1381410567.35691.YahooMailNeo@web125001.mail.ne1.yahoo.com> Date: Thu, 10 Oct 2013 06:09:27 -0700 (PDT) From: Thara Vadakkeveedu Reply-To: Thara Vadakkeveedu Subject: Re: uuid extension not available To: "pgsql-admin@postgresql.org" In-Reply-To: <1381408933.15336.YahooMailNeo@web125001.mail.ne1.yahoo.com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="1184048422-1058384955-1381410567=:35691" X-Pg-Spam-Score: 0.5 (/) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org --1184048422-1058384955-1381410567=:35691 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable Hi,=0A=A0=0AI ran the following command on my server:=0A=A0=0Ayum search po= stgresql=A0 =0A=A0=0Athis listed postgresql92-contrib.x86_64 package.=0A=A0= =0AI tried to do a yum install of this package but that threw an error that= it requires libossp-uuid.so.16()(64bit).=0A=A0=0A=A0=0A[root@perf277 ~]# y= um install postgresql92-contrib.x86_64=0ALoaded plugins: product-id, securi= ty, subscription-manager=0AThis system is not registered to Red Hat Subscri= ption Management. You can use subscription-manager to register.=0ASetting u= p Install Process=0AResolving Dependencies=0A--> Running transaction check= =0A---> Package postgresql92-contrib.x86_64 0:9.2.5-1PGDG.rhel6 will be ins= talled=0A--> Processing Dependency: postgresql92 =3D 9.2.5 for package: pos= tgresql92-contrib-9.2.5-1PGDG.rhel6.x86_64=0A--> Processing Dependency: lib= ossp-uuid.so.16()(64bit) for package: postgresql92-contrib-9.2.5-1PGDG.rhel= 6.x86_64=0A--> Running transaction check=0A---> Package postgresql92.x86_64= 0:9.2.4-1PGDG.rhel6 will be updated=0A--> Processing Dependency: postgresq= l92 =3D 9.2.4-1PGDG.rhel6 for package: postgresql92-server-9.2.4-1PGDG.rhel= 6.x86_64=0A---> Package postgresql92.x86_64 0:9.2.5-1PGDG.rhel6 will be an = update=0A--> Processing Dependency: postgresql92-libs =3D 9.2.5-1PGDG.rhel6= for package: postgresql92-9.2.5-1PGDG.rhel6.x86_64=0A---> Package postgres= ql92-contrib.x86_64 0:9.2.5-1PGDG.rhel6 will be installed=0A--> Processing = Dependency: libossp-uuid.so.16()(64bit) for package: postgresql92-contrib-9= .2.5-1PGDG.rhel6.x86_64=0A--> Running transaction check=0A---> Package post= gresql92-contrib.x86_64 0:9.2.5-1PGDG.rhel6 will be installed=0A--> Process= ing Dependency: libossp-uuid.so.16()(64bit) for package: postgresql92-contr= ib-9.2.5-1PGDG.rhel6.x86_64=0A---> Package postgresql92-libs.x86_64 0:9.2.4= -1PGDG.rhel6 will be updated=0A---> Package postgresql92-libs.x86_64 0:9.2.= 5-1PGDG.rhel6 will be an update=0A---> Package postgresql92-server.x86_64 0= :9.2.4-1PGDG.rhel6 will be updated=0A---> Package postgresql92-server.x86_6= 4 0:9.2.5-1PGDG.rhel6 will be an update=0A--> Finished Dependency Resolutio= n=0AError: Package: postgresql92-contrib-9.2.5-1PGDG.rhel6.x86_64 (pgdg92)= =0A=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 Requires: libossp-uuid.so.16()(64bit)=0A= =A0You could try using --skip-broken to work around the problem=0A=A0You co= uld try running: rpm -Va --nofiles --nodigest=0A=A0=0A=A0=0A=A0=0AWhere can= I get this library from ?=0AThanks.=0A=0A=0A______________________________= __=0AFrom: Thara Vadakkeveedu =0ATo: "pgsql-admin@postgr= esql.org" =0ASent: Thursday, October 10, 2013 = 8:42 AM=0ASubject: uuid extension not available=0A=0A=0A=0AHi=0AI have post= gresql 9.2 installed on red hat linux 6.4=A0. I need to generate uuids usin= g the uuid_generate_v4() function.=0A=0Aselect * from pg_available_extensio= ns does not list this extension. The only=A0extension that is available=A0i= s plpgsql.=0A=A0=0AI find uuid libraries, libuuid.so.1 and libuuid.so.1.3.0= in /lib64 folder.=0A=0AWhat should I do next ? How can I can install this = extension ?=0A=0AThanks,=0AThara. --1184048422-1058384955-1381410567=:35691 Content-Type: text/html; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable
Hi,
 
I ran the following = command on my server:
 
yum search postgresql=  
 
this listed postgresql92-cont= rib.x86_64 package.
 
I tried to do a yum = install of this package but that threw an error that it requires libossp-uu= id.so.16()(64bit).
 
 
[root@perf277 ~]# yum= install postgresql92-contrib.x86_64
Loaded plugins: product-id= , security, subscription-manager
This system is not registered to Red Ha= t Subscription Management. You can use subscription-manager to register.Setting up Install Process
Resolving Dependencies
--> Running tra= nsaction check
---> Package postgresql92-contrib.x86_64 0:9.2.5-1PGDG= .rhel6 will be installed
--> Processing Dependency: postgresql92 =3D = 9.2.5 for package: postgresql92-contrib-9.2.5-1PGDG.rhel6.x86_64
--> = Processing Dependency: libossp-uuid.so.16()(64bit) for package: postgresql9= 2-contrib-9.2.5-1PGDG.rhel6.x86_64
--> Running transaction check
-= --> Package postgresql92.x86_64 0:9.2.4-1PGDG.rhel6 will be updated
--> Processing Dependency: postgresql92 =3D 9.2.4-1PGDG.rhel= 6 for package: postgresql92-server-9.2.4-1PGDG.rhel6.x86_64
---> Pack= age postgresql92.x86_64 0:9.2.5-1PGDG.rhel6 will be an update
--> Pro= cessing Dependency: postgresql92-libs =3D 9.2.5-1PGDG.rhel6 for package: po= stgresql92-9.2.5-1PGDG.rhel6.x86_64
---> Package postgresql92-contrib= .x86_64 0:9.2.5-1PGDG.rhel6 will be installed
--> Processing Dependen= cy: libossp-uuid.so.16()(64bit) for package: postgresql92-contrib-9.2.5-1PG= DG.rhel6.x86_64
--> Running transaction check
---> Package post= gresql92-contrib.x86_64 0:9.2.5-1PGDG.rhel6 will be installed
--> Pro= cessing Dependency: libossp-uuid.so.16()(64bit) for package: postgresql92-c= ontrib-9.2.5-1PGDG.rhel6.x86_64
---> Package postgresql92-libs.x86_64= 0:9.2.4-1PGDG.rhel6 will be updated
---> Package postgresql92-libs.x= 86_64 0:9.2.5-1PGDG.rhel6 will be an update
---> Package postgresql92-server.x86_64 0:9.2.4-1PGDG.rhel6 will be updated
---> = Package postgresql92-server.x86_64 0:9.2.5-1PGDG.rhel6 will be an update--> Finished Dependency Resolution
Error: Package: postgresq= l92-contrib-9.2.5-1PGDG.rhel6.x86_64 (pgdg92)
    &n= bsp;      Requires: libossp-uuid.so.16()(64bit) You could try using --skip-broken to work around the proble= m
 You could try running: rpm -Va --nofiles --nodigest
 
 
 
Where can I get this library = from ?
Thanks.

From: Thara Vadakkeveedu <tharagv@yaho= o.com>
To: "pgsql-adm= in@postgresql.org" <pgsql-admin@postgresql.org>
Sent: Thursday, October 10, 2013 8:42 AM
= Subject: uuid extension not= available

Hi
I have postgresql 9.2 installed on red hat linux 6.4 . I need to = generate uuids using the uuid_generate_v4() function.
 
select * from pg_available_extensions does not list this extens= ion. The only extension that is available is plpgsql.
 
I find uuid libraries, libuuid.so.1 and libuuid.so.1.3.0 in /lib64 fol= der.
 
What should I do next ? How can I can install this extension ?
 
Thanks,
Thara.


<= /html> --1184048422-1058384955-1381410567=:35691--