1-- Create extensions and types.
2create extension hstore;
3create extension ltree;
4create domain uint64 as numeric(20,0);
5
6-- Create users for different types of connections and authentication.
7create user pgx_ssl with superuser PASSWORD 'secret';
8create user pgx_sslcert with superuser PASSWORD 'secret';
9set password_encryption = md5;
10create user pgx_md5 with superuser PASSWORD 'secret';
11set password_encryption = 'scram-sha-256';
12create user pgx_pw with superuser PASSWORD 'secret';
13create user pgx_scram with superuser PASSWORD 'secret';
14\set whoami `whoami`
15create user :whoami with superuser; -- unix domain socket user
16
17
18-- The tricky test user, below, has to actually exist so that it can be used in a test
19-- of aclitem formatting. It turns out aclitems cannot contain non-existing users/roles.
20create user " tricky, ' } "" \\ test user " superuser password 'secret';
View as plain text