Обсуждение: Installing uuid-ossp on 9.2
I'm having problems installing the uuid-ossp extension on 9.2, running on Ubuntu. This is a fresh install, and I downloaded the binaries off of EnterpriseDB (I did not build from source).. According to: select * from pg_available_extensions; The extension is available. However, when I run: CREATE EXTENSION "uuid-ossp"; I get: ERROR: could not load library "/opt/PostgreSQL/9.2/lib/postgresql/uuid-ossp.so": libuuid.so.16: cannot open shared object file: No such file or directory ********** Error ********** ERROR: could not load library "/opt/PostgreSQL/9.2/lib/postgresql/uuid-ossp.so": libuuid.so.16: cannot open shared object file: No such file or directory SQL state: 58P01
On 09/29/2012 04:54 PM, Mike Christensen wrote: > I'm having problems installing the uuid-ossp extension on 9.2, running > on Ubuntu. This is a fresh install, and I downloaded the binaries off > of EnterpriseDB (I did not build from source).. According to: > > select * from pg_available_extensions; > > The extension is available. However, when I run: > > CREATE EXTENSION "uuid-ossp"; > > I get: > > ERROR: could not load library > "/opt/PostgreSQL/9.2/lib/postgresql/uuid-ossp.so": libuuid.so.16: > cannot open shared object file: No such file or directory > > > ********** Error ********** > > ERROR: could not load library > "/opt/PostgreSQL/9.2/lib/postgresql/uuid-ossp.so": libuuid.so.16: > cannot open shared object file: No such file or directory > SQL state: 58P01 http://www.postgresql.org/docs/9.2/interactive/uuid-ossp.html This module depends on the OSSP UUID library, which can be found at http://www.ossp.org/pkg/lib/uuid/. > > -- Adrian Klaver adrian.klaver@gmail.com
Yea, this is already installed.. I can type "uuid" from the command line and get a UUID generated.. On Sat, Sep 29, 2012 at 5:07 PM, Adrian Klaver <adrian.klaver@gmail.com> wrote: > On 09/29/2012 04:54 PM, Mike Christensen wrote: >> >> I'm having problems installing the uuid-ossp extension on 9.2, running >> on Ubuntu. This is a fresh install, and I downloaded the binaries off >> of EnterpriseDB (I did not build from source).. According to: >> >> select * from pg_available_extensions; >> >> The extension is available. However, when I run: >> >> CREATE EXTENSION "uuid-ossp"; >> >> I get: >> >> ERROR: could not load library >> "/opt/PostgreSQL/9.2/lib/postgresql/uuid-ossp.so": libuuid.so.16: >> cannot open shared object file: No such file or directory >> >> >> ********** Error ********** >> >> ERROR: could not load library >> "/opt/PostgreSQL/9.2/lib/postgresql/uuid-ossp.so": libuuid.so.16: >> cannot open shared object file: No such file or directory >> SQL state: 58P01 > > > http://www.postgresql.org/docs/9.2/interactive/uuid-ossp.html > > This module depends on the OSSP UUID library, which can be found at > http://www.ossp.org/pkg/lib/uuid/. >> >> >> > > > -- > Adrian Klaver > adrian.klaver@gmail.com
I built 1.6 directly from the source and ran a make install. I'm pretty sure this library is installed: root@Database:~# locate libuuid.so /lib/x86_64-linux-gnu/libuuid.so.1 /lib/x86_64-linux-gnu/libuuid.so.1.3.0 /root/uuid/uuid-1.6.0/.libs/libuuid.so /root/uuid/uuid-1.6.0/.libs/libuuid.so.16 /root/uuid/uuid-1.6.0/.libs/libuuid.so.16.0.20 /usr/lib/x86_64-linux-gnu/libuuid.so /usr/local/lib/libuuid.so /usr/local/lib/libuuid.so.16 /usr/local/lib/libuuid.so.16.0.20 root@Database:~# Is Postgres just not finding it? Do I need to make a symlink to it somewhere? On Sat, Sep 29, 2012 at 5:12 PM, Mike Christensen <mike@kitchenpc.com> wrote: > Yea, this is already installed.. I can type "uuid" from the command > line and get a UUID generated.. > > On Sat, Sep 29, 2012 at 5:07 PM, Adrian Klaver <adrian.klaver@gmail.com> wrote: >> On 09/29/2012 04:54 PM, Mike Christensen wrote: >>> >>> I'm having problems installing the uuid-ossp extension on 9.2, running >>> on Ubuntu. This is a fresh install, and I downloaded the binaries off >>> of EnterpriseDB (I did not build from source).. According to: >>> >>> select * from pg_available_extensions; >>> >>> The extension is available. However, when I run: >>> >>> CREATE EXTENSION "uuid-ossp"; >>> >>> I get: >>> >>> ERROR: could not load library >>> "/opt/PostgreSQL/9.2/lib/postgresql/uuid-ossp.so": libuuid.so.16: >>> cannot open shared object file: No such file or directory >>> >>> >>> ********** Error ********** >>> >>> ERROR: could not load library >>> "/opt/PostgreSQL/9.2/lib/postgresql/uuid-ossp.so": libuuid.so.16: >>> cannot open shared object file: No such file or directory >>> SQL state: 58P01 >> >> >> http://www.postgresql.org/docs/9.2/interactive/uuid-ossp.html >> >> This module depends on the OSSP UUID library, which can be found at >> http://www.ossp.org/pkg/lib/uuid/. >>> >>> >>> >> >> >> -- >> Adrian Klaver >> adrian.klaver@gmail.com
Ack! This fixed it: ln -s /usr/local/lib/libuuid.so.16 /lib/x86_64-linux-gnu/libuuid.so.16 I dream of the day where UUIDs just work out of the box in Postgres.. Mike On Sat, Sep 29, 2012 at 5:24 PM, Mike Christensen <mike@kitchenpc.com> wrote: > I built 1.6 directly from the source and ran a make install. I'm > pretty sure this library is installed: > > root@Database:~# locate libuuid.so > /lib/x86_64-linux-gnu/libuuid.so.1 > /lib/x86_64-linux-gnu/libuuid.so.1.3.0 > /root/uuid/uuid-1.6.0/.libs/libuuid.so > /root/uuid/uuid-1.6.0/.libs/libuuid.so.16 > /root/uuid/uuid-1.6.0/.libs/libuuid.so.16.0.20 > /usr/lib/x86_64-linux-gnu/libuuid.so > /usr/local/lib/libuuid.so > /usr/local/lib/libuuid.so.16 > /usr/local/lib/libuuid.so.16.0.20 > root@Database:~# > > Is Postgres just not finding it? Do I need to make a symlink to it somewhere? > > On Sat, Sep 29, 2012 at 5:12 PM, Mike Christensen <mike@kitchenpc.com> wrote: >> Yea, this is already installed.. I can type "uuid" from the command >> line and get a UUID generated.. >> >> On Sat, Sep 29, 2012 at 5:07 PM, Adrian Klaver <adrian.klaver@gmail.com> wrote: >>> On 09/29/2012 04:54 PM, Mike Christensen wrote: >>>> >>>> I'm having problems installing the uuid-ossp extension on 9.2, running >>>> on Ubuntu. This is a fresh install, and I downloaded the binaries off >>>> of EnterpriseDB (I did not build from source).. According to: >>>> >>>> select * from pg_available_extensions; >>>> >>>> The extension is available. However, when I run: >>>> >>>> CREATE EXTENSION "uuid-ossp"; >>>> >>>> I get: >>>> >>>> ERROR: could not load library >>>> "/opt/PostgreSQL/9.2/lib/postgresql/uuid-ossp.so": libuuid.so.16: >>>> cannot open shared object file: No such file or directory >>>> >>>> >>>> ********** Error ********** >>>> >>>> ERROR: could not load library >>>> "/opt/PostgreSQL/9.2/lib/postgresql/uuid-ossp.so": libuuid.so.16: >>>> cannot open shared object file: No such file or directory >>>> SQL state: 58P01 >>> >>> >>> http://www.postgresql.org/docs/9.2/interactive/uuid-ossp.html >>> >>> This module depends on the OSSP UUID library, which can be found at >>> http://www.ossp.org/pkg/lib/uuid/. >>>> >>>> >>>> >>> >>> >>> -- >>> Adrian Klaver >>> adrian.klaver@gmail.com
On 30 Sep 2012, at 2:24, Mike Christensen wrote:
> I built 1.6 directly from the source and ran a make install. I'm
> pretty sure this library is installed:
>
> root@Database:~# locate libuuid.so
> /lib/x86_64-linux-gnu/libuuid.so.1
> /lib/x86_64-linux-gnu/libuuid.so.1.3.0
> /usr/lib/x86_64-linux-gnu/libuuid.so
Looks like you have an old version lying around that's earlier in the library-path.
Does Linux have ldd? To see where the OS is looking, check the output of:
ldd /opt/PostgreSQL/9.2/lib/postgresql/uuid-ossp.so
> /usr/local/lib/libuuid.so
> /usr/local/lib/libuuid.so.16
> /usr/local/lib/libuuid.so.16.0.20
Alban Hertroys
--
The scale of a problem often equals the size of an ego.