PostgreSQL for WordPress (or PG4WP) is a plugin to install and use WordPress with a PostgreSQL database.
Current development is done with WordPress version 3.2.1 but it may work with other versions too (2.9.2 was tested ok recently).
The original code was inspired by usleepless’ script « mysql2pgsql.php » and has evolved to become compatible with newer versions of WordPress and PostgreSQL.
PG4WP rewrites the SQL code on the fly and makes the call to the native function adequately in place of the « mysql_*() » initial call.
The plugin is based on a wpdb class identical to the WordPress’ one, except that all calls to « mysql_*() » are renamed « wpsql_*() », and the « converter » defines these « wpsql_*() » functions.
You don’t need to disable MySQL support in PHP to use a « converter » for a particular database and MySQL support is still available (the MySQL « converter » is included).
The WordPress core works, but there was very little testing.
If you test it (successfully or not) , I’d like to be informed of the results.
Plugins using WordPress’ wpdb with standard SQL should work without modification.
If you use a plugin successfully (or not) , please leave a comment.
If a plugin you wish to use doesn’t work and you think PG4WP is the cause, please leave a comment and I’ll try fix the problem.