Re: How to enable SSL on client

On Fri, Dec 5, 2014 at 3:07 PM, Rajagopalan, Jayashree <
Jayashree(dot)Rajagopalan(at)emc(dot)com> wrote:

> 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
>

Sorry for one typo error

*hostssl myuser mydb 192.168.0.112/32
<http://192.168.0.112/32> cert clientcert=1*

Thanks & Regards,
Harshad Adalkonda
Database Administrator
harshad(dot)adalkonda(at)shreeyansh(dot)com

www.shreeyansh.com