3 ms·
Does Postgres have binlog replication yet?
by otabdeveloper4 3y ago
Does Postgres have binlog replication yet?
- dijit 3y agoYes, 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.
- evanelias 3y agoPostgres 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-restrictions.html https://www.postgresql.org/docs/current/logical-replication-...