Re: Is it possible to stop sessions killing eachother when they all authorize as the same role?

Поиск
Список
Период
Сортировка
От Jeremy Smith
Тема Re: Is it possible to stop sessions killing eachother when they all authorize as the same role?
Дата
Msg-id CAM8SmLXsXpy-zE1dsE1jjN1Pbn80Uny6HoCi1CAKOy0_vHr18g@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Is it possible to stop sessions killing eachother when they all authorize as the same role?  (Bryn Llewellyn <bryn@yugabyte.com>)
Ответы Re: Is it possible to stop sessions killing eachother when they all authorize as the same role?  (Bryn Llewellyn <bryn@yugabyte.com>)
Список pgsql-general



I say this only to emphasize that there are always things that are critical that are elided in a testcase that tries to be minimal.

So it seems that there's something critical about my env that I'm failing to tell you all. But what can it be?


Removing permissions also works for me.  In my case, I created a brand new PG14.5 cluster in docker and ran Tom's test case.

Your test code seems quite complex to test this simple case, but looking through it, it appears that you revoked permissions to pg_terminate_backend in the postgres database, but then connected as r1 to the play database, where the permissions weren't revoked.  You'll have to revoke the permissions in all databases or change it in template1 before creating the new database.

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

Предыдущее
От: Guillaume Lelarge
Дата:
Сообщение: Re: Is it possible to stop sessions killing eachother when they all authorize as the same role?
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Is it possible to stop sessions killing eachother when they all authorize as the same role?