As the title suggests I’m very confused by what’s going on with Fly Postgres.
I’ve just tried to set up a new cluster and it appears that the entire stack for how fly Postgres is managed has been changed without warning or documentation?
It appears like stolon has been dropped in favour of repmgr – not a good move after investing time into getting familiar with stolon.
WAL-G support now appears to be missing from the image so now PITR exports don’t work.
What’s going on with this, how do I deploy a usable Postgres cluster now?
March 23, 2023, 11:06am
@LeoAdamek you can read about reasons behind switching to repmgr here:
What’s this about?
Over the last year, we have been seeing more and more Postgres apps go down due to unstable connections with our multi-tenant Consul service. Stolon, the open-source solution that we have been using for HA management requires an always-stable connection with our Consul. The issue is when that connection becomes unstable, PG’s start becoming unaccessible. We have been pretty disappointed with how this has impacting our users and decided it was time to try a new approach.
It’s no longer a preview, it’s the new default
Well it certainly wasn’t communicated very well that the underlying tools have changed. But what about WALG? That doesn’t seem to be set up on the new images, which is required for a production database.
Ah, I see Wal-G isn’t yet supported. Too-right that its a deal-breaker though. Should never have been promoted from preview without WALG support IMHO.
March 23, 2023, 4:20pm
@LeoAdamek The move was made for reliability purposes, which is expressed in the post above. There are not many users who actually use WAL-G, so it would be unreasonable for us to hold back the transition for that reason alone. At the same time, we will continue to offer
stolon as an option at provision time for those of you who rely on it. I hope that makes sense.
Ok understood, I thought wal-g would be much more widely used.
I guess for now I can manage snapshots using
pg_dumpall. What’s the recommendation for PITR though, or is there simply nothing available to export WALs?
March 31, 2023, 10:58am
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.