Skip to content

Philip McClarence

Data, the Cloud and other thoughts.

  • PostgreSQL
  • Big Data
    • Cassandra
    • Hadoop
  • Oracle
    • Oracle Basics
    • Oracle News
    • Errors
    • Oracle Tasks
    • Oracle RAC
    • Oracle Tuning
  • Tutorials
  • Self Improvement

Tag: postgres

Posted on 20/07/201730/08/2019

Failover testing of a Postgres cluster

Testing failover to one of 2 slaves and reattaching to the new master.

Starting config

1
2
3
   master
  |      |
slave1 slave2

Post failover config

1
2
3
   slave1
  |      |
slave2 master

Continue reading “Failover testing of a Postgres cluster”

Recent Posts

  • How do you identify high load tables/indexes in Postgres
  • How can I secure a Postgres Database
  • All about Logical Replication in Postgres.
  • When and How do you use pg_rewind() in PostgreSQL?
  • How do I Re-Attach a Master once a Replica has been Promoted in Postgres

Top Posts

  • Backing up and Restoring Postgres using pg_basebackup
  • What is the pg_clog and the clog
  • When and How do you use pg_rewind() in PostgreSQL?
  • All about Logical Replication in Postgres.
  • AWS Well-Architected Framework - The 5 Pillars
  • Cleaning up a failed Oracle 11g grid infrastructure install.
  • How to Reduce the Size of the Undo Tablespace in Oracle
  • High Availability Options in Oracle vs Postgres
  • Find the size of a table in Postgres
  • How do you promote a replica in Postgres?

Tags

  • AWS
  • Big Data
  • Cassandra
  • Cloud
  • Errors
  • Featured
  • Hadoop
  • How To - Postgres
  • Oracle
  • Oracle Basics
  • Oracle RAC
  • Oracle Tasks
  • Oracle Tuning
  • PostgreSQL
  • Self Improvement
  • Tutorial
  • Uncategorized
  • Video
Privacy & Cookies: This site uses cookies. By continuing to use this website, you agree to their use.
To find out more, including how to control cookies, see here: Cookie Policy
Proudly powered by WordPress