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