[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 KumarM: +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