Sicura Logo


This article provides instructions for installing and configuring PostgreSQL and creating a user and database for Sicura Console.


Install and Configure PostgreSQL

Skip this section if you already have a production PostgreSQL server available in your environment.

Follow the instructions below to configure a PostgreSQL database server to host a database for the Console.

  1. Install PostgreSQL.

     yum -y install postgresql-server
  2. Initialize the database.

     postgresql-setup initdb
  3. Enable password authentication for localhost.

    This is only necessary if running PostgreSQL on the same system as the Console service.

     sed -i \
    -e '/^host\s*all\s*all\s*[0-9:./]*\s*ident$/ s|ident|md5|' \
  4. Enable and start the database service.

     systemctl enable postgresql --now

Create and configure a user and database for Sicura Console.

In the example below, we’re connecting to a local installation of PostgreSQL and using sicura_console for both the database name and the user name. Replace the string REPLACE_ME below with a password generated for the sicura_console database user.

runuser -l postgres -c "psql" <<END
create database sicura_console;
create user sicura_console with encrypted password 'REPLACE_ME';
grant all privileges on database sicura_console to sicura_console;