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 | sudo apt-key add –
# sh -c ‘echo “deb pgadmin4 main” (угловая скобка) /etc/apt/sources.list.d/pgadmin4.list’
# apt update
# apt install -y pgadmin4-web
# /usr/pgadmin4/bin/setup-web.sh
——————————————————————————————–
replica
# sudo -u postgres psql
/usr/lib/postgresql/12/bin/pg_ctl promote -D /var/lib/postgresql/12/main
[ad_2]
source
-
-
-
-
