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
Attachment:
signature.asc
Description: PGP signature
