Re: isolationtester - allow a session specific connection string

Поиск
Список
Период
Сортировка
От Peter Smith
Тема Re: isolationtester - allow a session specific connection string
Дата
Msg-id CAHut+Pvc6igoRwBFEqBk1sM2uPWtxSFxOHEjboM2kb9qZTD5kw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: isolationtester - allow a session specific connection string  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: isolationtester - allow a session specific connection string  (Peter Smith <smithpb2250@gmail.com>)
Список pgsql-hackers
On Mon, Dec 19, 2022 at 5:04 PM Tom Lane <tgl@sss.pgh.pa.us> wrote:
>
> Peter Smith <smithpb2250@gmail.com> writes:
> > My patch/idea makes a small change to the isolationtester spec
> > grammar. Now each session can optionally specify its own connection
> > string. When specified, this will override any connection string for
> > that session that would otherwise have been used. This is the only
> > change.
>
> Surely this cannot work, because isolationtester only runs one
> monitoring session.  How will it detect wait conditions for
> sessions connected to some other postmaster?
>

You are right - probably it can't work in a generic sense. But if the
"controller session" (internal session 0) is also configured to use
the same conninfo as all my "publisher" sessions (the current patch
can't do this but it seems only a small change) then all of the
publisher-side sessions will be monitored like they ought to be --
which is all I really needed I think.

------
Kind Regards,
Peter Smith
Fujitsu Australia



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

Предыдущее
От: Michael Paquier
Дата:
Сообщение: Re: [PATCH] Teach pg_waldump to extract FPIs from the WAL
Следующее
От: Michael Paquier
Дата:
Сообщение: Re: pg_upgrade allows itself to be run twice