PostgreSQL

The Policy Server uses a PostgreSql database to store, retrieve, and update information.

Migrations

All scripts for the initial data migration are located in the migrations folder. The scripts necessary to build or reset the database are found there. Ensure that your policy server has been updated to have the latest migrations. If new migrations exist, they will be run on startup.

Database Alterations

Any action that generates newly created or updated data, such as modifying a consumer message, will first generate a SQL statement to execute the desired query. The Policy Server generates these statements with the npm module sql-bricks-postgres.