PostgreSQL

Baseline: main 23.900.900+ (first PostgreSQL-capable main) · Verified: main 26.800.0, perfmon 25.300.0

Licensed as Bitrix24 / CMS "Enterprise for Postgres". Connection class \Bitrix\Main\DB\PgsqlConnection; the rest of connections is as in bitrix-database.

Before migrating

1. Current license must cover the test period (up to 6 months) and the switch. The Postgres license gives a coupon (activate after testing) and a key for a separate test copy; production stays on MySQL meanwhile.
2. perfmon 24.0.0+, site in UTF-8, the latest updates on the test copy.
3. Rehearse on a copy of production; going back to MySQL afterwards is manual work.
4. Close the site during the final copy.

Wizard perfmon.pgsql (Settings → Wizards)

• Step 0 lists installed modules that ship install/mysql (or install/db/mysql) without the pgsql twin and blocks until you uninstall them. With the dev flag file bitrix/modules/perfmon/dev it only warns and removes them from b_module in the target DB after copying (their tables stay).
• It checks /bitrix/modules/* only. /local/modules and modules without SQL install files (install/migrations) are never checked: audit them yourself.
• It asks for an extra default_pgsql connection in .settings.php, copies the tables, then you switch default.
• Manual (CLI) migration: find unsupported modules with