PgPass host still not correctly matched

[paour]

What happened?

This is a follow-up from #356.

Steps to reproduce

1. in Edit Connection dialog, enable Use ~/.pgpass
2. notice the green message ~/.pgpass found – matching entry exists
3. click Save
4. open the same connection
5. Use ~/.pgpass is disabled -> this setting isn't persisted
6. click Test connection
7. error message

connection to server at "MYHOST.postgres.database.azure.com" (4.251.RED.ACT), port 5432 failed: FATAL:  no pg_hba.conf entry for host "185.10.RED.ACT", user "PostgresAdmins", database "ed", no encryption

Expected behavior

1. the Use ~/.pgpass setting should be saved
2. connecting to the DB should use the same logic as the green check when the setting is activated

Database type

PostgreSQL

TablePro version

0.20.2

macOS version & chip

No response

Screenshots / Logs

No response

[datlechin]

Hi @paour could you please update to latest version and test again see the issue fixes?

[paour]

The first issue (setting not persisted) is fixed.

Unfortunately the second is not: when connecting, the app doesn't find the config, despite the fact the green check is displayed below the setting.

[datlechin]

Hi @paour, could you check what SSL mode you have set for this connection? Azure PostgreSQL requires SSL, and the "no encryption" in the error suggests SSL might be disabled. Try setting it to "Required" or "Preferred" and see if that fixes it.

[paour]

Sorry about that, after setting encryption the connexion works fine. Thank you!