pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feeduuid 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