pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
uuid extension not available
4+ messages / 3 participants
[nested] [flat]

* uuid extension not available
@ 2013-10-10 12:42  Thara Vadakkeveedu <tharagv@yahoo.com>
  0 siblings, 2 replies; 4+ messages in thread

From: Thara Vadakkeveedu @ 2013-10-10 12:42 UTC (permalink / raw)
  To: pgsql-admin

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 extension. The only extension that is available is plpgsql.
 
I find uuid libraries, libuuid.so.1 and libuuid.so.1.3.0 in /lib64 folder.
 
What should I do next ? How can I can install this extension ?
 
Thanks,
Thara.

^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: uuid extension not available
@ 2013-10-10 13:09  Thara Vadakkeveedu <tharagv@yahoo.com>
  parent: Thara Vadakkeveedu <tharagv@yahoo.com>
  1 sibling, 1 reply; 4+ messages in thread

From: Thara Vadakkeveedu @ 2013-10-10 13:09 UTC (permalink / raw)
  To: pgsql-admin

Hi,
 
I ran the following command on my server:
 
yum search postgresql  
 
this listed postgresql92-contrib.x86_64 package.
 
I tried to do a yum install of this package but that threw an error that it requires libossp-uuid.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 Hat Subscription Management. You can use subscription-manager to register.
Setting up Install Process
Resolving Dependencies
--> Running transaction check
---> Package postgresql92-contrib.x86_64 0:9.2.5-1PGDG.rhel6 will be installed
--> Processing Dependency: postgresql92 = 9.2.5 for package: postgresql92-contrib-9.2.5-1PGDG.rhel6.x86_64
--> Processing Dependency: libossp-uuid.so.16()(64bit) for package: postgresql92-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 = 9.2.4-1PGDG.rhel6 for package: postgresql92-server-9.2.4-1PGDG.rhel6.x86_64
---> Package postgresql92.x86_64 0:9.2.5-1PGDG.rhel6 will be an update
--> Processing Dependency: postgresql92-libs = 9.2.5-1PGDG.rhel6 for package: postgresql92-9.2.5-1PGDG.rhel6.x86_64
---> Package postgresql92-contrib.x86_64 0:9.2.5-1PGDG.rhel6 will be installed
--> Processing Dependency: libossp-uuid.so.16()(64bit) for package: postgresql92-contrib-9.2.5-1PGDG.rhel6.x86_64
--> Running transaction check
---> Package postgresql92-contrib.x86_64 0:9.2.5-1PGDG.rhel6 will be installed
--> Processing Dependency: libossp-uuid.so.16()(64bit) for package: postgresql92-contrib-9.2.5-1PGDG.rhel6.x86_64
---> Package postgresql92-libs.x86_64 0:9.2.4-1PGDG.rhel6 will be updated
---> Package postgresql92-libs.x86_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: postgresql92-contrib-9.2.5-1PGDG.rhel6.x86_64 (pgdg92)
           Requires: libossp-uuid.so.16()(64bit)
 You could try using --skip-broken to work around the problem
 You could try running: rpm -Va --nofiles --nodigest
 
 
 
Where can I get this library from ?
Thanks.


________________________________
From: Thara Vadakkeveedu <tharagv@yahoo.com>
To: "pgsql-admin@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 extension. The only extension that is available is plpgsql.
 
I find uuid libraries, libuuid.so.1 and libuuid.so.1.3.0 in /lib64 folder.

What should I do next ? How can I can install this extension ?

Thanks,
Thara.

^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: uuid extension not available
@ 2013-10-10 13:26  reiner peterke <zedaardv@gmail.com>
  parent: Thara Vadakkeveedu <tharagv@yahoo.com>
  1 sibling, 0 replies; 4+ messages in thread

From: reiner peterke @ 2013-10-10 13:26 UTC (permalink / raw)
  To: Thara Vadakkeveedu <tharagv@yahoo.com>; +Cc: pgsql-admin

it sounds like you are missing the contrib code. 

if you built from source you need to go to the contrib directory and run make, make install. 

if you installed from a package you need to install the appropriate contrib package. 

reiner

sent by smoke signals at great danger to my self. 

On 10 okt 2013, at 14:42, Thara Vadakkeveedu <tharagv@yahoo.com> wrote:

> 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 extension. The only extension that is available is plpgsql.
>  
> I find uuid libraries, libuuid.so.1 and libuuid.so.1.3.0 in /lib64 folder.
>  
> What should I do next ? How can I can install this extension ?
>  
> Thanks,
> Thara.

^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: uuid extension not available
@ 2013-10-11 19:26  Christofer C. Bell <christofer.c.bell@gmail.com>
  parent: Thara Vadakkeveedu <tharagv@yahoo.com>
  0 siblings, 0 replies; 4+ messages in thread

From: Christofer C. Bell @ 2013-10-11 19:26 UTC (permalink / raw)
  To: pgsql-admin

On Thu, Oct 10, 2013 at 8:09 AM, Thara Vadakkeveedu <tharagv@yahoo.com> wrote:
>
>
>
> [root@perf277 ~]# yum install postgresql92-contrib.x86_64
> Loaded plugins: product-id, security, subscription-manager
> This system is not registered to Red Hat Subscription Management. You can use subscription-manager to register.

You need to register your RHEL entitlement and/or pay for it.
Alternatively, you can migrate your server to CentOS or Scientific
Linux.

> Where can I get this library from ?



^ permalink  raw  reply  [nested|flat] 4+ messages in thread


end of thread, other threads:[~2013-10-11 19:26 UTC | newest]

Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2013-10-10 12:42 uuid extension not available Thara Vadakkeveedu <tharagv@yahoo.com>
2013-10-10 13:09 ` Thara Vadakkeveedu <tharagv@yahoo.com>
2013-10-11 19:26   ` Christofer C. Bell <christofer.c.bell@gmail.com>
2013-10-10 13:26 ` reiner peterke <zedaardv@gmail.com>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox