Hi all: I’m on postgres 9.0.18. Want to enable SSL for the DB connections. The binaries are build including the openssl. I modified the postgresql.conf – for ssl=on. Copied the server.crt in the data folder. Modified pg_hba.conf - to add:
Getting the following errors in the logs when I start DB: FATAL: no pg_hba.conf entry for host "127.0.0.1", user "myuser", database "mydb", SSL off Can someone share the right procedure to enable SSL on client? I’ve created ~/.posgresql directory and added the client.crt and server.key. Regards Jayashree |