3

Is there a version of CiviCRM that's compatible with Postgres and Wordpress?

  • Are you looking to run Civi-on-Postgres -- or to integrate Civi with (WordPress-on-Postgres). Although Civi puts its own tables in MySQL, it should be agnostic about the WordPress tables (modulo a few small patches/workarounds). – Tim Otten Sep 12 '15 at 18:44
3

No.

CiviCRM uses MySQL functions extensively, so it can't be run with PostgreSQL.

This has been raised before over on forum.civicrm.org (at least in 2010 and 2007). Tim Otten's answer in this forum post may also help understand some of the workings currently in the DB layer (and specific to MySQL).

It could (in theory) be done, but it would take significant effort and leadership from the community who wanted to make it happen.

  • On reflection I feel confident those mysqlisms could be implemented in pg - but you'd have a high maintenance undertaking, and a small group of users to start with. – Chris Burgess Sep 11 '15 at 18:21
  • It's a relatively new project, but it seems to me that over the long haul it would be of great benefit to the users to have PostgreSQL as an option for CiviCRM, simply because of how much data PostgreSQL can hold. – leeand00 Sep 11 '15 at 18:52
  • I agree - I'm not a big fan of CiviCRM's MySQLism, but it's the status quo. Similar to the situation on WordPress, but with a much larger codebase and smaller pool of organisations to fund the work. – Chris Burgess Sep 11 '15 at 20:11
  • If DB size limits are your concern, it's likely to be less work for you to contribute towards optimising CiviCRM on MySQL. MySQL can also handle significant data sets. – Chris Burgess Sep 11 '15 at 20:12
  • 2
    I know a developer who's been working toward this as a side-project, although he hasn't published anything. If anyone is looking to collaborate on or fund such a project, email info-at-civicrm.org and I'll put you in touch. – Tim Otten Sep 12 '15 at 18:29

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.