libpq.so.2.1 problem

[anorakgirl]

i just upgraded my postgresql install to version 7.2.1 (it was an rpm install, which i removed and compiled the latest version from source), restarted apache and found it wouldn't start because it couldn't load the php module. so i thought i needed to recompile php (version 4.1.1) using the new postgresql location.

so i did:
./configure --with-pgsql-/usr/local/pgsql etc etc

when i start apache i get:
Cannot load /usr/local/apache/libexec/libphp4.so into server: libpq.so.2.1: cannot open shared object file: No such file or directory
so i checked and there is no libpq.so.2.1 in the pgsql lib directory.

so i tried doing a symbolic link:
ln -s libpq.so.2.2 libpq.so.2.1

and now when i try and start apache i get:
Cannot load /usr/local/apache/libexec/libphp4.so into server: /usr/local/apache/libexec/libphp4.so: undefined symbol: pg_encoding_to_char

i'm not really sure what to try next?
thanks,
tamsin

[Anon]

When you re-compile PHP, sometimes the configuration file from previous install don't get overwritten! It might help to do a 'make clean' and/or 'make distclean' before starting the PHP ./configure! Good luck...

[anorakgirl]

tried that, still no joy 🙁
any other ideas?
thanks

[anorakgirl]

oops, ignore my previous comment, actually after doing make distclean, then rebuilding php, then doing
ln -s libpq.so.2.2 libpq.so.2.1
it does all work.
thankyou!