Postgres Pro
Downloads
Home   >   mailing lists

Re: Setting up SSL for postgre - Mailing list pgsql-admin

From Wim Bertels
Subject Re: Setting up SSL for postgre
Date
Msg-id 1534771775784.73685@ucll.be
Whole thread Raw
In response to Re: Setting up SSL for postgre  (Stéphane Dunand <s.dunand@sirap.fr>)
Responses RE: Setting up SSL for postgre  ("Mark Williams" <markwillimas@gmail.com>)
List pgsql-admin
Tree view


 

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

pgsql-admin by date:

Previous
From: Johannes Truschnigg
Date:
Subject: Re: temp_file_limit parameter ignored?
Next
From: Evan Bauer
Date:
Subject: Re: Setting up SSL for postgre