Re: Setting up SSL for postgre

[Wim Bertels <wim.bertels@xxxxxxx>]

 

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