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 1s9SN5-002QZF-7x for pgsql-general@arkaria.postgresql.org; Tue, 21 May 2024 16:29:53 +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 1s9SN5-00B9gM-2v for pgsql-general@arkaria.postgresql.org; Tue, 21 May 2024 16:29:51 +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 1s9SN4-00B9gC-HS for pgsql-general@lists.postgresql.org; Tue, 21 May 2024 16:29:50 +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 1s9SN1-0003s8-Op for pgsql-general@lists.postgresql.org; Tue, 21 May 2024 16:29:49 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=uk.thalesgroup.com; q=dns/txt; s=B01; t=1716308988; x=1747844988; h=from:to:subject:date:message-id: content-transfer-encoding:mime-version; bh=JFcnGaDIVmvWcmqBhW0Vp88pgHO9RMaLazF5Yh18yt4=; b=GmMim7YKjyBqVVrZoBnabPI+oewaq6KXhu8wJnYocUPM4BbA2XUh80f7 eN7APkkNCKtzBM4rQ08iuHjwfMZmJGTjPwkZTVaf4WfJJ1ORXws2knU+0 eFYkf8KnDn/DwHRGEGxNkscqlM1PaEwIUTUXWhLYHwglr/BcoeX958HKI YH5y9dRUblHdAdL2jdTcPrHX+HXJGmrNmqLcmRdH2HOMSlG5/Qf9295eV cfs2EMyijRvEOMQ83MDcdUSB/5z3zHJCvxtXSa3+cF1er5wlZuaXewL+P mvtPdKRgsYy9xiUS3g2K1QlhZyvysbh31qyk77yzr3PweN9rVmb36/R9M A==; X-IronPort-AV: E=Sophos;i="6.08,178,1712617200"; d="scan'208";a="19786840" 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: AdqrnA9iWzzQG4DGQvWzAlz/wDKNrw== Date: Tue, 21 May 2024 16:29:45 +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-21T16:29:42Z; 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=4e32b9df-bea0-4b67-a522-0d06e6b19374; 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 Q2xhc3NpZmllZCBhczoge09QRU59DQoNCj4gSSBhbSBoYXZpbmcgYSBoYXJkIHRpbWUgZmlndXJp bmcgb3V0IGhvdyBib3RoIG9mIHRoZSBhYm92ZSBjYW4gYmUgdHJ1ZS4NCj4gRHJvcHBpbmcgYW5k IHJlY3JlYXRpbmcgdGhlIGRhdGFiYXNlIHdvdWxkIHdpcGUgb3V0IHRoZSBzdGF0aXN0aWNzLg0K DQpXZSBoYXZlIG11bHRpcGxlIGRhdGFiYXNlcyBvbiB0aGUgb25lIFBvc3RncmVzIHNlcnZlci4N ClRoZSAncG9zdGdyZXMnIGRhdGFiYXNlIGNvbnRhaW5zIG91ciBtYWluIGFwcGxpY2F0aW9uLCB3 aXRoIHRhYmxlcyBpbiBzY2hlbWEgJ2EnLg0KV2UgaGF2ZSB0d28gb3RoZXIgZGF0YWJhc2VzLCBv bmUgb2Ygd2hpY2ggaXMgJ2xmbScuDQoNCkluIFBnQWRtaW4sIHRoZXJlIGlzIERhdGFiYXNlcyAo MyksIHRoZW4gdGhvc2UgZGF0YWJhc2UgbmFtZXMuDQpBcyB0aGUgc3VwZXJ1c2VyLCBJIGNhbiBj b25uZWN0IHRvIGFueSBvZiB0aGVzZSBkYXRhYmFzZXMuDQoNCldoZW4gd2UgZHJvcCBkYXRhYmFz ZSBsZm0sIGFuZCByZWNyZWF0ZSBpdCB1c2luZyBwZ19yZXN0b3JlLCB0aGUgc3RhdHMgY29sbGVj dGlvbiBkaWVzLCBmb3IgYWxsIGRhdGFiYXNlcyBvbiB0aGUgc2VydmVyOiAncG9zdGdyZXMnLCAn bGZtJywgJ2xmbTInDQpJIGhhdmVuJ3QgZHJvcHBlZCBkYXRhYmFzZSAncG9zdGdyZXMnDQoNClNv IHRoZSBleGlzdGluZyBzdGF0cyBvbiB0YWJsZXMgaW4gdGhlICdwb3N0Z3JlcycgZGF0YWJhc2Ug cmVtYWluLCBidXQgbm8gZnVydGhlciBzdGF0cyBhcmUgY29sbGVjdGVkLg0KDQpQaGlsIEhvcmRl cg0KRGF0YWJhc2UgTWVjaGFuaWMNCg0KVGhhbGVzDQpMYW5kICYgQWlyIFN5c3RlbXMNCg0KDQp7 T1BFTn0NClRoZSBpbmZvcm1hdGlvbiBjb250YWluZWQgaW4gdGhpcyBlLW1haWwgaXMgY29uZmlk ZW50aWFsLiBJdCBpcyBpbnRlbmRlZCBvbmx5IGZvciB0aGUgc3RhdGVkIGFkZHJlc3NlZShzKSBh bmQgYWNjZXNzIHRvIGl0IGJ5IGFueSBvdGhlciBwZXJzb24gaXMgdW5hdXRob3Jpc2VkLiBJZiB5 b3UgYXJlIG5vdCBhbiBhZGRyZXNzZWUsIHlvdSBtdXN0IG5vdCBkaXNjbG9zZSwgY29weSwgY2ly Y3VsYXRlIG9yIGluIGFueSBvdGhlciB3YXkgdXNlIG9yIHJlbHkgb24gdGhlIGluZm9ybWF0aW9u IGNvbnRhaW5lZCBpbiB0aGlzIGUtbWFpbC4gU3VjaCB1bmF1dGhvcmlzZWQgdXNlIG1heSBiZSB1 bmxhd2Z1bC4gSWYgeW91IGhhdmUgcmVjZWl2ZWQgdGhpcyBlLW1haWwgaW4gZXJyb3IsIHBsZWFz ZSBpbmZvcm0gdGhlIG9yaWdpbmF0b3IgaW1tZWRpYXRlbHkgYW5kIGRlbGV0ZSBpdCBhbmQgYWxs IGNvcGllcyBmcm9tIHlvdXIgc3lzdGVtLg0KDQpUaGFsZXMgVUsgTGltaXRlZC4gQSBjb21wYW55 IHJlZ2lzdGVyZWQgaW4gRW5nbGFuZCBhbmQgV2FsZXMuIFJlZ2lzdGVyZWQgT2ZmaWNlOiAzNTAg TG9uZ3dhdGVyIEF2ZW51ZSwgR3JlZW4gUGFyaywgUmVhZGluZywgQmVya3MgUkcyIDZHRi4gUmVn aXN0ZXJlZCBOdW1iZXI6IDg2ODI3Mw0KDQpQbGVhc2UgY29uc2lkZXIgdGhlIGVudmlyb25tZW50 IGJlZm9yZSBwcmludGluZyBhIGhhcmQgY29weSBvZiB0aGlzIGUtbWFpbC4NCg==