Re: Is child process of postmaster able to access all the databases?

2018-08-29 Thread Tom Lane
Hubert Zhang  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



Is child process of postmaster able to access all the databases?

2018-08-29 Thread Hubert Zhang
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