| From: | "Rajagopalan, Jayashree" <Jayashree(dot)Rajagopalan(at)emc(dot)com> |
|---|---|
| To: | "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org> |
| Subject: | How to enable SSL on client |
| Date: | 2014-12-05 09:37:48 |
| Message-ID: | A7A2044B8A59DA4F9F07599B3B1CA12165F1F8BB@MX101CL02.corp.emc.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Matthieu Lejeune | 2014-12-05 10:06:06 | Problem pg_upgradecluster from 9.1 to 9.3 |
| Previous Message | Khangelani Gama | 2014-12-04 18:52:06 | Re: Postgres 9.2.4 : psql: symbol lookup error: psql: undefined symbol: PQconnectdbParams |