Skip to main content

Privacera Documentation

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.