Postgresql Master Replica PgAdmin4 на Ubuntu20.04

Для пожертвований на развитие канала
https://w.qiwi.com/n/SIMFF001

master
# apt install postgresql postgresql-contrib -y
# pg_isready
# sudo -u postgres psql
postgres=# \password postgres
# nano /etc/postgresql/12/main/postgresql.conf
listen_addresses = '*'
wal_level = hot_standby
archive_mode = on
archive_command = 'cd .'
max_wal_senders = 8
hot_standby = on
# nano /etc/postgresql/12/main/pg_hba.conf
host all all 192.168.1.0/24 md5
host replication postgres REPLICA_IP/32 md5
# service postgresql restart
-------------------------------------------------------------------------------------------
replica
# apt install postgresql postgresql-contrib -y
# pg_isready
# sudo -u postgres psql
postgres=# \password postgres
# service postgresql stop
# nano /etc/postgresql/12/main/pg_hba.conf
host all all 192.168.1.0/24 md5
host replication postgres MASTER_IP/32 md5
# nano /etc/postgresql/12/main/postgresql.conf
listen_addresses = '*'
wal_level = hot_standby
archive_mode = on
archive_command = 'cd .'
max_wal_senders = 8
hot_standby = on
# su - postgres
# cd /var/lib/postgresql/12/
# rm -rf main; mkdir main; chmod go-rwx main
# pg_basebackup -P -R -X stream -c fast -h MASTER_IP -U postgres -D ./main
# service postgresql start
--------------------------------------------------------------------------------------------
master
# apt install curl -y
# curl https://www.pgadmin.org/static/packages_pgadmin_org.pub | sudo apt-key add -
# sh -c 'echo "deb https://ftp.postgresql.org/pub/pgadmin/pgadmin4/apt/focal pgadmin4 main" (угловая скобка) /etc/apt/sources.list.d/pgadmin4.list'
# apt update
# apt install -y pgadmin4-web
# /usr/pgadmin4/bin/setup-web.sh
http://192.168.1.141/pgadmin4/
--------------------------------------------------------------------------------------------
replica
# sudo -u postgres psql
/usr/lib/postgresql/12/bin/pg_ctl promote -D /var/lib/postgresql/12/main

Видео Postgresql Master Replica PgAdmin4 на Ubuntu20.04 канала Funny System Administration by Alexey Simonov