2 SET application_name="container_setup";
4 CREATE EXTENSION IF NOT EXISTS pg_stat_statements;
5 CREATE EXTENSION IF NOT EXISTS pgaudit;
7 ALTER USER postgres PASSWORD '${PG_ROOT_PASSWORD}';
9 CREATE USER ${PG_PRIMARY_USER} WITH REPLICATION;
10 ALTER USER ${PG_PRIMARY_USER} PASSWORD '${PG_PRIMARY_PASSWORD}';
12 CREATE USER "${PG_USER}" LOGIN;
13 ALTER USER "${PG_USER}" PASSWORD '${PG_PASSWORD}';
15 CREATE DATABASE ${PG_DATABASE};
16 GRANT ALL PRIVILEGES ON DATABASE ${PG_DATABASE} TO "${PG_USER}";
18 CREATE TABLE IF NOT EXISTS primarytable (key varchar(20), value varchar(20));
19 GRANT ALL ON primarytable TO ${PG_PRIMARY_USER};
25 CREATE EXTENSION IF NOT EXISTS pg_stat_statements;
26 CREATE EXTENSION IF NOT EXISTS pgaudit;
28 --- Verify permissions via PG_USER
30 \c ${PG_DATABASE} "${PG_USER}";
32 CREATE SCHEMA IF NOT EXISTS "${PG_USER}";
34 CREATE TABLE IF NOT EXISTS "${PG_USER}".testtable (
35 name varchar(30) PRIMARY KEY,
36 value varchar(50) NOT NULL,
37 updatedt timestamp NOT NULL
40 INSERT INTO "${PG_USER}".testtable (name, value, updatedt) VALUES ('CPU', '256', now());