This documentation is for a version that has reached its End Of Life. Such versions are no longer supported and don't receive security updates. Consider updating to a newer version.
Databases¶
Using PostgreSQL¶
eZ Platform uses MySQL by default, but you can also choose to install it with PostgreSQL.
Requirements¶
To use PostgreSQL, you need to have the pdo_pgsql PHP extension installed.
Make sure you have the ezsystems/doctrine-dbal-schema Composer package installed
and EzSystems\DoctrineSchemaBundle\DoctrineSchemaBundle() enabled.
If not, install the package with composer require ezsystems/doctrine-dbal-schema
and enable DoctrineSchemaBundle in AppKernel.php.
Provide parameters¶
When you run composer install, you will be asked to provide installation parameters.
If you use PostgreSQL, two parameters need to be set differently than when using MySQL:
env(DATABASE_DRIVER)must be set topdo_pgsqlinstead of the defaultpdo_mysqlenv(DATABASE_CHARSET)must be set toutf8, because the default value ofutf8mb4is MySQL-specific.
The rest of the installation procedure is the same as when using MySQL.