I have already asked here about PostgreSQL HA setup, and I got many possible answers. But the bad thing is, even though if I use any third party software like PGpool, Repmgr, pacemaker are asking for timeout(If master is unavailable for n seconds). So there will be a minimal downtime.

Is there any best option to overcome this and setup a zero downtime cluster?

  • For every 9, you add a 0! You will never achieve perfection! – Vérace Sep 30 '17 at 19:29
  • --For every 9, you add a 0! -- I didnt understand this. – Bhuvanesh Sep 30 '17 at 19:31
  • For every 9 in 99%, 99.9%, 99.99%, 99.999% (aka five nines), you will pay ~ ten times as much as for the level before - hence, you add a 0! :-) – Vérace Sep 30 '17 at 20:34

Your Answer

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

Browse other questions tagged or ask your own question.