Re: Restore of a reference database kills the auto analyze processing. - Mailing list pgsql-general

From Adrian Klaver
Subject Re: Restore of a reference database kills the auto analyze processing.
Date
Msg-id 5cff371d-3c3f-41a6-894c-bff3fc79bd96@aklaver.com
Whole thread Raw
In response to Restore of a reference database kills the auto analyze processing.  (HORDER Philip <Phil.Horder@uk.thalesgroup.com>)
Responses RE: Restore of a reference database kills the auto analyze processing.
List pgsql-general

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



pgsql-general by date:

Previous
From: HORDER Philip
Date:
Subject: Restore of a reference database kills the auto analyze processing.
Next
From: Adrian Klaver
Date:
Subject: Re: Restore of a reference database kills the auto analyze processing.