Re: PostgreSQL Logical decoding

Hi Ankit,


On Tue, Oct 11, 2022 at 9:32 AM Ankit Oza <ankit.p.oza@gmail.com> wrote:
>
> 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. 

built-in logical replication is good example to start looking for.
https://www.postgresql.org/docs/current/logical-replication.html

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

Logical decoding is the process to convert WAL to a logical change,
logical replication deals with transferring these changes to another
server and applying those there. So they work in tandem; just one
without the other can not be used. So I am confused about your
requirements.

--
Best Wishes,
Ashutosh Bapat