[cobalt-users] [RaQ 4r] - Upgrade Postgres and upgrade php to 4.0.6

[ger.oshea@xxxxxxxxxxxx]

I have a couple of questions

Our existing system
apache 1.3.20
php 4.0.3pl1
Postgres 7.0.2
mysql 3.22.32
phpMyAdmin (Administer MySql)
We use MySql and php for our web database needs

I would like to update:
PHP  to 4.0.6 with gd (with http://pkg.nl.cobalt.com/packages/raq/4/#php)
Postgres to 7.1
phpPgAdmin

My Concerns
I would like to change our web database to Postgres, I know postgres is
running because the cobalt interface uses it, but I can not connect to it
using phpPgAdmin, I'm told it is because php is not compiled with Postgres
support - one thing I do not understand is php is compiled with the
configure option '--with-apxs=/usr/sbin/apxs' I taught (correct me if I am
wrong) that all I would have to do is add extension=pgsql.so  to php.ini
and php would work with postgres
I have tried this and it does not- maybe it is because I need to be at php
4.0.6

I would like to do the updates above, but after they are done my MySql and
php will still work correctly until I have them moved over to Postgres.
I not that worried if I can't update Postgres 7.0.2 (at the risk of
breaking the interface - its fine) if it would only work with php and
phpPgAdmin.


I'm beginning to tear my hair out on this one. any help would be greatly
appreciated.
I'm relatively new to this, please accept my apologies for any mistakes I
have made above.
Again Thanks.

Regards,

Ger O' Shea