What are the advantages of cascading replication in PostgreSQL.

I have done Testing On this With three nodes.


What is the Use if My master(M1) goes Down(failover). Where the secondary Slave(s2) Server Useful for us in this setup.

  • If you do a switchover from master to slave1, you still have a spare slave if the now active master also fails. Otherwise you'd be running with no failover computer at all. – a_horse_with_no_name Nov 25 '14 at 19:22
  • @a_horse_with_no_name I think this should be turned into an actual answer. – dezso Jan 22 '19 at 23:30

If Your application can get data from more than one database You can use cascading replication for load balancing(One App get data from multiple bases) but only in case when it's synchronous replication(in case of cascading rep. it's heavy).

In case of M1 fail You can do Python script that will place S1 as master(including updating port, config, and connecting with S2). It's not hard, with Python You can do it in about one hour. Other option is Python script that will restore M1 with data from S1, use Python library: PSYCOPG2

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.