Re: Restore of a reference database kills the auto analyze processing.

On 5/2/24 8:52 AM, HORDER Philip wrote:
> Running Postgres 15.3 with PostGIS 3.3
> 
> On Windows 10 (yes, I know)
> 
> It’s a single node db with no replication, topping out at about 200GB.
> 
> We have a schema (A) in the default 'postgres' maintenance database, 
> which our software services connect to, with one set of users (SU)
> 
> We have another database, let’s call it LFM, which contains reference 
> data for some COTS software.  I don't know what's in it, we just get 
> given updates for it in pg_backup binary files, about 2MB each.

Do you mean pg_basebackup, pg_dump or something else?


-- 
Adrian Klaver
adrian.klaver@aklaver.com