Re: [GENERAL] libpython - cannot open shared object file

2010-06-23 Thread Dimitri Fontaine
Tom Wilcox writes: > Next problem: "$libdir/fuzzystrmatch": No such file or directory. I guess I > need to install the /share stuff separately.. Looks like apt-get install postgresql-contrib-8.4 should do the trick. http://packages.debian.org/lenny-backports/postgresql-contrib-8.4 Regards, --

Re: [GENERAL] libpython - cannot open shared object file

2010-06-23 Thread Tom Wilcox
OK! I have successfully got plpythonu installed. The solution was to remove any and all postgresql installation and files except /data. I then ran this from command line: sudo apt-get install postgresql-plpython-8.4 which installed plpython AND postgresql at the same time. Happy days. Next pr

Re: [GENERAL] libpython - cannot open shared object file

2010-06-23 Thread Magnus Hagander
On Wed, Jun 23, 2010 at 11:20, Dave Page wrote: > On Wed, Jun 23, 2010 at 10:19 AM, Tom Wilcox wrote: >> Hi, >> >> If I use the apt-get facility on Ubuntu is that supposed to get the >> appropriate postgres version for my OS setup (i.e. 64-bit and Python 2.6) ? > > I would assume so. I'm more of

Re: [GENERAL] libpython - cannot open shared object file

2010-06-23 Thread Dave Page
On Wed, Jun 23, 2010 at 10:19 AM, Tom Wilcox wrote: > Hi, > > If I use the apt-get facility on Ubuntu is that supposed to get the > appropriate postgres version for my OS setup (i.e. 64-bit and Python 2.6) ? I would assume so. I'm more of a Redhat guy though. -- Dave Page EnterpriseDB UK: htt

Re: [GENERAL] libpython - cannot open shared object file

2010-06-23 Thread Tom Wilcox
Hi, If I use the apt-get facility on Ubuntu is that supposed to get the appropriate postgres version for my OS setup (i.e. 64-bit and Python 2.6) ? Because I think I have done that already and it didn't solve my problem, but I will try again now (first uninstalling the current pg version).

Re: [GENERAL] libpython - cannot open shared object file

2010-06-23 Thread Dave Page
On Wed, Jun 23, 2010 at 9:52 AM, Tom Wilcox wrote: > Hi, > > I have not used python2.3 on this machine at all (to my knowledge). It is a > fresh install of the latest Ubuntu 64 which comes with Python 2.6 and 3.1. > > The build I want to run is the 64-bit PostgreSQL download for Linux x86-64 > fro

Re: [GENERAL] libpython - cannot open shared object file

2010-06-23 Thread Tom Wilcox
Hi, I have not used python2.3 on this machine at all (to my knowledge). It is a fresh install of the latest Ubuntu 64 which comes with Python 2.6 and 3.1. The build I want to run is the 64-bit PostgreSQL download for Linux x86-64 from Entreprise DB (http://www.enterprisedb.com/products/pgdo

Re: [GENERAL] libpython - cannot open shared object file

2010-06-22 Thread Tom Lane
Adrian Klaver writes: > On 06/22/2010 09:52 AM, Tom Wilcox wrote: >> 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 have python2.6 installed. > It seems pl/python is compile

Re: [GENERAL] libpython - cannot open shared object file

2010-06-22 Thread Adrian Klaver
On 06/22/2010 09:52 AM, Tom Wilcox wrote: Hi, Can anyone help me get up and running on Ubuntu 64-bit Server (lucid) OS with PostgreSQL 64-bit and Python 2.6? (Please note that this is all running in a VirtualBox VM however I am not convinced that is relevant here) I have a load of functions wr

Re: [GENERAL] libpython - cannot open shared object file

2010-06-22 Thread Tom Wilcox
Hi, Can anyone help me get up and running on Ubuntu 64-bit Server (lucid) OS with PostgreSQL 64-bit and Python 2.6? (Please note that this is all running in a VirtualBox VM however I am not convinced that is relevant here) I have a load of functions written in plpythonu and I can't run anyt

[GENERAL] libpython - cannot open shared object file

2010-06-16 Thread Tom Wilcox
Hi, I have got PostgreSQL 8.4 up and running on my Ubuntu Server 64-bit OS, but I am having difficulty with the PL/Python functions from my database. In particular, I am running this: --- drop language plpythonu cascade; create language plpython

Re: [GENERAL] libpython - cannot open shared object file

2010-06-16 Thread Tom Wilcox
Interesting: This works: postg...@ubuntu64-bertha:~$ createlang -d cse plpythonu Password: postg...@ubuntu64-bertha:~$ But this doesn't: postg...@ubuntu64-bertha:~$ psql -c "CREATE LANGUAGE plpythonu" Password: ERROR: could not load library "/opt/PostgreSQL/8.4/lib/postgresql/plpython.so": lib