Postgresql Master Replica PgAdmin4 на Ubuntu20.04

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