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"
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
postgresql-8.4 (Ubuntu) |
New
|
Undecided
|
Unassigned |
Bug Description
Binary package hint: postgresql-8.4
* Starting PostgreSQL 8.4 database Server
* Error: could not exec /usr/lib/
invoke-rc.d: initscript postgresql-8.4, action "start" failed.
$ /usr/lib/
/usr/lib/
ProblemType: Bug
DistroRelease: Ubuntu 10.04
Package: postgresql-8.4 8.4.4-0ubuntu10.04
ProcVersionSign
Uname: Linux 2.6.32-24-generic i686
NonfreeKernelMo
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
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