Thread: [HELP] query regarding replication
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 drawbacks of it ?
--
Regards,
K S Praveen Kumar
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 Support Company. www.2ndQuadrant.com
Thanks. Will this approach replicate DDL changes ?
On Tue, Jun 9, 2020 at 1:36 PM Andreas Kretschmer <andreas@a-kretschmer.de> 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 ?
yes, no problem. the wal's would be a bit larger, that's all.
Regards, Andreas
--
2ndQuadrant - The PostgreSQL Support Company.
www.2ndQuadrant.com
--
Regards,
K S Praveen Kumar
M: +91-9986855625
M: +91-9986855625
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
Andreas Kretschmer <andreas@a-kretschmer.de> 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.consulting@comcast.net