Web Hosting & VPS Tips

Unleash Your Server Potential with Expert Insights

Hosting provided by: Cloudways
Free to Try! Up to 40% Off!

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

Back to All Tips