05.01. Creating PostgreSQL Database Users

                                                    <<< Back   Next >>>

!!! 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 '***';

                                                    <<< Back   Next >>>