Message-ID: <5abfcab077173acd048432352bc1c6fa91b61332.camel@cybertec.at>
Subject: Re: Difference between host, hostssl and hostnossl connection type
From: Laurenz Albe <laurenz.albe@cybertec.at>
To: Dhirendra Singh <dhirendraks@gmail.com>
Cc: pgsql-admin@lists.postgresql.org
Date: Fri, 25 Nov 2022 08:44:51 +0100
In-Reply-To: 
 <CAEyh4sYsxjf+BC06MzFKxzZeijBsD9vyiZGEha+r01sWNSvVBQ@mail.gmail.com>
References: 
	<CAEyh4sYOTAZiSBMXCocd-poP-PrCtp_emDsx2GWSPUbzapHBGg@mail.gmail.com>
	 <e83f6d8114aa305d95005da30da512446a574e75.camel@cybertec.at>
	 <CAEyh4sYsxjf+BC06MzFKxzZeijBsD9vyiZGEha+r01sWNSvVBQ@mail.gmail.com>
Content-Type: text/plain; charset="UTF-8"
User-Agent: Evolution 3.42.4 (3.42.4-2.fc35) 
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Archived-At: 
 <https://www.postgresql.org/message-id/5abfcab077173acd048432352bc1c6fa91b61332.camel%40cybertec.at>
Precedence: bulk

On Fri, 2022-11-25 at 12:57 +0530, Dhirendra Singh wrote:
> But if i provide cert authentication in host type and provide certificates then it should work.no ?
> Otherwise the documentation is not clear about this limitation.

I think that the documentation (https://www.postgresql.org/docs/current/auth-cert.html)
is quite clear:

> This authentication method uses SSL client certificates to perform authentication.
> It is therefore only available for SSL connections.

True, it doesn't spell out that you will get an error if you use it with "host",
but the error message was clear enough, wasn't it?

Yours,
Laurenz Albe