One method PostgreSQL uses to maintain ACID properties is Write-Ahead Logging (WAL). For example, a secondary database cluster can use the archived WAL file for replication purposes, but you can also use the files to ...
•
By
Nathan McCulloch
PostgreSQL
Ubuntu 20.04
Databases
Streaming replication is a popular method you can use to horizontally scale your relational databases. In this tutorial, you will set up physical streaming replication with PostgreSQL 12 on Ubuntu 20.04 using two sepa...
•
By
Nathan McCulloch
PostgreSQL
Databases
Scaling
Ubuntu 20.04