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:robertmh...@gmail.com] Sent: Tuesday, November 21, 2017 4:35 PM To: Simon Riggs <si...@2ndquadrant.com> Cc: Thomas Rosenstein <thomas.rosenst...@creamfinance.com>; Craig Ringer <cr...@2ndquadrant.com>; PostgreSQL Hackers <pgsql-hack...@postgresql.org> Subject: Re: Logical Replication and triggers On Tue, Nov 21, 2017 at 4:28 PM, Simon Riggs <si...@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-b010b176f...@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