Re: isolationtester - allow a session specific connection string - Mailing list pgsql-hackers

From Peter Smith
Subject Re: isolationtester - allow a session specific connection string
Date
Msg-id CAHut+Pvc6igoRwBFEqBk1sM2uPWtxSFxOHEjboM2kb9qZTD5kw@mail.gmail.com
Whole thread Raw
In response to Re: isolationtester - allow a session specific connection string  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: isolationtester - allow a session specific connection string
List 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 by date:

Previous
From: Michael Paquier
Date:
Subject: Re: [PATCH] Teach pg_waldump to extract FPIs from the WAL
Next
From: Michael Paquier
Date:
Subject: Re: pg_upgrade allows itself to be run twice