Backs the quota management service: subscription plans, resource quotas, and recorded usage.
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 qms with owner de;
Extensions¶
\c qms
create extension "uuid-ossp";
create extension "moddatetime";
create extension "btree_gist";
create extension "insert_username";
Populate and migrate¶
Schema and data come from QMS (prod branch), applied with the shared procedure in
database migrations. In a normal deployment the
setup-databases and update-databases Ansible tags do this for you.
Connect to the right database first
Older notes run \c de before creating these extensions, which installs them
into the DE database and leaves qms without them. The subsequent migration
then fails on a missing function. Connect to qms, as above.