ssl connection with certificate

From: PG Doc comments form <noreply(at)postgresql(dot)org>
To: pgsql-docs(at)lists(dot)postgresql(dot)org
Cc: cochoa(at)mulesol(dot)es
Subject: ssl connection with certificate
Date: 2021-03-22 12:31:08
Message-ID: 161641626848.702.16905338782430191942@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs

The following documentation comment has been logged on the website:

Page: https://www.postgresql.org/docs/11/index.html
Description:

Good morning. Following the instructions
https://www.postgresql.org/docs/11/ssl-tcp.html I can't establish a local
connection with certificate. In the pg_hba.conf
hostssl all all 127.0.0.1/32 md5
clientcert=1

And in the postgresql.conf:

ssl_cert_file = '/etc/postgresql/11/main/server.crt'
ssl_key_file = '/etc/postgresql/11/main/server.key'

server is a certficate is generated.
The error all the time is the same, it cannot connect because either the
server is not activated or something is missing.

I need a possible solution. The installation I have done is the basic sudo
apt install postgresql on debian 10

Thanks and best regards,

Browse pgsql-docs by date

  From Date Subject
Next Message Daniel Gustafsson 2021-03-24 09:49:27 Update to reflect that TLS1 and TLSv1.1 are now deprecated
Previous Message Magnus Hagander 2021-03-22 08:49:27 Re: Wrong distance shown in miles for extension earthdistance