Re: Setting up SSL for postgre

From: Wim Bertels <wim(dot)bertels(at)ucll(dot)be>
To: "pgsql-admin(at)lists(dot)postgresql(dot)org" <pgsql-admin(at)lists(dot)postgresql(dot)org>, "s(dot)dunand(at)sirap(dot)fr" <s(dot)dunand(at)sirap(dot)fr>
Subject: Re: Setting up SSL for postgre
Date: 2018-08-20 13:29:35
Message-ID: 1534771775784.73685@ucll.be
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Evan Bauer 2018-08-20 13:36:14 Re: Setting up SSL for postgre
Previous Message Johannes Truschnigg 2018-08-20 13:15:35 Re: temp_file_limit parameter ignored?