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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Hubert Zhang <hzhang(at)pivotal(dot)io>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Is child process of postmaster able to access all the databases?
Date: 2018-08-29 15:33:07
Message-ID: 17954.1535556787@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hubert Zhang <hzhang(at)pivotal(dot)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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2018-08-29 15:35:51 Re: 10.5 but not 10.4: backend startup during reindex system: could not read block 0 in file "base/16400/..": read only 0 of 8192 bytes
Previous Message Tom Lane 2018-08-29 15:30:27 Re: buildfarm: could not read block 3 in file "base/16384/2662": read only 0 of 8192 bytes