Devart Forums

This is the connection string I'm using to connect to Postgres in C#.

Host={host};Database={db};Username={userid};Password={password};SSL Mode=Require;Trust Server Certificate=true

But I couldn't connect to this DB using Data Compare for PostgreSQL.

Is there an option to connect to Postgres using SSL without specifying certificates?

We will review this and will answer you as soon as possible.

Thanks @alexa

Is there a fix to support this? I"m using the latest version of dbForge Data Compare for PostgreSQL 3.3.6

There will be a fix in one of the next realizes of that product.

Are there any updates on the fix for this issue?

Unfortunately, we still don't have an estimated date for this.

You can use SSL connection without authentication on both server and client side. If you don't want server to verify the client certificate, you need to configure PostgreSQL server without the root.crt, and if you don't want client to verify the server certificate, don't set the SslOptions.CACert property of the connection.

@alexa - Your suggestion doesn't work for me. In the Security tab for the Database Connection Properties, I have "Use security protocol" checked, but all the other fields empty. When I hit Test Connection, I receive:

"The server hello message uses a protocol that was not"

I'm using version 3.3.6

Any news on this topic, we have the same problem. When we tried to connect to a postgresql v 13.0 we have the error: "The server hello message uses a protocol that was not recognized."

Could you please provide more information regarding to your case (server settings. etc)?

Is anyone attending to this issue?
I'm almost giving up!

Could you please provide us the full product name along with its version?

AnnaMia wrote: ↑Thu 14 Oct 2021 19:40 Is anyone attending to this issue? canlı tv izle
I'm almost giving up!

Please someone help on this issue, I've been looking for a solution everywhere but I couldn't find it.

Kindly note that there is a task for deep investigation created.