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.

When a user try to add a key provider, and if the connect user don’t have write permission, so it don’t throw write permission issue unless user try to add principal key.

Expected: It should warn user at the time of add_key_provider