[Slackbuilds-users] PostgreSQL - multiple installed versions

[Nick Warne]

On Sun, Sep 29, 2013 at 04:13:02PM +0300, Audrius Kažukauskas wrote:
> On Thu, 2013-09-19 at 12:58:54 +0200, Adis Nezirovic wrote:
> > Great, I've restored the line for explicit permissions of DATADIR and added
> > a few tips for upgrade in README.SBo
> > See attached archive.
> 
> I have successfully upgraded from 9.2.4 to 9.3.0 and then encountered the
> problem: while psycopg2 (Python DB adapter for Postgres) builds fine,
> trying to use it results in the following error:
> 
>   ImportError: libpq.so.5: cannot open shared object file: No such file
>   or directory
> 
> Quick remedy was to add LD_LIBRARY_PATH=/usr/lib/postgresql/9.3/lib to
> the init script for my webapps, but is there a better solution for this?

You can add paths that ldconfig uses in /etc/ld.so.conf

Just add:

/usr/lib/postgresql/9.3/lib

to that file and then run as root:

ldconfig

Nick
-- 
FSF Associate Member 5508
http://linicks.net/