Holds user notifications and system messages, including the read and seen state the DE displays.

Create¶

Connect as a superuser on the host running PostgreSQL:

psql -h <DATABASE_HOST> -U postgres

-- as a superuser; owned by the de role
create database notifications with owner de;

Extensions¶

\c notifications
create extension "uuid-ossp";
create extension "moddatetime";
create extension "btree_gist";

Populate and migrate¶

Schema and data come from de-database, applied with the shared procedure in database migrations. In a normal deployment the setup-databases and update-databases Ansible tags do this for you.

Related¶

• PostgreSQL
• Database migrations
• Service databases