VPS Guide: Your Go-To for VPS, Ubuntu & Command Line Success

Set Up PostgreSQL Replication on Ubuntu VPS

Category: VPS Setup

Configure PostgreSQL replication—database mirroring—on an Ubuntu VPS—install with

apt install postgresql -y

edit /etc/postgresql/14/main/postgresql conf on primary:

wal_level = replica\nmax_wal_senders = 10

setup standby with pg_basebackup Start with

systemctl start postgresql

open port:

ufw allow 5432

On DigitalOcean test with

psql -h ip -U postgres -c \"SELECT * FROM pg_stat_replication;\"

Ensures uptime—high-availability phpMyAdmin hosting in VPS