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

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Unable to connect to PostgreSQL DB as root user when private key is owned by root with permission 640
Дата
Msg-id 2415119.1653588981@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Unable to connect to PostgreSQL DB as root user when private key is owned by root with permission 640  (David Steele <david@pgmasters.net>)
Ответы Re: Unable to connect to PostgreSQL DB as root user when private key is owned by root with permission 640  (David Steele <david@pgmasters.net>)
Список pgsql-bugs
David Steele <david@pgmasters.net> writes:
> On 5/24/22 16:05, Tom Lane wrote:
>> After further poking at this, I see that we also have to drop the check of
>> file ownership.  That was already dropped once long ago (3405f2b9253), on
>> the grounds that if the file has suitable permissions but its ownership
>> isn't what we expect then our read attempt will fail, so we needn't check
>> ownership explicitly.  While I'd prefer a more explicit error than the
>> "Permission denied" that you get with this approach, the intent of this
>> patch was not to create any new failure modes, so I think we're stuck
>> with that.

> That makes sense. Seems I should have dug further into why the server 
> does this but the client does not.

Pushed that.

>> Open questions:
>> * 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?

> I'm inclined to leave it as is in the back branches to avoid any other 
> unintended consequences. Perhaps we could make the change for PG15?

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?

            regards, tom lane



В списке pgsql-bugs по дате отправления:

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: BUG #17485: Records missing from Primary Key index when doing REINDEX INDEX CONCURRENTLY
Следующее
От: David Steele
Дата:
Сообщение: Re: Unable to connect to PostgreSQL DB as root user when private key is owned by root with permission 640