!!! To be executed on each master server of the cluster !!!
master-server cluster #1:***************************
- db-pgsql01.oracak.ru - master
master-server cluster #2:
***************************
- db-pgsql03.oracak.ru - master
1. Execute the creation of application users as per the list
- ggadmin
- cron_tech
- stock
1.1. Execute on db-pgsql01
- db-pgsql01.oracak.ru - master
[postgres] $> psql
\c dbquik1
create database dbquik1;
alter database dbquik1 owner to stock;
create user ggadmin with password '***';
create user cron_tech with password '***';
create user stock with password '***';
1.2. Execute on db-pgsql03
- db-pgsql03.oracak.ru - master
[postgres] $> psql
\c dbquik2
create database dbquik2;
alter database dbquik2 owner to stock;
create user ggadmin with password '***';
create user cron_tech with password '***';
create user stock with password '***';