10.200.1.61 edozvola-db-01
10.200.1.62 edozvola-db-02
-If installing on existing streaming replication you will need to tell pgpool where current master is with:
-
-echo 0 > /tmp/postgres_master
-
-You can also force re-check of nodes by removing status file and restarting pgool:
-
-rm /var/log/pgpool_status
-systemctl restart pgpool
-
Deployment script ./t/0-init-cluster.sh assumes that machine from which it's run is 10.200.1.1 which is added
in pg_hba.conf as authorized to be able to deploy cluster. You can run it with:
This will destroy all databases on all nodes, archive logs, etc, so don't do this if you need your old data later.
-You can also edit all local files and push them to all nodes using:
+On the other hand this will also create setup whole cluster, and you can examine it's status using:
+
+make
+
+If you edited local files, push changes to all nodes using:
make push
make restart
+If you want to see systemd status of pgpool and replication just type:
+
+make status
+
+
+
+If installing on existing streaming replication you will need to tell pgpool where current master is with:
+
+echo 0 > /tmp/postgres_master
+
+You can also force re-check of nodes by removing status file and restarting pgool:
+
+rm /var/log/pgpool_status
+systemctl restart pgpool
+
Requirements
============