| From: | "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com> |
|---|---|
| To: | jwiencek3(at)comcast(dot)net, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Synchronous replication |
| Date: | 2016-01-13 20:34:30 |
| Message-ID: | 5696B4D6.70809@commandprompt.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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.
>
> Assuming my replicated databases are on nodes: testqa1, testqa2. What
> would my synchronous_standby_names entry in my postgresql.conf on my
> master database?
The IP address that each is binding to.
JD
--
Command Prompt, Inc. http://the.postgres.company/
+1-503-667-4564
PostgreSQL Centered full stack support, consulting and development.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andreas Joseph Krogh | 2016-01-13 20:39:44 | Re: Moving a large DB (> 500GB) to another DB with different locale |
| Previous Message | Tom Lane | 2016-01-13 20:32:12 | Re: pg_dump problem with dropped NOT NULL on child table |