Re: Difference between host, hostssl and hostnossl connection type

From: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
To: Dhirendra Singh <dhirendraks(at)gmail(dot)com>
Cc: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: Re: Difference between host, hostssl and hostnossl connection type
Date: 2022-11-25 07:44:51
Message-ID: 5abfcab077173acd048432352bc1c6fa91b61332.camel@cybertec.at
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Laurenz Albe 2022-11-25 07:46:22 Re: Disable unique constraint in Postgres
Previous Message Dhirendra Singh 2022-11-25 07:27:29 Re: Difference between host, hostssl and hostnossl connection type