I would like to set up a Drupal site using postgresql. After reading through the forums it appears that support for postgres lags behind mysql. furthermore many of the modules I require do not include postgres schemas: mailhandler, filestore2, fscache, mime_registry.
Can anyone comment on the postgres support for these modules: mailhandler, filestore2, fscache, mime_registry? Has anyone successfully implemented these running postgres?
generally speaking, is it simply a matter of creating the appropriate tables in postgres for modules, or do some modules use mysql specific functions that render them incompatible (or require a fair amount of modification) with postgres? to what degree is there a layer of independence between databases?
tia, Michael
Comments
Hey there ..
I am the postgres maintainer.
You should only need to design the schema for 99% of the modules. Most of them don't get too many complex queries, but you will have to do a fair amount of testing to figure out if it is correct.
Even just keeping Core tested, and working with postgresql is a lot of work, so my postgres maintainership unfortunately does not always extend to contrib.
--
The future is so Bryght, I have to wear shades.