RE: Setting up SSL for postgre

["Mark Williams" <markwillimas@xxxxxxxxx>]

Hi,

 

Sorry I don’t understand what you are suggesting re the pg_hba file.

 

__

 

From: Wim Bertels <wim.bertels@xxxxxxx>
Sent: 20 August 2018 14:30
To: pgsql-admin@xxxxxxxxxxxxxxxxxxxx; s.dunand@xxxxxxxx
Subject: Re: Setting up SSL for postgre

 

 

 

pg_hba.conf

# TYPE  DATABASE        USER            CIDR-ADDRESS            METHOD

 

# IPv4 local & remote connections:

host    all             all             127.0.0.1/32            trust

hostssl all         postgres    0.0.0.0/0             cert

 

cert method for auth, hence this behaviour (client cert..)

 

extra tip:

https://duckduckgo.com/?q=letsencrypt+postgresql

for official server side certificates

 

mvg,

 Bertels Wim

 

Mark

__

 

This page helped me :
https://www.depesz.com/2015/05/11/how-to-setup-ssl-connections-and-authentication/

Best regards,
Stéphane