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