Lucky for me i just can't quit with something like this...

I finally came across some useful information with regards to this problem where php ignores the extension pgsql.so.
From the help forum of PHPpgAdmin, i found this post:
http://sourceforge.net/forum/message.php?msg_id=1935458Basically, if you are experiencing this problem and have already got "extension=pgsql.so" in your php.ini, but it still wont work, do the following:
cd /usr/lib
ln -s libpq.so.3 libpq.so.2
service httpd restart
This fixed the problem in my case. Goodluck! Hopefully some of the posters who experienced this problem in the past without resolving it will come across this thread:).
Big thanks to dave_d who patiently helped me in solving this issue.
EDIT: and who used the same command to solve a similar issue here:
http://forums.contribs.org/index.php?topic=24092.0
Cheers,
Tristan