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 1s9oJW-005Ie6-Ph for pgsql-general@arkaria.postgresql.org; Wed, 22 May 2024 15:55:40 +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 1s9oJW-000mWa-0n for pgsql-general@arkaria.postgresql.org; Wed, 22 May 2024 15:55:38 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1s9oJV-000mWR-EG for pgsql-general@lists.postgresql.org; Wed, 22 May 2024 15:55:37 +0000 Received: from mail.uk.thalesgroup.com ([192.93.165.134]) by magus.postgresql.org with esmtps (TLS1.2) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1s9oJS-000E0V-4y for pgsql-general@lists.postgresql.org; Wed, 22 May 2024 15:55:36 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=uk.thalesgroup.com; q=dns/txt; s=B01; t=1716393334; x=1747929334; h=from:to:subject:date:message-id: content-transfer-encoding:mime-version; bh=9zwBwowaKViiPMW9vEATjSTVOizMzOuRPsoBxYZxYzk=; b=Ye0XhCWiRR8EjL6J+gWya9ZSpxIilbr80qV/CERmrZ6sbAU2Z41AE2rx 3b/orbCHmU6HKKrxNZ+l8NNqo+7UESlmBnuozg4uGu7tmAnHWslukO76x uNBI2Zo+pnFlT5BxJ4v5s5mQ9irUBgkh9hmZ+USL5A0MBJ+IG4GU6rxtB qMITV9a7sKi7HSUDLWzqHRypvTw/cZ7ty9pwr3wttY7v6L6lj1OAVymTV OfKqZkissC2c3McM2HLP1hEQ+1jrDqFwUML5c037Ky31Zr1/bU9twZEr3 gPG/2+phkwkQfKHlXTARkycolZ2Kf9LZBvCviHmDJ+DynrJRkMEGxqG3t Q==; X-IronPort-AV: E=Sophos;i="6.08,181,1712617200"; d="scan'208";a="19848872" 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: AdqsYARB6lT7MloSQu6KnkszXY+6jQ== Date: Wed, 22 May 2024 15:55:32 +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-22T15:55:28Z; 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=a2335b40-63ba-4db8-95d9-3e9c0f2ce423; 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 Q2xhc3NpZmllZCBhczoge09QRU59DQoNCj4gaHR0cHM6Ly93d3cucG9zdGdyZXNxbC5vcmcvZG9j cy8xNS9yZWxlYXNlLTE1LTUuaHRtbCNpZC0xLjExLjYuNy40DQoNCj4gRml4IHJhY2UgY29uZGl0 aW9uIGluIGRhdGFiYXNlIGRyb3BwaW5nIHRoYXQgY291bGQgbGVhZCB0byB0aGUgYXV0b3ZhY3V1 bSBsYXVuY2hlciBnZXR0aW5nIHN0dWNrDQoNCldvdywgdGhhdCBzb3VuZHMgbGlrZSBvdXIgcHJv YmxlbSENCg0KSSB3aWxsIGludmVzdGlnYXRlLiAgTWF5YmUgdHJ5IGFuZCBmaW5kIHRoZSBvcnBo YW5lZCBzdGF0cyBlbnRyeSB0byBwcm92ZSBpdC4NCg0KUGhpbCBIb3JkZXINCkRhdGFiYXNlIE1l Y2hhbmljDQoNClRoYWxlcw0KTGFuZCAmIEFpciBTeXN0ZW1zDQoNCg0Ke09QRU59DQpUaGUgaW5m b3JtYXRpb24gY29udGFpbmVkIGluIHRoaXMgZS1tYWlsIGlzIGNvbmZpZGVudGlhbC4gSXQgaXMg aW50ZW5kZWQgb25seSBmb3IgdGhlIHN0YXRlZCBhZGRyZXNzZWUocykgYW5kIGFjY2VzcyB0byBp dCBieSBhbnkgb3RoZXIgcGVyc29uIGlzIHVuYXV0aG9yaXNlZC4gSWYgeW91IGFyZSBub3QgYW4g YWRkcmVzc2VlLCB5b3UgbXVzdCBub3QgZGlzY2xvc2UsIGNvcHksIGNpcmN1bGF0ZSBvciBpbiBh bnkgb3RoZXIgd2F5IHVzZSBvciByZWx5IG9uIHRoZSBpbmZvcm1hdGlvbiBjb250YWluZWQgaW4g dGhpcyBlLW1haWwuIFN1Y2ggdW5hdXRob3Jpc2VkIHVzZSBtYXkgYmUgdW5sYXdmdWwuIElmIHlv dSBoYXZlIHJlY2VpdmVkIHRoaXMgZS1tYWlsIGluIGVycm9yLCBwbGVhc2UgaW5mb3JtIHRoZSBv cmlnaW5hdG9yIGltbWVkaWF0ZWx5IGFuZCBkZWxldGUgaXQgYW5kIGFsbCBjb3BpZXMgZnJvbSB5 b3VyIHN5c3RlbS4NCg0KVGhhbGVzIFVLIExpbWl0ZWQuIEEgY29tcGFueSByZWdpc3RlcmVkIGlu IEVuZ2xhbmQgYW5kIFdhbGVzLiBSZWdpc3RlcmVkIE9mZmljZTogMzUwIExvbmd3YXRlciBBdmVu dWUsIEdyZWVuIFBhcmssIFJlYWRpbmcsIEJlcmtzIFJHMiA2R0YuIFJlZ2lzdGVyZWQgTnVtYmVy OiA4NjgyNzMNCg0KUGxlYXNlIGNvbnNpZGVyIHRoZSBlbnZpcm9ubWVudCBiZWZvcmUgcHJpbnRp bmcgYSBoYXJkIGNvcHkgb2YgdGhpcyBlLW1haWwuDQo=