On 1 December 2017 at 23:04, Chapman Flack <c...@anastigmatix.net> wrote:
> On 11/29/2017 05:48 PM, Chapman Flack wrote: > > I'm thinking of writing a background worker that will enumerate > > the databases present, and spin off, for each one, another BGW > > that will establish a connection and do stuff. > > Can I even do this? > > "Unlike RegisterBackgroundWorker, which can only be called > from within the postmaster, RegisterDynamicBackgroundWorker > must be called from a regular backend." > > Can I call RegisterDynamicBackgroundWorker when not in the postmaster, > but also not in a "regular backend", but rather another BGW? > Yes. BDR does it a lot. -- Craig Ringer http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services
