News for hackers. Stuff that matters.
Re:Ask HN: It's 2023, how do you choose between MySQL and Po... by otabdeveloper4 on Thursday May 11, 2023 @03:50PM (#35907524)
Does Postgres have binlog replication yet?
Re:Ask HN: It's 2023, how do you choose between MySQL and Po... by dijit on Thursday May 11, 2023 @03:52PM (#35907552)
Yes, for over half a decade at least, but “binlog” is a MySQL term, for postgresql it has the much more apt name: write-ahead log.

it is the only official, in-binary replication mechanism.

Re:Ask HN: It's 2023, how do you choose between MySQL and Po... by evanelias on Thursday May 11, 2023 @04:05PM (#35907684)
Postgres WAL replication is a physical replication stream. MySQL binlog replication is a logical replication stream, a higher-level abstraction which is independent of the storage engines.

Postgres does separately support logical replication now, but it has some limitations, such as not permitting replication of DDL: https://www.postgresql.org/docs/current/logical-replication-...