12 lines
393 B
SQL
12 lines
393 B
SQL
CREATE USER chatwoot CREATEDB;
|
|
ALTER USER chatwoot PASSWORD 'REPLACE_WITH_PASSWORD';
|
|
ALTER ROLE chatwoot SUPERUSER;
|
|
|
|
UPDATE pg_database SET datistemplate = FALSE WHERE datname = 'template1';
|
|
DROP DATABASE template1;
|
|
CREATE DATABASE template1 WITH TEMPLATE = template0 ENCODING = 'UNICODE';
|
|
UPDATE pg_database SET datistemplate = TRUE WHERE datname = 'template1';
|
|
|
|
\c template1;
|
|
VACUUM FREEZE;
|