Important

You are browsing upcoming documentation for version 6.0 of OroCommerce, OroCRM, and OroPlatform, scheduled for release in 2024. Read version 5.1 (the latest LTS version) of the Oro documentation to get up-to-date information.

See our Release Process documentation for more information on the currently supported and upcoming releases.

Prepare PostgreSQL Database 

Initialize a PostgreSQL Database Cluster 

postgresql-setup --initdb

Enable Password Protected PostgreSQL Authentication 

By default, PostgreSQL is configured to use ident authentication.

To use the password-based authentication instead, replace the ident with the md5 in the pg_hba.conf file.

Open the file /var/lib/pgsql/data/pg_hba.conf and change the following strings:

host    all             all             127.0.0.1/32            ident
host    all             all             ::1/128                 ident

to match these ones:

host    all             all             127.0.0.1/32            md5
host    all             all             ::1/128                 md5

Change the Password for the postgres User 

To set the password for the postgres user to the new secure one, run the following commands:

systemctl start postgresql
su postgres
psql
\password

Note

You will be prompted to enter the new password.

Create a Database for the Oro Application 

To create the oro database that will be used by the Oro application, run the following commands:

CREATE DATABASE oro;
\c oro
CREATE EXTENSION IF NOT EXISTS "uuid-ossp";
\q