Postgres Pro
Downloads
Home   >   mailing lists

Thread: Problem libpython2.3.so.1.0

Problem libpython2.3.so.1.0

From
nesfree
Date:
Hello,

I am not experienced PostgreSQL user but have following problem:

I am unable to use plpythonu on linux (ubuntu 9.04). After I execute command:

psql# CREATE LANGUAGE plpythonu;

I got following error message:

ERROR:  could not load library "/opt/PostgreSQL/8.4/lib/postgresql/plpython.so": libpython2.3.so.1.0: cannot open shared object file: No such file or directory

I usually use python2.6.2...

P.S. I can do that on windows,but I am not fan on it.

Best regards,
Predrag

Re: Problem libpython2.3.so.1.0

From
Adrian Klaver
Date:
On Saturday 29 August 2009 4:33:14 pm nesfree wrote:
> Hello,
>
> I am not experienced PostgreSQL user but have following problem:
>
> I am unable to use plpythonu on linux (ubuntu 9.04). After I execute
> command:
>
> psql# CREATE LANGUAGE plpythonu;
>
> I got following error message:
>
> ERROR:  could not load library
> "/opt/PostgreSQL/8.4/lib/postgresql/plpython.so": libpython2.3.so.1.0:
> cannot open shared object file: No such file or directory
>
> I usually use python2.6.2...
>
> P.S. I can do that on windows,but I am not fan on it.
>
> Best regards,
> Predrag

I guess the first question is how did you install Postgres?

--
Adrian Klaver
aklaver@comcast.net

Re: Problem libpython2.3.so.1.0

From
nesfree
Date:
:) Of course. As I have told I am using Ubuntu 9.04, python 2.6.2, postgres 8.4.

Supported version for Ubuntu 9.04 is PostgreSQL 8.3.7 and when I install it I have plpython.

As I understood 8.4 have some new possibilities regarding plpython.

I installed Postgres 8.4 using binary file downloaded form official Postgres site.

Best regards,

Predrag

On Sun, Aug 30, 2009 at 9:43 PM, Adrian Klaver <aklaver@comcast.net> wrote:
On Saturday 29 August 2009 4:33:14 pm nesfree wrote:
> Hello,
>
> I am not experienced PostgreSQL user but have following problem:
>
> I am unable to use plpythonu on linux (ubuntu 9.04). After I execute
> command:
>
> psql# CREATE LANGUAGE plpythonu;
>
> I got following error message:
>
> ERROR:  could not load library
> "/opt/PostgreSQL/8.4/lib/postgresql/plpython.so": libpython2.3.so.1.0:
> cannot open shared object file: No such file or directory
>
> I usually use python2.6.2...
>
> P.S. I can do that on windows,but I am not fan on it.
>
> Best regards,
> Predrag

I guess the first question is how did you install Postgres?

--
Adrian Klaver
aklaver@comcast.net

Re: Problem libpython2.3.so.1.0

From
"Daniel Verite"
Date:
    nesfree wrote:

> :) Of course. As I have told I am using Ubuntu 9.04, python 2.6.2, postgres
> 8.4.
>
> Supported version for Ubuntu 9.04 is PostgreSQL 8.3.7 and when I install it
> I have plpython.
>
> As I understood 8.4 have some new possibilities regarding plpython.
>
> I installed Postgres 8.4 using binary file downloaded form official Postgres
> site.

Better use the packages for postgresql-8.4 on Ubuntu that are available here:
https://launchpad.net/~pitti/+archive/postgresql

Best regards,
--
Daniel
PostgreSQL-powered mail user agent and storage: http://www.manitou-mail.org

Re: Problem libpython2.3.so.1.0

From
nesfree
Date:
Thank u man,

After many difficulties (adding new software sources) I succeeded!
U enlightened my way!

Best regards,

Predrag



On Mon, Aug 31, 2009 at 11:19 AM, Daniel Verite <daniel@manitou-mail.org> wrote:
       nesfree wrote:

> :) Of course. As I have told I am using Ubuntu 9.04, python 2.6.2, postgres
> 8.4.
>
> Supported version for Ubuntu 9.04 is PostgreSQL 8.3.7 and when I install it
> I have plpython.
>
> As I understood 8.4 have some new possibilities regarding plpython.
>
> I installed Postgres 8.4 using binary file downloaded form official Postgres
> site.

Better use the packages for postgresql-8.4 on Ubuntu that are available here:
https://launchpad.net/~pitti/+archive/postgresql

Best regards,
--
Daniel
PostgreSQL-powered mail user agent and storage: http://www.manitou-mail.org