Azure PostgreSQL
This topic allows you to 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
Before you begin, ensure the following prerequisites are met:
- Create a privacera_db database in the Azure PostgreSQL server that can be accessible.
CLI Configuration
-
SSH to the instance where Privacera is installed.
-
Run the following command.
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
-
In this file set values for the following:
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"
Enter the credentials of the user who has access to the database.
EXTERNAL_DB_USER: "<PLEASE_CHANGE>" EXTERNAL_DB_PASSWORD: "<PLEASE_CHANGE>"
(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
-
Login to Privacera portal.
-
Go to Access Management > Resource Policies. You should be able to see the Postgres service.