@greg I was thinking about the most simple, low-tech, and stable solution for updating postgres the master address, and my last idea was:
- Configure clients to use a hostname instead of IP address for the master connection (the obvious first step)
- Write a script (maybe just postgres client Chef recipe), which simply updates an
/etc/hostsentry on all postgres client VMs
This way, we don't need our own DNS server at all, and there's no extra connection or caching to think about. WDYT?
Just a quick status update: the log file is still empty, and the two nodes are still connected.
Not entirely related to the cluster disconnects, but also about disconnects:
wormhole is getting disconnected exactly every hour, on the second sharp, from when it connects to XMPP. Eventually, it fails to re-join MUC rooms then, but without an error or event on the client side. (At least not visible in the wormhole logs.)
The session should keep for 24 hours, so I'm wondering if there's an error in that config somewhere.
4ca875a77b
Merge pull request 'Create postgres-1 VM' (#281) from feature/280-postgres_vm into master
I just added another commit, where I have rewritten the recipe to not use the deprecated application_javascript resource anymore, and which also uses the systemd_unit Chef resource.