| From: | Thomas Munro <thomas(dot)munro(at)enterprisedb(dot)com> |
|---|---|
| To: | "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com> |
| Cc: | jwiencek3(at)comcast(dot)net, Forums postgresql <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Synchronous replication |
| Date: | 2016-01-13 20:43:11 |
| Message-ID: | CAEepm=1Q7_3ac9zQ3moA==COeAOpKOtC0RgdeO6S21HKzbizuw@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Thu, Jan 14, 2016 at 9:34 AM, Joshua D. Drake <jd(at)commandprompt(dot)com> wrote:
> On 01/13/2016 12:28 PM, jwiencek3(at)comcast(dot)net wrote:
>>
>> Is it possible to set up synchronous replication to more that one node
>> in a cluster? Or, am I limited to one synchronous node and one
>> asynchronous node?
>
>
> Yes you can have N number of synchronous slaves. However, be careful. It can
> be a huge performance hit.
Note that only one of the listed standbys is a synchronous standby at
any given time though. That is, when you commit, the primary server
will wait just for that one server to report that it has fsync'ed the
WAL. (There is a patch being developed to change that so that you
might be able to wait for more than one in a future release).
--
Thomas Munro
http://www.enterprisedb.com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Kevin Grittner | 2016-01-13 20:46:42 | Re: Data Packaging/Data Unpacking |
| Previous Message | Andreas Joseph Krogh | 2016-01-13 20:39:44 | Re: Moving a large DB (> 500GB) to another DB with different locale |