...
When a node is joined to the cluster it generates a configfile at '/var/lib/postgresql/9.613/main/recoverypostgresql.auto.conf' which makes this database server connect to that host everytime it starts.
...
Code Block | ||||
---|---|---|---|---|
| ||||
root@pgsql1:~# touch /var/lib/postgresql/9.613/main/triggerfile root@pgsql1:~# sudo -u postgres -i psql postgres=# ALTER SYSTEM RESET primary_conninfo; ALTER SYSTEM postgres=# ALTER SYSTEM RESET promote_trigger_file; ALTER SYSTEM postgres=# SELECT pg_reload_conf(); pg_reload_conf ---------------- t (1 row) |
Make other slaves follow the new master
...