| From: | Dhirendra Singh <dhirendraks(at)gmail(dot)com> |
|---|---|
| To: | pgsql-admin(at)lists(dot)postgresql(dot)org |
| Subject: | Difference between host, hostssl and hostnossl connection type |
| Date: | 2022-11-25 05:21:17 |
| Message-ID: | CAEyh4sYOTAZiSBMXCocd-poP-PrCtp_emDsx2GWSPUbzapHBGg@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
Hi All,
I am using postgres version 14.
I would like to know what is the difference between host, hostssl and
hostnossl connection type.
According to documentation,
host => This record matches connection attempts made using TCP/IP. host
records match SSL or non-SSL connection attempts as well as GSSAPI
encrypted or non-GSSAPI encrypted connection
attempts.
hostssl => This record matches connection attempts made using TCP/IP, but
only when the connection is made with SSL encryption.
hostnossl => This record type has the opposite behavior of hostssl; it only
matches connection attempts made over TCP/IP that do not use SSL.
I provided cert authentication method for host type connection. but i get
error and postgres does not come up. Following is the error message i get.
LOG: cert authentication is only supported on hostssl connections.
Thanks,
Dhirendra.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Laurenz Albe | 2022-11-25 07:09:52 | Re: Difference between host, hostssl and hostnossl connection type |
| Previous Message | Holger Jakobs | 2022-11-24 15:03:26 | Re: Reg: TLS Implementation |