Error in PostgreSQL 8.4 package. "/usr/lib/postgresql/8.4/bin/pg_ctl: symbol lookup error: /usr/lib/postgresql/8.4/bin/pg_ctl: undefined symbol: PQconnectionNeedsPassword"

[Daniel Györke]

Binary package hint: postgresql-8.4

* Starting PostgreSQL 8.4 database Server
* Error: could not exec /usr/lib/postgresql/8.4/bin/pg_ctl /usr/lib/postgresql/8.4/bin/pg_ctl start -D /var/lib/postgresql/8.4/main -l /var/log/postgresql/postgresql-8.4-main.log -s -o -c config_file="/etc/postgresql/8.4/main/postgresql.conf" :
                                                                                                                                                                                                        [fail]
invoke-rc.d: initscript postgresql-8.4, action "start" failed.
$ /usr/lib/postgresql/8.4/bin/pg_ctl
/usr/lib/postgresql/8.4/bin/pg_ctl: symbol lookup error: /usr/lib/postgresql/8.4/bin/pg_ctl: undefined symbol: PQconnectionNeedsPassword

ProblemType: Bug
DistroRelease: Ubuntu 10.04
Package: postgresql-8.4 8.4.4-0ubuntu10.04
ProcVersionSignature: Ubuntu 2.6.32-24.43-generic 2.6.32.15+drm33.5
Uname: Linux 2.6.32-24-generic i686
NonfreeKernelModules: fglrx
Architecture: i386
Date: Mon Sep 27 02:49:54 2010
InstallationMedia: Ubuntu 10.04.1 LTS "Lucid Lynx" - Release i386 (20100816.1)
ProcEnviron:
 LANG=hu_HU.utf8
 SHELL=/bin/bash
SourcePackage: postgresql-8.4

[Daniel Györke (daniel-gyorke)]

I've successfully solved it.

The problem was caused by the libpq.so.5 library, it was also used by zend-server-ce and by postgresql-8.4, but of course not the same and not on the same place.

The solution:
cd /etc/ld.so.conf.d
sudo gedit postgresql-8.4.conf
<<adding following line: /usr/lib and save the file>>
ldconfig

After that PostgreSQL-8.4. can be started.

Regards,
Roscos