Re: uuid extension not available

[Thara Vadakkeveedu <tharagv@xxxxxxxxx>]

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@xxxxxxxxx>
To: "pgsql-admin@xxxxxxxxxxxxxx" <pgsql-admin@xxxxxxxxxxxxxx>
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.