PostgreSQL Logical decoding

From: Ankit Oza <ankit(dot)p(dot)oza(at)gmail(dot)com>
To: pgsql-hackers(at)lists(dot)postgresql(dot)org
Subject: PostgreSQL Logical decoding
Date: 2022-10-11 04:02:38
Message-ID: CAPQ2Q7OWCTbHU2yNyk8GoryV=zy1dSyq+ySwmcHuc2EdPwSkqw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hello,

We are looking for an example on how to consume the changes of WAL produced
by logical decoding (streaming or SQL interface) in another postgres server.

Basically, we are trying to create a replica/standby postgre server to a
primary progre server. Between Logical replication and Logical Decoding we
came up with Logical decoding as the choice due to limitation of logical
replication (materialized views, external views/tables, sequences not
replicated). However we are not finding a good example with instructions on
how to set up a consumer postgre server.

Thanks
Ankit

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Bharath Rupireddy 2022-10-11 04:04:25 Re: Suppressing useless wakeups in walreceiver
Previous Message kuroda.hayato@fujitsu.com 2022-10-11 03:54:01 RE: [PATCH] Use indexes on the subscriber when REPLICA IDENTITY is full on the publisher