News for hackers. Stuff that matters.
Re:Our Journey to PostgreSQL 12 by craigkerstiens on Monday January 25, 2021 @09:37PM (#25911767)
It's really a question of how many replicas you have, if you're running with sync rep or not, and what your DR story is like. We've tested it before a few times at previous employers and are exploring it rolling it out for Crunchy Bridge currently. The NVMe storage is really nice it's great performance and the price balance of it is good as well. But it does come with nuances... I wouldn't let a user provision without HA for example. In cases for a standard app without crazy uptime requirements having a standby or 2 is wasted cash. So it isn't for everyone, but can be for some people.
Re:Our Journey to PostgreSQL 12 by snissn on Tuesday January 26, 2021 @01:12AM (#25913093)
hi! Can you share how you do HA on postgres? Master/slave with monitoring and manual fall over or is that automatic? If so reliable? What tooling do you use? Thanks!