| From: | Michael Paquier <michael(at)paquier(dot)xyz> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>, Dominic Jones <jonesd(at)xmission(dot)com>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: 10.4 upgrade, function markings, and template0 |
| Date: | 2018-05-15 02:40:24 |
| Message-ID: | 20180515024024.GD1600@paquier.xyz |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Mon, May 14, 2018 at 05:22:39PM -0400, Tom Lane wrote:
> Maybe it'd be worth building some sort of infrastructure that would
> allow this to be done at a lower level. It's not hard to imagine
> an autovacuum-like or bgworker-based thingy that could run around
> and apply a given SQL script in every database, bypassing the usual
> worries about authentication and connections-disabled databases.
A portion of the infrastructure is already available for background
workers which can use BGWORKER_BYPASS_ALLOWCONN since Postgres 11 to
enforce connections to databases even if an administrator disables
connections to it.
--
Michael
| From | Date | Subject | |
|---|---|---|---|
| Next Message | tango ward | 2018-05-15 02:47:41 | Re: Query ID Values |
| Previous Message | David G. Johnston | 2018-05-15 01:53:05 | Re: Query ID Values |