Thread: How to enable SSL on client
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
On Dec 5, 2014, at 10:37 AM, Rajagopalan, Jayashree <Jayashree.Rajagopalan@emc.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 offCan someone share the right procedure to enable SSL on client?I’ve created ~/.posgresql directory and added the client.crt and server.key.RegardsJayashree
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
hostssl myuser mydb 192.168.0.112/0 cert clientcert=1
Harshad Adalkonda
Database Administrator
harshad.adalkonda@shreeyansh.com
www.shreeyansh.com
On Fri, Dec 5, 2014 at 3:07 PM, Rajagopalan, Jayashree <Jayashree.Rajagopalan@emc.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
Harshad Adalkonda
Database Administrator
harshad.adalkonda@shreeyansh.com
www.shreeyansh.com