| From: | Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com> |
|---|---|
| To: | Jelte Fennema <me(at)jeltef(dot)nl> |
| Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Andres Freund <andres(at)anarazel(dot)de>, Peter Eisentraut <peter(dot)eisentraut(at)enterprisedb(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: proposal: psql: psql variable BACKEND_PID |
| Date: | 2023-02-17 04:04:31 |
| Message-ID: | CAFj8pRCOf6afVQMUL5=CwehPvaCCiLPNtYNTwiYL10+FLh56RA@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
čt 16. 2. 2023 v 12:49 odesílatel Jelte Fennema <me(at)jeltef(dot)nl> napsal:
> On Thu, 16 Feb 2023 at 12:44, Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
> wrote:
> > To find and use pg_backend_pid is not rocket science. But use
> :BACKEND_PID is simpler.
>
> I wanted to call out that if there's a connection pooler (e.g.
> PgBouncer) in the middle, then BACKEND_PID (and %p) are incorrect, but
> pg_backend_pid() would work for the query. This might be an edge case,
> but if BACKEND_PID is added it might be worth listing this edge case
> in the docs somewhere.
>
good note
Regards
Pavel
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Zheng Li | 2023-02-17 04:13:09 | Re: Support logical replication of DDLs |
| Previous Message | Andres Freund | 2023-02-17 04:01:31 | Should CreateExprContext() be using ALLOCSET_DEFAULT_SIZES? |