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