From: | "Taylor, Nathaniel N(dot)" <Nathaniel(dot)N(dot)Taylor(at)ssa(dot)gov> |
---|---|
To: | Robert Haas <robertmhaas(at)gmail(dot)com>, Simon Riggs <simon(at)2ndquadrant(dot)com> |
Cc: | Thomas Rosenstein <thomas(dot)rosenstein(at)creamfinance(dot)com>, Craig Ringer <craig(at)2ndquadrant(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Logical Replication and PgPool |
Date: | 2017-11-22 11:57:33 |
Message-ID: | 2b10b6331d874dcaacb123b6f4426e6c@SSC-DAG4-03.ba.ad.ssa.gov |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
All,
I have high availability multi instance implementation of PostgreSQL using PgPooL v3.6. I am thinking of doing data separation and change data capture using logical replication . Any ideas?
Thank you
Dr. Nathaniel Taylor, Ph.D (Comp. Sci.),C|EH,CASP
LM, CPO, DCPS2- Enterprise Systems Database Architect
Cell : (202) 415-1342
-----Original Message-----
From: Robert Haas [mailto:robertmhaas(at)gmail(dot)com]
Sent: Tuesday, November 21, 2017 4:35 PM
To: Simon Riggs <simon(at)2ndquadrant(dot)com>
Cc: Thomas Rosenstein <thomas(dot)rosenstein(at)creamfinance(dot)com>; Craig Ringer <craig(at)2ndquadrant(dot)com>; PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Logical Replication and triggers
On Tue, Nov 21, 2017 at 4:28 PM, Simon Riggs <simon(at)2ndquadrant(dot)com> wrote:
> I would have acted on this myself a few days back if I thought the
> patch was correct, but I see multiple command counter increments
> there, so suspect an alternate fix is correct.
Oh, well, I'm glad you said something. I was actually thinking about committing the patch Peter posted in http://postgr.es/m/619c557d-93e6-1833-1692-b010b176ff77@2ndquadrant.com
because it looks correct to me, but I'm certainly not an expert on that code so I'll wait for your analysis.
--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company
From | Date | Subject | |
---|---|---|---|
Next Message | Ashutosh Bapat | 2017-11-22 13:30:34 | Re: [HACKERS] Removing LEFT JOINs in more cases |
Previous Message | Michael Paquier | 2017-11-22 11:50:57 | Re: [PATCH] using arc4random for strong randomness matters. |