| From: | Zsolt Parragi <zsolt(dot)parragi(at)percona(dot)com> |
|---|---|
| To: | Ajit Awekar <ajitpostgres(at)gmail(dot)com> |
| Cc: | Jacob Champion <jacob(dot)champion(at)enterprisedb(dot)com>, Jelte Fennema-Nio <postgres(at)jeltef(dot)nl>, Hannu Krosing <hannuk(at)google(dot)com>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>, Dave Cramer <davecramer(at)gmail(dot)com>, Heikki Linnakangas <hlinnaka(at)iki(dot)fi> |
| Subject: | Re: Periodic authorization expiration checks using GoAway message |
| Date: | 2025-12-17 10:44:25 |
| Message-ID: | CAN4CZFNE6OLFzja=ysfhQzC=AORPBH2YdK2-am=cfGuk0A_s7g@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
> To me that seems like a matter of policy and not protocol. (As long as
> we come to some agreement on the semantics of what a client is and is
> not allowed to do before reauthenticating.)
It's great if this is configurable, as long as DBAs can choose both
the immediate and graceful options.
> Is the hope that batching validation will make things more efficient,
> or is there another goal to using a background process? You still have
> to communicate back to each backend.
* I think I can implement it with background threads / immediate
disconnection currently for PG18 in our validator (this of course
might improve with PG19 and later)
* Can we implement the immediate disconnection without a background
process? I would again use the long running query example. If a query
is running for 5-10-... minutes, is there another way to disconnect
the connection before the query completes?
* Some identity providers support pushing revocation data instead of
pulling, and this usually works over HTTP. Which means that it needs a
background process running a mini HTTP server (as part of an oauth
validator).
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ashutosh Bapat | 2025-12-17 10:53:10 | Re: apply_scanjoin_target_to_paths and partitionwise join |
| Previous Message | Peter Eisentraut | 2025-12-17 10:39:05 | Re: Remaining dependency on setlocale() |