How to enable SSL on client
От | Rajagopalan, Jayashree |
---|---|
Тема | How to enable SSL on client |
Дата | |
Msg-id | A7A2044B8A59DA4F9F07599B3B1CA12165F1F8BB@MX101CL02.corp.emc.com обсуждение исходный текст |
Ответы |
Re: How to enable SSL on client
Re: How to enable SSL on client Re: How to enable SSL on client |
Список | pgsql-admin |
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:
“hostssl all all 0.0.0.0/0 md5”
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
В списке pgsql-admin по дате отправления: