From: Tom Lane <tgl@sss.pgh.pa.us>
To: Alexey Shishkin <alexey.shishkin.01@gmail.com>
cc: pgsql-bugs@lists.postgresql.org
Subject: Re: pg_ident.conf + regular expressions issue
In-reply-to: 
 <CAL2LCjzN9ZgfLApebD_a=Hi=Q6As8+VwjPS6Fr6LUjj_zDVM+A@mail.gmail.com>
References: 
 <CAL2LCjzN9ZgfLApebD_a=Hi=Q6As8+VwjPS6Fr6LUjj_zDVM+A@mail.gmail.com>
Comments: In-reply-to Alexey Shishkin <alexey.shishkin.01@gmail.com>
	message dated "Mon, 21 Oct 2024 11:43:47 +0200"
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-ID: <1556448.1729522277.1@sss.pgh.pa.us>
Date: Mon, 21 Oct 2024 10:51:17 -0400
Message-ID: <1556449.1729522277@sss.pgh.pa.us>
Archived-At: 
 <https://www.postgresql.org/message-id/1556449.1729522277%40sss.pgh.pa.us>
Precedence: bulk

Alexey Shishkin <alexey.shishkin.01@gmail.com> writes:
> Pls. find attached the results of my tests regarding the topic.
> I'm not 100% sure it's a bug, but at least it doesn't work as expected.

There is something wrong with your test procedure.  For example,
in test05 the log message clearly shows that peer authentication
failed, although you claimed to be testing ident authentication.
You haven't given enough detail to determine why that happened;
perhaps failure to do "pg_ctl reload" after changing config files?

One point worth noting is that ident auth only works on TCP
connections, not connections via a Unix socket.

			regards, tom lane