From: | Ashutosh Bapat <ashutosh(dot)bapat(dot)oss(at)gmail(dot)com> |
---|---|
To: | Ankit Oza <ankit(dot)p(dot)oza(at)gmail(dot)com> |
Cc: | pgsql-hackers(at)lists(dot)postgresql(dot)org |
Subject: | Re: PostgreSQL Logical decoding |
Date: | 2022-10-11 05:31:23 |
Message-ID: | CAExHW5sOsMdm+o9GeTb3swe9muyYvObSWM6_z2Pm3bkf9hpc0g@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Hi Ankit,
On Tue, Oct 11, 2022 at 9:32 AM Ankit Oza <ankit(dot)p(dot)oza(at)gmail(dot)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 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.
>
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
From | Date | Subject | |
---|---|---|---|
Next Message | Kyotaro Horiguchi | 2022-10-11 05:43:59 | Re: Remove an unnecessary LSN calculation while validating WAL page header |
Previous Message | Michael Paquier | 2022-10-11 05:01:07 | Re: use has_privs_of_role() for pg_hba.conf |