1 PRIMARY=$(shell ./t/99-primary-ip.sh)
5 PAGER= psql -h 10.200.1.60 -c 'show pool_nodes' postgres postgres
6 PAGER= psql -h $(PRIMARY) -c 'SELECT * from pg_stat_replication' postgres postgres
9 sh -xe ./t/0-ssh-deploy.sh
10 sh -xe ./t/1-init-cluster.sh
15 scp root@10.200.1.60:/etc/pgpool-II/pgpool.conf .
16 scp root@10.200.1.60:/etc/pgpool-II/failover.sh .
17 scp root@10.200.1.60:/etc/pgpool-II/online-recovery.sh .
19 scp root@10.200.1.61:/var/lib/pgsql/streaming-replication.sh .
20 scp root@10.200.1.61:/var/lib/pgsql/9.6/data/postgresql.conf.master .
21 scp root@10.200.1.61:/var/lib/pgsql/9.6/data/postgresql.conf.slave .
22 scp root@10.200.1.61:/var/lib/pgsql/9.6/data/recovery.conf .
24 push: push-pg push-pgpool
27 # replace names in config with real ones
28 cat pgpool.conf | sed -e 's/__HOSTNAME__THIS__/edozvola-db-01/' -e 's/__HOSTNAME__OTHER__/edozvola-db-02/' > /tmp/pgpool.conf
29 scp /tmp/pgpool.conf failover.sh online-recovery.sh root@10.200.1.61:/etc/pgpool-II/
31 cat pgpool.conf | sed -e 's/__HOSTNAME__THIS__/edozvola-db-02/' -e 's/__HOSTNAME__OTHER__/edozvola-db-01/' > /tmp/pgpool.conf
32 scp /tmp/pgpool.conf failover.sh online-recovery.sh root@10.200.1.62:/etc/pgpool-II/
35 scp streaming-replication.sh root@10.200.1.61:/var/lib/pgsql/
36 scp postgresql.conf.master postgresql.conf.slave recovery.done pg_hba.conf root@10.200.1.61:/var/lib/pgsql/9.6/data/
37 ssh root@10.200.1.61 chown -R postgres:postgres /var/lib/pgsql/9.6/data/
38 scp sudoers.d/postgres root@10.200.1.61:/etc/sudoers.d/
40 #ssh root@10.200.1.61 ln -sf /var/lib/pgsql/9.6/data/postgresql.conf.master /var/lib/pgsql/9.6/data/postgresql.conf
43 scp streaming-replication.sh root@10.200.1.62:/var/lib/pgsql/
44 scp postgresql.conf.master postgresql.conf.slave recovery.conf pg_hba.conf root@10.200.1.62:/var/lib/pgsql/9.6/data/
45 ssh root@10.200.1.62 chown -R postgres:postgres /var/lib/pgsql/9.6/data/
46 scp sudoers.d/postgres root@10.200.1.62:/etc/sudoers.d/
48 #ssh root@10.200.1.62 ln -sf /var/lib/pgsql/9.6/data/postgresql.conf.slave /var/lib/pgsql/9.6/data/postgresql.conf
51 #ssh root@10.200.1.61 systemctl restart postgresql-9.6
52 #ssh root@10.200.1.62 systemctl restart postgresql-9.6
53 ssh root@10.200.1.61 rm /var/log/pgpool/pgpool_status
54 ssh root@10.200.1.61 systemctl restart pgpool
55 ssh root@10.200.1.62 rm /var/log/pgpool/pgpool_status
56 ssh root@10.200.1.62 systemctl restart pgpool
59 ssh root@10.200.1.61 systemctl status pgpool
60 ssh root@10.200.1.62 systemctl status pgpool
61 ssh root@10.200.1.61 systemctl status postgresql-9.6
62 ssh root@10.200.1.62 systemctl status postgresql-9.6
65 ssh root@10.200.1.60 /etc/pgpool-II/online-recovery.sh