Logical Replication and PgPool - Mailing list pgsql-hackers

From Taylor, Nathaniel N.
Subject Logical Replication and PgPool
Date
Msg-id 2b10b6331d874dcaacb123b6f4426e6c@SSC-DAG4-03.ba.ad.ssa.gov
Whole thread Raw
List pgsql-hackers
All,
I have high availability multi instance implementation of PostgreSQL using PgPooL v3.6. I am thinking of doing data
separationand 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@gmail.com] 
Sent: Tuesday, November 21, 2017 4:35 PM
To: Simon Riggs <simon@2ndquadrant.com>
Cc: Thomas Rosenstein <thomas.rosenstein@creamfinance.com>; Craig Ringer <craig@2ndquadrant.com>; PostgreSQL Hackers
<pgsql-hackers@postgresql.org>
Subject: Re: Logical Replication and triggers

On Tue, Nov 21, 2017 at 4:28 PM, Simon Riggs <simon@2ndquadrant.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


pgsql-hackers by date:

Previous
From: Michael Paquier
Date:
Subject: Re: [PATCH] using arc4random for strong randomness matters.
Next
From: Ashutosh Bapat
Date:
Subject: Re: [HACKERS] Removing LEFT JOINs in more cases