Wednesday, April 20, 2022

Oracle vs PostgreSQL replication terminology

Functionality Oracle PostgreSQL
A standby server that can accept connections and serves read-only queries Active Data Guard Hot Standby
A standby server that cannot be connected to until it is promoted to a master server Physical Standby Server Warm Standby
A data-modifying transaction is not considered committed until all servers have committed the transaction. Maximum Availability Synchronous
Allow some delay between the time of a commit and its propagation to the other servers.
Some transactions might be lost in the switch to a backup server
load balanced servers might return slightly stale results.
Maximum Performance Asynchronous
Do not allow any transactions to be unprotected at any time Maximum Protection  

  • PostgreSQL 11 dokumentation here
  • Oracle 12cR2 documentation here
  • No comments:

    Post a Comment