This wiki documents PostgreSQL support in Mautic 7.x (reintroduced via a minimal compatibility layer + platform abstraction). The fork maintains full backward compatibility with existing MySQL/MariaDB installations.

Current status (June 2026):
Testing / pre-release stage on branch 7.x-postgresql. Core functionality, installer, segments, campaigns, reports, and most plugins work on both PostgreSQL and MySQL/MariaDB. Automated tests run against both platforms.

Official upstream progress: Proposal accepted. Draft PR #15926 is open for review.

1. Go to Releases.
2. Download the latest 7.x-postgresql package (e.g. 7.2.0-postgresql-rc).
3. Extract to your web server and run the installer → select PostgreSQL.

git clone -b 7.x-postgresql https://github.com/wieslawgolec/mautic.git
cd mautic
composer install --no-dev

Then use the web installer (PostgreSQL option) or CLI setup.

• Zero breaking changes for MySQL/MariaDB users.
• Compatibility layer: ~25 shim functions/operators on PostgreSQL (DATE_FORMAT, IFNULL, CONCAT_WS, etc.).
• Central abstraction: Mautic\CoreBundle\Doctrine\DatabasePlatform with helpers for queries, dates, upserts, regex, etc.
• Patches: Automatic via Composer (Doctrine DBAL adjustments, PHP 8.5 driver, indexes).
• Installer support: Full web + CLI installer for PostgreSQL.
• Testing: GitHub Actions with PostgreSQL service; all tests pass on both DBs.

• PostgreSQL Installation
• Compatibility & Platform Abstraction
• Query Portability
• DatabasePlatform Helpers

1. Test on PostgreSQL and report issues.
2. Submit PRs to this fork or the upstream draft PR.
3. Plugin developers: Use DatabasePlatform helpers for best compatibility.

Clone this wiki

git clone https://github.com/wieslawgolec/mautic.wiki.git

Last major update: June 2026 Feedback and testing reports are welcome — see Releases and the upstream PR.