Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1s7dVp-006ZKl-Kr for pgsql-general@arkaria.postgresql.org; Thu, 16 May 2024 15:59:23 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1s7dVp-00BBpf-D5 for pgsql-general@arkaria.postgresql.org; Thu, 16 May 2024 15:59:21 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1s7dVo-00BBhV-MQ for pgsql-general@lists.postgresql.org; Thu, 16 May 2024 15:59:21 +0000 Received: from mail.uk.thalesgroup.com ([192.93.164.134]) by makus.postgresql.org with esmtps (TLS1.2) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1s7dVh-000WGY-CQ for pgsql-general@lists.postgresql.org; Thu, 16 May 2024 15:59:19 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=uk.thalesgroup.com; q=dns/txt; s=A01; t=1715875153; x=1747411153; h=from:to:subject:date:message-id: content-transfer-encoding:mime-version; bh=z1rdupfFXfnME6LlEJhcRTlhu5We2btdTh2VxqKNaC4=; b=exLbMkJO1WxblUbOrLPAnI0pCxP9YDQB9vWNH4VOjN3tjEBx6OgS7pmU mpa1mptjS1d3feiH51QYYCpOnU/Q8Tpb/NMLTIylYdAlfyAinYgWL/2DK 8nkFaqVHW80PfZcdmqKhxMhBnZVq80VJAJwgpWWv0/AERTYP2hZ9ohTmC WoXq/ZWRqb6QqL/9go3J2vq0qC8o4hVQFfTIYTxBWOGYwD53n78IQZuhH pq5UjXtjHZlvqSFuTmoCz9JCO2ug8ScLusSDmGtxhclhSCGZcxuOgtuaM en4AAvaWAQM38B87WWd31kvsGe7k+LwI6IATW2SS6lBvP35AsoBkCvA+R Q==; X-IronPort-AV: E=Sophos;i="6.08,165,1712617200"; d="scan'208";a="126481757" X-Trellix: Whitelist From: HORDER Philip To: Adrian Klaver , "pgsql-general@lists.postgresql.org" Subject: Re: Restore of a reference database kills the auto analyze processing. Thread-Topic: Restore of a reference database kills the auto analyze processing. Thread-Index: AdqnqekxcS0v9JwdQ5WJyuprWk82kw== Date: Thu, 16 May 2024 15:59:03 +0000 Message-ID: Accept-Language: en-GB, en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: msip_labels: MSIP_Label_64c9cc36-7289-4c96-81d0-25ee8eefd11d_Enabled=true; MSIP_Label_64c9cc36-7289-4c96-81d0-25ee8eefd11d_SetDate=2024-05-16T15:59:01Z; MSIP_Label_64c9cc36-7289-4c96-81d0-25ee8eefd11d_Method=Privileged; MSIP_Label_64c9cc36-7289-4c96-81d0-25ee8eefd11d_Name=THALES-CORE-01; MSIP_Label_64c9cc36-7289-4c96-81d0-25ee8eefd11d_SiteId=6e603289-5e46-4e26-ac7c-03a85420a9a5; MSIP_Label_64c9cc36-7289-4c96-81d0-25ee8eefd11d_ActionId=419d75ec-2c58-4596-a4bc-7d0ece920535; MSIP_Label_64c9cc36-7289-4c96-81d0-25ee8eefd11d_ContentBits=3 thales-sensitivity: {TGOPEN} Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: base64 MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Q2xhc3NpZmllZCBhczoge09QRU59DQoNCkFkcmlhbiwNCg0KPiBTdGlsbCB5b3VyIGNvbnRlbnRp b24gd2FzIHRoYXQgYXV0b3ZhY3V1bSBxdWl0IHJ1bm5pbmcgYWZ0ZXIgdGhlIGluaXRpYWwgcmVz dG9yZSBhbmQgdGhhdCBpcyBub3QgdGhlIGNhc2UuLi4uDQoNClRoaXMgUG9zdGdyZXMgc2VydmVy IGhhcyBiZWVuIHJlc3RhcnRlZCBhIGZldyB0aW1lcyBzaW5jZSAybmQgTWF5IG1vc3QgcmVjZW50 bHkgb24gVHVlc2RheSAxNHRoLCBoZW5jZSB0aGUgbW9yZSByZWNlbnQgYW5hbHl6ZSBzdGF0dXMu DQoNCldlJ3ZlIGhhZCBzb21lIHByb2JsZW1zIHdpdGggb3VyIGRhdGEgZmVlZHMgb24gdGhpcyBp bnRlZ3JhdGlvbiBzeXN0ZW0sIGJ1dCB0aGVzZSBhcmUgbm93IHJ1bm5pbmcgYWdhaW4uDQpJJ20g cGxhbm5pbmcgdG8gbGVhdmUgaXQgYWxsIGFsb25lIHVudGlsIEknbSBiYWNrIGluIHRoZSBvZmZp Y2Ugb24gVHVlc2RheSwgYW5kIHJ1biB0aGlzIHF1ZXJ5IGFnYWluIGZvciBhIGZldyB0YWJsZXMg YW5kIHNlbmQgeW91IGFuIHVwZGF0ZS4NCkknbSBleHBlY3Rpbmcgbm8gZnVydGhlciBzdGF0cyBh bmFseXNpcywgKGFuZCB0aGUgcGVyZm9ybWFuY2UgdG8gYmUgYXBwYWxsaW5nKS4NCg0KVGhhbmtz IGZvciB5b3VyIHRpbWUuDQoNClBoaWwgSG9yZGVyDQpEYXRhYmFzZSBNZWNoYW5pYw0KDQpUaGFs ZXMNCkxhbmQgJiBBaXIgU3lzdGVtcw0KDQoNCntPUEVOfQ0KVGhlIGluZm9ybWF0aW9uIGNvbnRh aW5lZCBpbiB0aGlzIGUtbWFpbCBpcyBjb25maWRlbnRpYWwuIEl0IGlzIGludGVuZGVkIG9ubHkg Zm9yIHRoZSBzdGF0ZWQgYWRkcmVzc2VlKHMpIGFuZCBhY2Nlc3MgdG8gaXQgYnkgYW55IG90aGVy IHBlcnNvbiBpcyB1bmF1dGhvcmlzZWQuIElmIHlvdSBhcmUgbm90IGFuIGFkZHJlc3NlZSwgeW91 IG11c3Qgbm90IGRpc2Nsb3NlLCBjb3B5LCBjaXJjdWxhdGUgb3IgaW4gYW55IG90aGVyIHdheSB1 c2Ugb3IgcmVseSBvbiB0aGUgaW5mb3JtYXRpb24gY29udGFpbmVkIGluIHRoaXMgZS1tYWlsLiBT dWNoIHVuYXV0aG9yaXNlZCB1c2UgbWF5IGJlIHVubGF3ZnVsLiBJZiB5b3UgaGF2ZSByZWNlaXZl ZCB0aGlzIGUtbWFpbCBpbiBlcnJvciwgcGxlYXNlIGluZm9ybSB0aGUgb3JpZ2luYXRvciBpbW1l ZGlhdGVseSBhbmQgZGVsZXRlIGl0IGFuZCBhbGwgY29waWVzIGZyb20geW91ciBzeXN0ZW0uDQoN ClRoYWxlcyBVSyBMaW1pdGVkLiBBIGNvbXBhbnkgcmVnaXN0ZXJlZCBpbiBFbmdsYW5kIGFuZCBX YWxlcy4gUmVnaXN0ZXJlZCBPZmZpY2U6IDM1MCBMb25nd2F0ZXIgQXZlbnVlLCBHcmVlbiBQYXJr LCBSZWFkaW5nLCBCZXJrcyBSRzIgNkdGLiBSZWdpc3RlcmVkIE51bWJlcjogODY4MjczDQoNClBs ZWFzZSBjb25zaWRlciB0aGUgZW52aXJvbm1lbnQgYmVmb3JlIHByaW50aW5nIGEgaGFyZCBjb3B5 IG9mIHRoaXMgZS1tYWlsLg0K