Обсуждение: 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.
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
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
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.
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.
sent by smoke signals at great danger to my self.
HiI 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.
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