Skip to main content

Privacera Documentation

Table of ContentsTable of Contents

Configure Azure PostgreSQL on Privacera Platform

You can connect to an Azure PostgreSQL server from the Azure virtual machine which will act as a storage for Ranger database and Privacera database (optional).

Prerequisites

Ensure the following prerequisite are met:

  • Create a privacera_db database in the Azure PostgreSQL server that can be accessible.

Procedure

To configure Azure PostgreSQL on Privacera Platform:

  1. SSH to the instance where Privacera is installed.

  2. Run the following commands:

    cd ~/privacera/privacera-manage
cp config/sample-vars/vars.external.db.yml config/custom-vars/
cp config/sample-vars/vars.external.db.postgres.yml config/custom-vars/
vi config/custom-vars/vars.external.db.postgres.yml

  3. Enter the hostname of the Azure PostgreSQL server and the name of the database you want to connect to:

    EXTERNAL_DB_HOST: "<PLEASE_CHANGE>"
EXTERNAL_DB_NAME: "privacera_db"

  4. Enter the credentials of the user who has access to the database:

    EXTERNAL_DB_USER: "<PLEASE_CHANGE>"
EXTERNAL_DB_PASSWORD: "<PLEASE_CHANGE>"

  5. (Optional) Enter a database name for Privacera Portal, Privacera Ranger, and Privacera Ranger KMS. It is recommended to provide different names for the 3 databases.

    PRIVACERA_PORTAL_DB_NAME: "{{EXTERNAL_DB_NAME}}"
PRIVACERA_RANGER_DB_NAME: "{{EXTERNAL_DB_NAME}}"
PRIVACERA_RANGER_KMS_DB_NAME: "{{EXTERNAL_DB_NAME}}"
Validation

  1. Log in to the Privacera portal.

  2. Go to Access Management > Resource Policies.

    You will now see the Postgres service.