Not picking up PostgreSQL DB

klaith · Post by **klaith** » Wed Nov 09, 2005 4:53 pm

Just installed 0.9 into vanilla XP Apache2 php5 postgresql environment and the installation page tells me I have SQLite (and only SQLite) database extension available. I actually have postgreSQL 8.0 and no SQLite. How do I get it to pick up the fact that I postgreSQL installed

falk · Post by **falk** » Wed Nov 09, 2005 4:56 pm

klaith wrote:Just installed 0.9 into vanilla XP Apache2 php5 postgresql environment and the installation page tells me I have SQLite (and only SQLite) database extension available. I actually have postgreSQL 8.0 and no SQLite. How do I get it to pick up the fact that I postgreSQL installed

Is the pgsql-Module from PHP active? (Have a look in php.ini)

Post by **garvinhicking** » Wed Nov 09, 2005 5:23 pm

PHP5 always contains SQLite bundled.

If s9y doesn't show you pgsql as an option it means your PHP modules does NOT have the postgresql installation compiled and active. Check your phpinfo() script output for more details - I'm quite sure it doesn't list postgresql support.

On Windows PHP installations I think it's a bit harder to get pgsql working as it's not linked by default.

Regards,
Garvin

klaith · Post by **klaith** » Wed Nov 09, 2005 6:45 pm

Thanks Guys,
After doing a bit of reading I realised the culprit was probably that the standard php5 binary for windows http://www.php.net/get/php-5.0.5-Win32. ... m/a/mirror was compiled without postgresql support. I am downloading apache2triad http://apache2triad.net/ which includes php5 and postgresql8 and I'll install it and let you know if that solves the problem (although I am really starting to ask myself why I didn't just download the source and recompile PHP5

)