Postgres Pro
Downloads
Home   >   mailing lists

How to enable SSL on client - Mailing list pgsql-admin

From Rajagopalan, Jayashree
Subject How to enable SSL on client
Date
Msg-id A7A2044B8A59DA4F9F07599B3B1CA12165F1F8BB@MX101CL02.corp.emc.com
Whole thread Raw
Responses Re: How to enable SSL on client  (reiner peterke <zedaardv@drizzle.com>)
Re: How to enable SSL on client  (Harshad Adalkonda <adalkondaharshad@gmail.com>)
Re: How to enable SSL on client  (Harshad Adalkonda <adalkondaharshad@gmail.com>)
List pgsql-admin
Tree view

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 by date:

Previous
From: Khangelani Gama
Date:
Subject: Re: Postgres 9.2.4 : psql: symbol lookup error: psql: undefined symbol: PQconnectdbParams
Next
From: Matthieu Lejeune
Date:
Subject: Problem pg_upgradecluster from 9.1 to 9.3