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 1sA84T-007jPY-LW for pgsql-general@arkaria.postgresql.org; Thu, 23 May 2024 13:01:27 +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 1sA84R-00CDLD-C7 for pgsql-general@arkaria.postgresql.org; Thu, 23 May 2024 13:01:23 +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 1sA84Q-00CDL4-Pv for pgsql-general@lists.postgresql.org; Thu, 23 May 2024 13:01:23 +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 1sA84N-000Ngi-IR for pgsql-general@lists.postgresql.org; Thu, 23 May 2024 13:01:22 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=uk.thalesgroup.com; q=dns/txt; s=B01; t=1716469281; x=1748005281; h=from:to:subject:date:message-id: content-transfer-encoding:mime-version; bh=C4dAah2YHHtbiIF17OIx3kOtEgjnUOoHq3WgaaBqOBI=; b=FJDZEj1uKsKfeaVYgG271AOAOdddMyeMniDUZYoMG+kzQxswh6W2h7Ng cbPudKUrRSlvHcbPPUbGo0WOA5Qkg+cIfdTc+TqKmxq8UWlgsIF8eHcEU 6D7STwnBIzfPFTDwpgHaasu7gxyKvdmtE5aN8S87XFU9Ldm6p1qykNEqo DumYAi//hCPuzLM0kZa21UeTQpKppUDtNRM7Q28Y/7ddL7iBau3kW8Wg8 L/uRVJbMI1FYwgyfvyFc7o9xkXziFGS01xxeh366OHeaAhPQUE3Fbazx4 jdUwJsh75eZf8dZI+sFh0r496+EM1KLZcd3NXsiLVv/cHlmHqsMNNJqOQ Q==; X-IronPort-AV: E=Sophos;i="6.08,182,1712617200"; d="scan'208";a="19894627" 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: AdqtEKPdpXQc3LlHTAqusuICjAq4Qw== Date: Thu, 23 May 2024 13:01:16 +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-23T13:01:14Z; 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=d176c168-63c8-4fb2-9db1-368a668bf143; 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 Q2xhc3NpZmllZCBhczoge09QRU59DQoNCkkgYWN0dWFsbHkgaGFkbid0IHRob3VnaHQgdG8gbG9v ayBmb3IgUG9zdGdyZXMgYnVncywgdGhlIHN5c3RlbSBpcyBzbyByZWxpYWJsZSBmb3IgdXMsIGl0 IGp1c3QgZG9lc24ndCBnbyB3cm9uZyENCg0KSSBjYW4gdHJpZ2dlciB0aGUgZmF1bHQgYmUgcnVu bmluZyBhIHJlbG9hZCBvZiB0aGUgbGZtIGRhdGFiYXNlLCBhbmQgd2UndmUgYmVlbiBydW5uaW5n IFBvc3RncmVzIDEwICYgMTMgZm9yIHNldmVyYWwgeWVhcnMgbm93IHdpdGhvdXQgc2VlaW5nIHRo aXMgcHJvYmxlbS4NCg0KT3VyIHN5bXB0b21zIG1hdGNoIHRoYXQgYnVnIGRlc2NyaXB0aW9uIGV4 YWN0bHksIHNvIEknbSBwcmV0dHkgY29uZmlkZW50IHRoaXMgaXMgdGhlIHByb2JsZW0uDQpJJ2xs IGhhdmUgdG8gcHVzaCB0aHJvdWdoIHRoZSByaWdodCBwYXBlcndvcmsgdG8gZ2V0IGEgUG9zdGdy ZXMgdXBkYXRlLCBhbmQgdGhhdCB3aWxsIHRha2UgYSB3aGlsZQ0KDQpUaGFuayB5b3Ugc28gbXVj aCBmb3IgeW91ciB0aW1lLg0KDQpQaGlsIEhvcmRlcg0KRGF0YWJhc2UgTWVjaGFuaWMNCg0KVGhh bGVzDQpMYW5kICYgQWlyIFN5c3RlbXMNCg0KDQp7T1BFTn0NClRoZSBpbmZvcm1hdGlvbiBjb250 YWluZWQgaW4gdGhpcyBlLW1haWwgaXMgY29uZmlkZW50aWFsLiBJdCBpcyBpbnRlbmRlZCBvbmx5 IGZvciB0aGUgc3RhdGVkIGFkZHJlc3NlZShzKSBhbmQgYWNjZXNzIHRvIGl0IGJ5IGFueSBvdGhl ciBwZXJzb24gaXMgdW5hdXRob3Jpc2VkLiBJZiB5b3UgYXJlIG5vdCBhbiBhZGRyZXNzZWUsIHlv dSBtdXN0IG5vdCBkaXNjbG9zZSwgY29weSwgY2lyY3VsYXRlIG9yIGluIGFueSBvdGhlciB3YXkg dXNlIG9yIHJlbHkgb24gdGhlIGluZm9ybWF0aW9uIGNvbnRhaW5lZCBpbiB0aGlzIGUtbWFpbC4g U3VjaCB1bmF1dGhvcmlzZWQgdXNlIG1heSBiZSB1bmxhd2Z1bC4gSWYgeW91IGhhdmUgcmVjZWl2 ZWQgdGhpcyBlLW1haWwgaW4gZXJyb3IsIHBsZWFzZSBpbmZvcm0gdGhlIG9yaWdpbmF0b3IgaW1t ZWRpYXRlbHkgYW5kIGRlbGV0ZSBpdCBhbmQgYWxsIGNvcGllcyBmcm9tIHlvdXIgc3lzdGVtLg0K DQpUaGFsZXMgVUsgTGltaXRlZC4gQSBjb21wYW55IHJlZ2lzdGVyZWQgaW4gRW5nbGFuZCBhbmQg V2FsZXMuIFJlZ2lzdGVyZWQgT2ZmaWNlOiAzNTAgTG9uZ3dhdGVyIEF2ZW51ZSwgR3JlZW4gUGFy aywgUmVhZGluZywgQmVya3MgUkcyIDZHRi4gUmVnaXN0ZXJlZCBOdW1iZXI6IDg2ODI3Mw0KDQpQ bGVhc2UgY29uc2lkZXIgdGhlIGVudmlyb25tZW50IGJlZm9yZSBwcmludGluZyBhIGhhcmQgY29w eSBvZiB0aGlzIGUtbWFpbC4NCg==