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 1s9WLO-002vEu-Lf for pgsql-general@arkaria.postgresql.org; Tue, 21 May 2024 20:44:24 +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 1s9WLO-00CXmA-Hg for pgsql-general@arkaria.postgresql.org; Tue, 21 May 2024 20:44:22 +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 1s9WLO-00CXlz-0C for pgsql-general@lists.postgresql.org; Tue, 21 May 2024 20:44:22 +0000 Received: from mail.uk.thalesgroup.com ([192.93.164.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 1s9WLL-0005ns-36 for pgsql-general@lists.postgresql.org; Tue, 21 May 2024 20:44:21 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=uk.thalesgroup.com; q=dns/txt; s=A01; t=1716324259; x=1747860259; h=from:to:subject:date:message-id: content-transfer-encoding:mime-version; bh=9E/7hqUkqhDxyReA6lU6j7/NULxi05mv3tcdQ/mOf+M=; b=wbjtLQVxUk5dN0uhVBiqSGGPN8uF7DWJ6igsEUEpwt5t8sukJpkjwWss XWN7HckHBCuYaEiypkiOU7ZoUJIxCxWVVAw3Z+yHBOfprh6Vu3CMcGYXz 0CGz8vR+HbH1nJO1ZouZTFCGvYWSqWYomRFxaQnvGIL+oLywreZcaZ1nh YVQYUzNjy2VW7tk6wz/xkeZdc0SiNZiZF6ZITzijtIh1b5WIx0LzUsazL C1WBgopxM0EoKCub1tyHkNSmYtpj0Yq+60muZynMCwzXPaIv1ZoH+GSpd B61yOlZMUIT8KFd0XtgqXllsULuLJy6J9N4WncAcNLUurBJWKyENKIICW Q==; X-IronPort-AV: E=Sophos;i="6.08,178,1712617200"; d="scan'208";a="126676159" 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: Adqrv4cvzxmeR8KRQC63pOSLjiKG9g== Date: Tue, 21 May 2024 20:44:16 +0000 Message-ID: <4cab5b3f6b9b4e31803451c2fba836c4@uk.thalesgroup.com> 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-21T20:44:13Z; 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=644e9400-f1ef-4eee-994a-e86ca9f38301; 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 Q2xhc3NpZmllZCBhczoge09QRU59DQoNCjIwMjQtMDUtMTUgMDM6MzE6MzEuMjkwIEdNVCBbNDU1 Nl06IFszLTFdDQpkYj1sZm0sdXNlcj1zdXBlcnVzZXIsYXBwPVt1bmtub3duXSxjbGllbnQ9Ojox IExPRzogIGNvbm5lY3Rpb24NCmF1dGhvcml6ZWQ6IHVzZXI9c3VwZXJ1c2VyIGRhdGFiYXNlPWxm bSBhcHBsaWNhdGlvbl9uYW1lPXBnX3Jlc3RvcmUNCg0KPiBUaGF0IHdvdWxkIGJlIHRoZSBsZm0g ZGF0YWJhc2UgYmVpbmcgcmVzdG9yZWQuDQo+IFdoYXQgZG9lcyB0aGUgbG9nIHNob3cgYWZ0ZXIg dGhhdCBhcyBwZXJ0YWlucyB0byBhdXRvdmFjdXVtPw0KDQpZZXAsIHBnX3Jlc3RvcmUgcmVjcmVh dGVzIHRoZSBkcm9wcGVkIGxmbSBkYXRhYmFzZS4NCkFuZCBhZnRlciB0aGF0Li4uLiBub3RoaW5n Lg0KVGhlIGxvZyBqdXN0IGhvbGRzIGNvbm5lY3Rpb24gcmVxdWVzdHMsIGFuZCBhIGNoZWNrcG9p bnQgZXZlcnkgaG91ci4NClRoYXQncyBpdC4NCk5vICJhdXRvbWF0aWMgdmFjdXVtIiwgb3IgImF1 dG9tYXRpYyBhbmFseXplIiBhbnl3aGVyZS4NCkFuZCBub3RoaW5nIGFueSBkYXkgc2luY2UgdGhl biwgZm9yIGEgd2Vlay4NCg0KUGhpbCBIb3JkZXINCkRhdGFiYXNlIE1lY2hhbmljDQoNClRoYWxl cw0KTGFuZCAmIEFpciBTeXN0ZW1zDQoNCg0Ke09QRU59DQpUaGUgaW5mb3JtYXRpb24gY29udGFp bmVkIGluIHRoaXMgZS1tYWlsIGlzIGNvbmZpZGVudGlhbC4gSXQgaXMgaW50ZW5kZWQgb25seSBm b3IgdGhlIHN0YXRlZCBhZGRyZXNzZWUocykgYW5kIGFjY2VzcyB0byBpdCBieSBhbnkgb3RoZXIg cGVyc29uIGlzIHVuYXV0aG9yaXNlZC4gSWYgeW91IGFyZSBub3QgYW4gYWRkcmVzc2VlLCB5b3Ug bXVzdCBub3QgZGlzY2xvc2UsIGNvcHksIGNpcmN1bGF0ZSBvciBpbiBhbnkgb3RoZXIgd2F5IHVz ZSBvciByZWx5IG9uIHRoZSBpbmZvcm1hdGlvbiBjb250YWluZWQgaW4gdGhpcyBlLW1haWwuIFN1 Y2ggdW5hdXRob3Jpc2VkIHVzZSBtYXkgYmUgdW5sYXdmdWwuIElmIHlvdSBoYXZlIHJlY2VpdmVk IHRoaXMgZS1tYWlsIGluIGVycm9yLCBwbGVhc2UgaW5mb3JtIHRoZSBvcmlnaW5hdG9yIGltbWVk aWF0ZWx5IGFuZCBkZWxldGUgaXQgYW5kIGFsbCBjb3BpZXMgZnJvbSB5b3VyIHN5c3RlbS4NCg0K VGhhbGVzIFVLIExpbWl0ZWQuIEEgY29tcGFueSByZWdpc3RlcmVkIGluIEVuZ2xhbmQgYW5kIFdh bGVzLiBSZWdpc3RlcmVkIE9mZmljZTogMzUwIExvbmd3YXRlciBBdmVudWUsIEdyZWVuIFBhcmss IFJlYWRpbmcsIEJlcmtzIFJHMiA2R0YuIFJlZ2lzdGVyZWQgTnVtYmVyOiA4NjgyNzMNCg0KUGxl YXNlIGNvbnNpZGVyIHRoZSBlbnZpcm9ubWVudCBiZWZvcmUgcHJpbnRpbmcgYSBoYXJkIGNvcHkg b2YgdGhpcyBlLW1haWwuDQo=