[pgpool-general: 6843] Re: logical replication for CDC

Tatsuo Ishii ishii at sraoss.co.jp
Tue Feb 4 09:23:19 JST 2020

> Hello pgpool team. We are using standard master slave scenario - with
> pgool on top, so clients have access to only pgpool.
> Is it possible to use pgpool host as a master for logical replication?
> so client connects to pgpool to get changes from replication slot.

I assume your question is "SELECT * FROM
pg_logical_slot_get_changes()" works via Pgpool-II or not. Also I
assume that your logical replication publishers are always on the
streaming replication primary host. If so, the answer is yes, as long
as you properly redirct the SELECT to the primary host using
black/white function list.

Best regards,
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php

More information about the pgpool-general mailing list