This site has been using PostgreSQL as a back end for WordPress since the beginning. This is possible with a nice little plugin PG4WP that will translate queries on the fly into something that PostgreSQL can understand.
I’m a big fan of PostgreSQL and use it on almost every project I do. There is something about setting up a MySQL instance and managing it that bothers me, so this plugin makes my day.
I have pushed a copy of the plugin to GitHub so that I can keep track of tweaks I make to it as I find compatibility problems. I am now running WordPress 3.0 and am monitoring my logs for database errors.
Hello ,
I want to make wordpress + postgres sql site can you give hint for
Thanks
@Rajesh, I would suggest you look at the PG4WP author’s site for installation instructions – http://www.hawkix.net/tag/pg4wp/
theres a increase in performance?
Not necessarily. It’s mostly a matter of personal preference. I find PostgreSQL to be more feature complete and use it on most projects. There are a number of feature and performance comparisons between MySQL and PostgreSQL out there that can be found with a quick Google search. Beware, some of them reference older versions of either database system.
When using PG4WP to use WordPress with Postgresql as a database backend, you will certainly have a somewhat slower WordPress than when using the native MySQL support.
This is because many SQL queries are rewritten on the fly, which implies some overhead.
For now PG4WP is focused on having WP to just work fine with PostgreSQL and performance is in no way a priority.
Just a note : WP 3.2.1 support is on the way and a new beta will be released soon for testing…