Configuring a PostgreSQL database for AR System installation

Remedy supports case-sensitive PostgreSQL 10 database. The PostgreSQL support is available only for fresh installations of Remedy done through silent installation on the supported Linux platforms. For a list of supported Linux platforms and versions, see  BMC Solution and product availability and compatibility utility (SPAC) .

You must configure your PostgreSQL database before you install the Remedy platform or any application in Remedy IT Service Management (ITSM) Suite.

You can install PostgreSQL database on the same computer where Remedy AR System server is installed, or on a remote server that is connected to the computer on which you plan to install Remedy AR System server. Remedy AR System server uses JDBC to connect to remote\local database.

To prepare your PostgreSQL database

1. As a database administrator, install at least one instance of the PostgreSQL database. For more information, see PostgreSQL documentation.

2. Update the pg_hba.conf file.
   The pg_hba.conf file stores the client authentication information. Perform the following steps to modify the IP address and password-based authentication method in the local and host records:

   1. Open the pg_hba.conf file by using the following command:

      #vi /var/lib/pgsql/10/data/pg_hba.conf

   2. Update the local and host records to use md5 authentication, as follows: 

      local all all md5
      host all all 0.0.0.0/0 md5

      Do not delete the remaining records in the pg_hba.conf file. You must manually update these values and not copy the values from here.

      Note

      If you do not update password-based authentication to md5, the AR System server installation and tenant creation will fail.
      The value 0.0.0.0/0 opens PostgreSQL for all incoming traffic. Consult your PostgreSQL administrator and update this parameter to configure incoming connections that you want to allow for the PostgreSQL instance.

3. Update the postgresql.conf file:

   1. Open the postgresql.conf file by using the following command:

      #vi /var/lib/pgsql/10/data/postgresql.conf

   2. Uncomment and update the listen_addresses = 'localhost' parameter as follows:
      

      listen_addresses = '*'

   3. Uncomment and update the password_encryption parameter as follows:

      password_encryption = md5

   4. (Optional) Update the max_connections parameter and specify the maximum number of connections that PostgreSQL must accept.

   5. Stop the PostgreSQL server and restart it by using the following commands:
      

      #service postgresql-10 stop
      #service postgresql-10 start

To create a PostgreSQL database and a user for Remedy AR System

Perform the following steps to create a PostgreSQL database and user for Remedy AR System.

1. Log in as a root user and switch to the PostgreSQL account:

   su - postgres

2. Run the following command and then type your PostgreSQL password:

   psql

3. Create a user ARAdmin by using the following command:

   CREATE ROLE "ARAdmin" LOGIN PASSWORD 'AR#Admin#' NOSUPERUSER INHERIT CREATEDB CREATEROLE NOREPLICATION;

4. Create a database ARSystem by using the following command: 
   

   CREATE DATABASE "ARSystem" ENCODING = 'UTF8' CONNECTION LIMIT = -1;

5. Create a dblink extension for the AR System database by using the following command:
   

   CREATE EXTENSION dblink SCHEMA ARSystem;

6. Provide access to the user on the database:
   

   GRANT ALL PRIVILEGES ON DATABASE "ARSystem" TO "ARAdmin"; 

7. Exit from the PostgreSQL prompt.

8. Navigate to the AR System server installation directory and run the following command:

   ./setup.bin -i silent -DOPTIONS_FILE=/path/to/ARSystem-ini-template.txt -Dbmc.install.BMC_ENABLE_PSQL=true

Where to go from here