Expand Minimize Picture-in-picture Power Device Status Voice Recognition Skip Back Skip Forward Minus Plus Play Search
Documentation
Sidebar

PostgreSQL

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

Migrations

All scripts for the intial 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.

View on GitHub.com
Previous Section