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

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

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

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