Re: PostgreSQL Logical decoding

2022-10-11 Thread Amit Kapila
On Wed, Oct 12, 2022 at 10:09 AM Ankit Oza wrote: > > Thanks Ashutosh, > > Actually we use the Postgres service offered by Azure (Flexible server). So, > I was looking at the following documentation which talks about Logical > Replication and Logical Decoding as two different methods of replicat

Re: PostgreSQL Logical decoding

2022-10-11 Thread Ankit Oza
Thanks Ashutosh, Actually we use the Postgres service offered by Azure (Flexible server). So, I was looking at the following documentation which talks about Logical Replication and Logical Decoding as two different methods of replication. Here Logical replication talks about creating both Publishe

Re: PostgreSQL Logical decoding

2022-10-10 Thread Amit Kapila
On Tue, Oct 11, 2022 at 9:32 AM Ankit Oza 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. > > Basically, we are trying to create a replica/standby postgre server to a

Re: PostgreSQL Logical decoding

2022-10-10 Thread Ashutosh Bapat
Hi Ankit, On Tue, Oct 11, 2022 at 9:32 AM Ankit Oza 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

PostgreSQL Logical decoding

2022-10-10 Thread Ankit Oza
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 D