You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Hello,
I'm trying to use this extension with CNPG and i have no problem with basic configuration, however, i have a few questions.
This is my context and configuration:
I have a primary and one replica
I'm using a CDC tool (debezium) that's why i need this extension to ensure that i will not lose data after failover / switchover
About configuration: hot_standby_feedback: on pg_failover_slots.synchronize_slot_names: debezium
I dont use primary_slot_name because i noticed that with CNPG, this value is never empty (can you confirm it ?)
Questions:
I would like to use pg_failover_slots.standby_slot_names parameter to ensure that i will not lose data, so if I've understood correctly, I need to set the value of my replica physical's replication_slot ! (for example the slot used for streaming_replication ?)
ex: pg_failover_slots.standby_slot_names = cnpg-test-2 (in case of cnpg-test-1 is primary db)
So in case of failover/switchover , cnpg-test-1 become replica and what about pg_failover_slots.standby_slot_names value ? Should i manually upgrade the value to pg_failover_slots.standby_slot_names = cnpg-test-1 ?
Is there a way to retrieve this physical's replication_slot name (replica pod) into the manifest declaration ?
thanks
The text was updated successfully, but these errors were encountered:
Hello,
I'm trying to use this extension with CNPG and i have no problem with basic configuration, however, i have a few questions.
This is my context and configuration:
I have a primary and one replica
I'm using a CDC tool (debezium) that's why i need this extension to ensure that i will not lose data after failover / switchover
About configuration:
hot_standby_feedback: on
pg_failover_slots.synchronize_slot_names: debezium
I dont use primary_slot_name because i noticed that with CNPG, this value is never empty (can you confirm it ?)
Questions:
I would like to use pg_failover_slots.standby_slot_names parameter to ensure that i will not lose data, so if I've understood correctly, I need to set the value of my replica physical's replication_slot ! (for example the slot used for streaming_replication ?)
ex: pg_failover_slots.standby_slot_names = cnpg-test-2 (in case of cnpg-test-1 is primary db)
So in case of failover/switchover , cnpg-test-1 become replica and what about pg_failover_slots.standby_slot_names value ? Should i manually upgrade the value to pg_failover_slots.standby_slot_names = cnpg-test-1 ?
Is there a way to retrieve this physical's replication_slot name (replica pod) into the manifest declaration ?
thanks
The text was updated successfully, but these errors were encountered: