synch streaming replication question

From: John Wiencek <jwiencek3(at)comcast(dot)net>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: synch streaming replication question
Date: 2016-02-22 21:43:19
Message-ID: D2F0DD17.E8FB%jwiencek3@comcast.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi All

I have a three node cluster using streaming replication configured as
follows:

One synch node and one asynch node.

If my synch node is down the master node is hung until that node is brought
back on line.

Two questions:

1. Is this the expected action on my master? It makes sense if it is since
the master is waiting for an ack from the synch node.

2. Is there anyway to configure my cluster so I have a synch node but not
have my master node ³HANG² if the synch node is down?

Regards

John Wiencek

Responses

Browse pgsql-general by date

  From Date Subject
Next Message David G. Johnston 2016-02-22 21:48:26 Re: Read-only tables to avoid row visibility check
Previous Message Seamus Abshere 2016-02-22 21:38:03 Re: Read-only tables to avoid row visibility check