PostgreSQL Logical decoding - Mailing list pgsql-hackers

From Ankit Oza
Subject PostgreSQL Logical decoding
Date
Msg-id CAPQ2Q7OWCTbHU2yNyk8GoryV=zy1dSyq+ySwmcHuc2EdPwSkqw@mail.gmail.com
Whole thread Raw
Responses Re: PostgreSQL Logical decoding  (Ashutosh Bapat <ashutosh.bapat.oss@gmail.com>)
Re: PostgreSQL Logical decoding  (Amit Kapila <amit.kapila16@gmail.com>)
List 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

pgsql-hackers by date:

Previous
From: "kuroda.hayato@fujitsu.com"
Date:
Subject: RE: [PATCH] Use indexes on the subscriber when REPLICA IDENTITY is full on the publisher
Next
From: Bharath Rupireddy
Date:
Subject: Re: Suppressing useless wakeups in walreceiver