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…
PG4WP with WP-E-COMMERCE plugin
Hello friends of fragility,
the pg4wp plugin was the reason to give WordPress a try. Sadly there are not so many CMS based on Postgresql. So this plugin would be a real enrichment for WP.
I tryed to get the wp-e-commerce plugin (3.8.7.6.2) working on WordPress 3.3.1 and Postgresql 8.3 but I could not setup the shop at « Settings -> Store -> General » because the drop-down lists and drop-down-menus for « Base Country/Region: », « Target Markets: », « Currency Type: » are empty and the currency symbol at « Currency Sign Location: » is not visible.
I looked in the « pg4wp_erros.log » file and I found several hundred lines of errors that can be associated with the wp-e-commerce plugin (these errors occure directly after activating the plugin)
The errors that occures are like this:
—- converted to —-
SHOW TABLE STATUS LIKE ‘wp_wpsc_also_bought’
—-
FEHLER: Syntaxfehler bei »TABLE«
LINE 1: SHOW TABLE STATUS LIKE ‘wp_wpsc_also_bought’
.
.
.
—- converted to —-
ALTER TABLE wp_wpsc_checkout_forms ADD checkout_order int(10) unsigned NOT NULL DEFAULT ’0′ AFTER active;
—-
FEHLER: Syntaxfehler bei »(«
LINE 1: …ABLE wp_wpsc_checkout_forms ADD checkout_order int(10) unsig…
^
———————
.
.
.
—- converted to —-
ALTER TABLE wp_wpsc_currency_list ADD id bigint(20) unsigned NOT NULL auto_increment ;
—-
FEHLER: Syntaxfehler bei »(«
LINE 1: ALTER TABLE wp_wpsc_currency_list ADD id bigint(20) unsigned…
^
———————
Error running :
—- converted to —-
ALTER TABLE wp_wpsc_currency_list ADD country varchar(255) NOT NULL DEFAULT » AFTER id;
—-
FEHLER: Syntaxfehler bei »AFTER«
LINE 1: …list ADD country varchar(255) NOT NULL DEFAULT » AFTER id;
^
———————
… and so on …
I already tryed the bugfix of Hawk777 at “http://www.hawkix.net/pgsql-for-wordpress/” with the « s» modifier in the « driver_pgsql.php » file but this had no effect on these errors.
Is anyone able to fix these errors?
Thanks for reading my comment.