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

From: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
To: HORDER Philip <Phil(dot)Horder(at)uk(dot)thalesgroup(dot)com>, "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: Restore of a reference database kills the auto analyze processing.
Date: 2024-05-02 16:59:08
Message-ID: 5cff371d-3c3f-41a6-894c-bff3fc79bd96@aklaver.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(dot)klaver(at)aklaver(dot)com

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2024-05-02 18:41:53 Re: Restore of a reference database kills the auto analyze processing.
Previous Message HORDER Philip 2024-05-02 15:52:50 Restore of a reference database kills the auto analyze processing.