I don’t see a specific answer to my doubt. Hence posting this query, please do redirect if this is already answered. When we enter new config validation is triggered. So when a process restarts we do trigger subscrption, now will the validation be triggered again ?. I suppose yes if so what happens when this validation fails ? since this is already in cdb.
No, validation will not be triggered by the cdb_trigger_subscriptions API call.
As described in the User Guide, If the subscriber client is a two-phase subscriber, a prepare notification will first be delivered and if any client aborts this synthetic transaction further delivery of subscription notification is suspended and an error is returned to the caller of cdb_trigger_subscriptions().