Holds Grouper's groups, folders, and memberships — the data the DE authorizes against.

Create¶

Connect as a superuser on the host running PostgreSQL:

psql -h <DATABASE_HOST> -U postgres

-- as a superuser
create user grouper with password '<GENERATED_SECRET>';
create database grouper with owner grouper;

Extensions¶

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

Migrations¶

Grouper manages its own schema through its installer (gsh / the Grouper installer image) rather than through golang-migrate. Run the schema step from the Grouper distribution before starting grouper-loader; see Grouper deployment.

Related¶

• PostgreSQL
• Database migrations
• Service databases