Feature: pg_tde currently validates the connection and provider only when adding a key. Instead, it should perform validation when a new provider is added.
Description
Currently, pg_tde validates the connection and provider only when the user attempts to add a key. This means that any issues with the provider configuration are not detected at the time of adding the provider, potentially leading to errors later when adding a key. To improve reliability and user experience, the validation process should be shifted to the moment when a new provider is added. This ensures that any misconfiguration or connection issues are detected early, preventing future failures during key addition.
Currently, pg_tde validates the connection and provider only when the user attempts to add a key. This means that any issues with the provider configuration are not detected at the time of adding the provider, potentially leading to errors later when adding a key. To improve reliability and user experience, the validation process should be shifted to the moment when a new provider is added. This ensures that any misconfiguration or connection issues are detected early, preventing future failures during key addition.