Hi, I followed this tutorial (https://www.digitalocean.com/community/tutorials/how-to-set-up-master-slave-replication-on-postgresql-on-an-ubuntu-12-04-vps#configure-the-slave-server) to create a replication scheme between to postgresql servers (v9.5 on Ubuntu 16.04).
The only difference is that for the initial database replication I used this:
sudo -u postgres pg_basebackup -h 188.8.131.52 -D /var/lib/postgresql/9.5/main -U [username] -v -P -x
Then I tried to test the failover process.
However whatever change I make on the new Master, it won’t be coped to the new slave. Also the new slave is not read-only.
Can someone explain to me what did I do wrong?
Click below to sign up and get $100 of credit to try our products over 60 days!