Re: [HELP] query regarding replication

2020-06-09 Thread Jerry Sievers
Andreas Kretschmer writes: > Am 09.06.20 um 10:44 schrieb Praveen Kumar K S: >> Thanks. Will this approach replicate DDL changes ? No. > > sure. > > > Regards, Andreas -- Jerry Sievers Postgres DBA/Development Consulting e: postgres.consult...@comcast.net

Re: [HELP] query regarding replication

2020-06-09 Thread Andreas Kretschmer
Am 09.06.20 um 10:44 schrieb Praveen Kumar K S: Thanks. Will this approach replicate DDL changes ? sure. Regards, Andreas -- 2ndQuadrant - The PostgreSQL Support Company. www.2ndQuadrant.com

Re: [HELP] query regarding replication

2020-06-09 Thread Praveen Kumar K S
Thanks. Will this approach replicate DDL changes ? On Tue, Jun 9, 2020 at 1:36 PM Andreas Kretschmer wrote: > > > Am 09.06.20 um 09:55 schrieb Praveen Kumar K S: > > Can I achieve master/slave streaming replication by setting WAL_LEVEL > > to logical on master ? Are there any drawbacks of it ? >

Re: [HELP] query regarding replication

2020-06-09 Thread Andreas Kretschmer
Am 09.06.20 um 09:55 schrieb Praveen Kumar K S: Can I achieve master/slave streaming replication by setting WAL_LEVEL to logical on master ? Are there any drawbacks of it ? yes, no problem. the wal's would be a bit larger, that's all. Regards, Andreas -- 2ndQuadrant - The PostgreSQL Suppo

[HELP] query regarding replication

2020-06-09 Thread Praveen Kumar K S
Hello, I had setup one master and hot-slave by setting WAL_LEVEL=replica But I use a debezium plugin and it requires to connect to master with WAL_LEVEL=logical and it is mandatory. Can I achieve master/slave streaming replication by setting WAL_LEVEL to logical on master ? Are there any drawback