Re: Difference between host, hostssl and hostnossl connection type

On Fri, 2022-11-25 at 10:51 +0530, Dhirendra Singh wrote:
> 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.

"cert" authentication is authentication with SSL (TLS) certificates.
You cannot use that authentication without SSL.  That is why you have to use "hostssl".

Yours,
Laurenz Albe