Postgres Pro
Downloads
Home   >   mailing lists

Re: Would a BGW need shmem_access or database_connection to enumeratedatabases? - Mailing list pgsql-hackers

From Chapman Flack
Subject Re: Would a BGW need shmem_access or database_connection to enumeratedatabases?
Date
Msg-id 73e2a806-08df-d4ad-c51f-f46f8d349f5f@anastigmatix.net
Whole thread Raw
In response to Would a BGW need shmem_access or database_connection to enumeratedatabases?  (Chapman Flack <chap@anastigmatix.net>)
Responses Re: Would a BGW need shmem_access or database_connection to enumerate databases?  (Robert Haas <robertmhaas@gmail.com>)
Re: Would a BGW need shmem_access or database_connection to enumerate databases?  (Craig Ringer <craig@2ndquadrant.com>)
List pgsql-hackers
Tree view 
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?

Put another way, can a BGW be regarded as a "regular backend" for the
purpose of this rule?

-Chap

pgsql-hackers by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: Allowing SSL connection of v11 client to v10 server with SCRAMchannel binding
Next
From: Robert Haas
Date:
Subject: Re: Use of uninitialized variables in ExecFindPartition() for parentpartition without leaves (HEAD only)