Re: Unable to connect to PostgreSQL DB as root user when private key is owned by root with permission 640

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: David Steele <david(at)pgmasters(dot)net>
Cc: "Suralkar, Yogendra (Yogendra)" <suralkary(at)avaya(dot)com>, "pgsql-bugs(at)lists(dot)postgresql(dot)org" <pgsql-bugs(at)lists(dot)postgresql(dot)org>, "Porob, Dattaram (Datta)" <porobd(at)avaya(dot)com>, "Oswal, Prashant (Prashant) **CTR**" <poswal(at)avaya(dot)com>, "Patil, Parag (Parag)" <paragp(at)avaya(dot)com>, "Devaraj, Sankar (Sankar)" <devarajs(at)avaya(dot)com>, "Singh, Payal (Payal) **CTR**" <payals(at)avaya(dot)com>
Subject: Re: Unable to connect to PostgreSQL DB as root user when private key is owned by root with permission 640
Date: 2022-05-26 21:35:13
Message-ID: 2457145.1653600913@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

David Steele <david(at)pgmasters(dot)net> writes:
> On 5/26/22 2:16 PM, Tom Lane wrote:
>>> * This puts us back into a situation where the frontend and server tests
>>> are not in sync. Do we want to relax the server's checks to match this,
>>> or just leave that side as it stands?

>> Yeah, I'm unenthused now about touching this in the back branches.
>> But do we want to do it in HEAD, or just leave well enough alone?

> After thinking on it for a bit I believe we should leave well enough
> alone. This code is rarely touched so I don't think it's a very big deal.

Agreed. We changed it because we thought the two chunks of code were
satisfying identical constraints, but evidently that's not so. At least
the situation is better documented now.

regards, tom lane

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message David Rowley 2022-05-26 22:44:34 Re: BUG #17495: Regression in 15beta1 when filtering subquery including row_number window function
Previous Message David Steele 2022-05-26 20:01:49 Re: Unable to connect to PostgreSQL DB as root user when private key is owned by root with permission 640