18 lines
702 B
SQL
18 lines
702 B
SQL
\set pgpass `echo "$PGPASSWORD"`
|
|
\set jwt_secret `echo "$JWT_SECRET"`
|
|
\set jwt_exp `echo "$JWT_EXP"`
|
|
|
|
ALTER DATABASE postgres SET "app.settings.jwt_secret" TO :'jwt_secret';
|
|
ALTER DATABASE postgres SET "app.settings.jwt_exp" TO :'jwt_exp';
|
|
|
|
ALTER USER postgres WITH PASSWORD :'pgpass';
|
|
ALTER USER authenticator WITH PASSWORD :'pgpass';
|
|
ALTER USER pgbouncer WITH PASSWORD :'pgpass';
|
|
ALTER USER supabase_auth_admin WITH PASSWORD :'pgpass';
|
|
ALTER USER supabase_storage_admin WITH PASSWORD :'pgpass';
|
|
ALTER USER supabase_replication_admin WITH PASSWORD :'pgpass';
|
|
ALTER USER supabase_read_only_user WITH PASSWORD :'pgpass';
|
|
|
|
create schema if not exists _realtime;
|
|
alter schema _realtime owner to postgres;
|