Is child process of postmaster able to access all the databases?
Started by Hubert Zhangover 7 years ago2 messages
Hello all.
background worker can use SPI to read a database, but it can call
BackgroundWorkerInitializeConnection(dbname) only once.
I wonder if there is a way to let a child process of postmaster to access
all the databases one by one?
--
Thanks
Hubert Zhang
Re: Is child process of postmaster able to access all the databases?
Hubert Zhang <hzhang@pivotal.io> writes:
I wonder if there is a way to let a child process of postmaster to access
all the databases one by one?
No. For starters, you'd need some way to flush all database-specific
information from relcache, catcache, and a boatload of other places;
but that logic does not exist.
regards, tom lane