azure-docs AZURE_POSTGRESQL_CONNECTIONSTRING contains wrong Ssl Mode

According https://www.npgsql.org/doc/release-notes/6.0.html#changes-to-ssl-configuration-ssl-moderequire pgsql requires Ssl Mode=Require in combination with Trust Server Certificate=true which is not provided, otherwise .net connections will not work.

But I want to have Ssl Mode=VerifyFull If I change the connection string within the auto created configuration variable AZURE_POSTGRESQL_CONNECTIONSTRING, the connection string is correctly displayed under Service Conenctor but if I try to validate the connection state then this step fails stating that Configured connection information validated.connectionString of connection is incorrect

[Enter feedback here]

Document Details

⚠ Do not edit this section. It is required for learn.microsoft.com ➟ GitHub issue linking.

ID: 39798c4e-796c-e717-152a-21356de3d1a4
Version Independent ID: 6e9bd7d1-64fe-d806-c294-180cf486dc4b
Content: Integrate Azure Database for PostgreSQL with Service Connector
Content Source: articles/service-connector/how-to-integrate-postgres.md
Service: service-connector
GitHub Login: @mcleanbyron
Microsoft Alias: mcleans

Jun 01 '23 09:06 michaelmairegger

@michaelmairegger Thanks for your feedback! We will investigate and update as appropriate.

Jun 01 '23 11:06 SaibabaBalapur-MSFT

add @xfz11 from eng team to help on this.

Jul 17 '23 06:07 yungezz

Hi @michaelmairegger, we have fixed the validation issue. Now you could change the SSL mode and won't see the error.

Oct 31 '23 08:10 xfz11

Thank you @xfz11 for your contribution. #please-close

Oct 31 '23 08:10 maud-lv