News for hackers. Stuff that matters.
Re:Index bloat reduced in PostgreSQL v14 by eloff on Saturday September 11, 2021 @12:47AM (#28489501)
Postgres doesn't support synchronous replication yet? It's had it since 9.1.

I think you're referring to something else.

Re:Index bloat reduced in PostgreSQL v14 by pezezin on Saturday September 11, 2021 @10:29AM (#28492243)
PostgreSQL has master-slave replication (one read/write master, and multiple read-only standbys), the other users are talking about multi-master replication (all the databases are read/write).
Re:Index bloat reduced in PostgreSQL v14 by eloff on Saturday September 11, 2021 @01:24PM (#28493815)
I'm aware. What I'm asking is why multi master is required. You can have a read only slave that is promoted to the master. It's that little bit of downtime during failover in question? Doesn't pgpool make that possible without downtime?

If you use multi master and DNS failover you still have partial downtime for every session routed to the unhealthy master. That doesn't seem to solve the problem, just a little better.

Re:Index bloat reduced in PostgreSQL v14 by sudhirj on Saturday September 11, 2021 @10:38AM (#28492301)
Yup. The synchronous replication described in the docs will allow the configuration of a hot standby, but I don’t think it allows writing to the standby, which is what true master-master does.