Two-node hands-on PostgreSQL course

You have two real, independent terminals at the bottom of the screen — a MASTER server and a STANDBY replica.

MASTER
read+write • runs DDL/DML
STANDBY
read-only replica • streams WAL

When you write on the master (e.g. INSERT INTO ...), the change actually replicates to the standby's database with a small WAL streaming delay — you'll see it appear there.

Each node has a shell tab (Linux) and a psql tab (SQL). Lessons tell you which node to type on. Use ↑↓ for command history.

PostgreSQL DBA Academy

Loading SQL engines…

▼ TWO LIVE NODES — MASTER (left, read+write) | STANDBY (right, read-only replica). Writes on master replicate live. ▼
MASTER primary • 192.168.10.10:5432 WAL 0/3000000 status streaming
shell
psql
root@master:~$ 
STANDBY replica • 192.168.10.11:5432 applied 0/3000000 lag 0 B
shell
psql
root@standby:~$