pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Laurenz Albe <laurenz.albe@cybertec.at>
To: Dhirendra Singh <dhirendraks@gmail.com>
Cc: pgsql-admin@lists.postgresql.org
Subject: Re: Difference between host, hostssl and hostnossl connection type
Date: Fri, 25 Nov 2022 08:44:51 +0100
Message-ID: <5abfcab077173acd048432352bc1c6fa91b61332.camel@cybertec.at> (raw)
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>

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





view thread (5+ messages)  latest in thread

Message-ID: <5abfcab077173acd048432352bc1c6fa91b61332.camel@cybertec.at>
Permalink:  ../5abfcab077173acd048432352bc1c6fa91b61332.camel@cybertec.at/
Also on:    postgresql.org/message-id/5abfcab077173acd048432352bc1c6fa91b61332.camel@cybertec.at

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: laurenz.albe@cybertec.at, dhirendraks@gmail.com, pgsql-admin@lists.postgresql.org
  Subject: Re: Difference between host, hostssl and hostnossl connection type
  In-Reply-To: <5abfcab077173acd048432352bc1c6fa91b61332.camel@cybertec.at>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox