I needed a way to refresh a postgres logical replication subscription on many hosts. I decided to write a python script to achieve this, it reads in a list of hostnames and executes the refresh against each host. The subscription names are part of the host name name and I have a master server that … Continue reading Postgres Refresh Logical Replication Subscription From Publisher On Multiple Hosts