Logical Replication and PgPool

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

Browse pgsql-hackers by date

  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.