Обсуждение: uuid extension not available

Поиск
Список
Период
Сортировка

uuid extension not available

От
Thara Vadakkeveedu
Дата:
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.

Re: uuid extension not available

От
Thara Vadakkeveedu
Дата:
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.


Re: uuid extension not available

От
reiner peterke
Дата:
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.

Re: uuid extension not available

От
"Christofer C. Bell"
Дата:
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 ?

From Red Hat, using the command you ran, once your server has a valid
entitlement.

--
Chris

"If you wish to make an apple pie from scratch, you must first invent
the Universe." -- Carl Sagan