-- Альма линукс
ssh aeugene@158.160.16.46

-- https://www.hostinger.com/tutorials/how-to-install-postgresql-on-centos-7/
-- 12 PostgreSQL
sudo yum update -y && sudo yum upgrade -y && sudo yum install -y https://download.postgresql.org/pub/repos/yum/reporpms/EL-7-x86_64/pgdg-redhat-repo-latest.noarch.rpm && sudo yum install -y postgresql12-server

yum list available | grep postgres

rpm -qi pgdg-redhat-repo

sudo dnf -y install postgresql12 postgresql12-server
-- а потому что сентос8 ...


sudo yum -y install https://download.postgresql.org/pub/repos/yum/reporpms/EL-8-x86_64/pgdg-redhat-repo-latest.noarch.rpm
sudo dnf -qy module disable postgresql
sudo dnf -y install postgresql12 postgresql12-server

-- Initialize the database:
sudo /usr/pgsql-12/bin/postgresql-12-setup initdb

-- launch PostgreSQL
sudo systemctl start postgresql-12

--Enable PostgreSQL Launch on Reboot
sudo systemctl enable postgresql-12

-- посмотрим, что кластер стартовал
/usr/pgsql-12/bin/pg_ctl status
/usr/pgsql-12/bin/pg_ctl --help

sudo -u postgres psql

show hba_file;
-- /var/lib/pgsql/12/data/pg_hba.conf
show config_file;
-- /var/lib/pgsql/12/data/postgresql.conf
show data_directory;
-- /var/lib/pgsql/12/data

sudo su postgres
/usr/pgsql-12/bin/pg_ctl status -D /var/lib/pgsql/12/data

-- uncomment listen_addresses = '*'
sudo yum install nano -y
sudo nano /var/lib/pgsql/12/data/postgresql.conf

-- host    replication             repuser             0.0.0.0/0               md5/scram-sha-256
-- not ident!
sudo nano /var/lib/pgsql/12/data/pg_hba.conf

-- для репликации желательно создать отдельного юзера
sudo -u postgres createuser -U postgres repuser -c 5 --replication
-- change password
sudo -u postgres psql
ALTER USER repuser PASSWORD 'test$123';

sudo su postgres
/usr/pgsql-12/bin/pg_ctl restart -D /var/lib/pgsql/12/data


-- VM alma2
ssh aeugene@158.160.22.102
sudo yum -y install https://download.postgresql.org/pub/repos/yum/reporpms/EL-8-x86_64/pgdg-redhat-repo-latest.noarch.rpm && sudo dnf -qy module disable postgresql && sudo dnf -y install postgresql12 postgresql12-server


-- настроим репликацию

sudo /usr/pgsql-12/bin/postgresql-12-setup initdb
sudo rm -rf /var/lib/pgsql/12/data

sudo su postgres
cd ~
pg_basebackup -h 158.160.16.46 -p 5432 -U repuser -R -D /var/lib/pgsql/12/data
-- Стартуем кластер
/usr/pgsql-12/bin/pg_ctl start -D /var/lib/pgsql/12/data
sudo systemctl start postgresql-12


-- pg_top
-- https://installati.one/centos/8/pg_top/
sudo yum install pg_top