Skip to content

Databases

Using PostgreSQL

Ibexa DXP 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.

Tip

It is recommended to store the database credentials in your .env.local file and not commit it to the Version Control System.

If you use PostgreSQL, the following parameters need to be set differently in the .env.local file than when using MySQL:

  • DATABASE_NAME
  • DATABASE_HOST
  • DATABASE_PORT
  • DATABASE_PLATFORM must be set to pgsql instead of mysql
  • DATABASE_DRIVER must be set to pdo_pgsql instead of the default pdo_mysql
  • DATABASE_VERSION
  • DATABASE_CHARSET must be set to utf8, because the default value of utf8mb4 is MySQL-specific.

The rest of the installation procedure is the same as when using MySQL.