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 1s7cFC-006QaZ-V5 for pgsql-general@arkaria.postgresql.org; Thu, 16 May 2024 14:38:08 +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 1s7cFC-00A2dk-UU for pgsql-general@arkaria.postgresql.org; Thu, 16 May 2024 14:38:06 +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 1s7cFC-00A2dc-CV for pgsql-general@lists.postgresql.org; Thu, 16 May 2024 14:38:06 +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 1s7cF9-000YSK-1g for pgsql-general@lists.postgresql.org; Thu, 16 May 2024 14:38:05 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=uk.thalesgroup.com; q=dns/txt; s=B01; t=1715870284; x=1747406284; h=from:to:subject:date:message-id: content-transfer-encoding:mime-version; bh=K/uZANYRSVofkeT2Z1x1b56X969fchJfRqfItbDMY/s=; b=F9KTvh1wXkKoG2GX+jlr7V7o+0zTczTF9QtigAYUm+hsv1hTi9NadhPY 7IJXBnIORT9vJmrA12vYoUjYciLC+iadO6Fuh974UrpmUSbq8kYHXmcDp Y949fyax9Qb3d4Mgud9yyJFPju3/Yg3E+vmNKC1s3psCZJmCIckdCJhlZ wlTSiy4QH5KZGi7C/MSD7T1VNavetE4wNPOpv5i1S0xGpbNF3ndi2nA5D Rlgb1eSCEysQmsNLr0TD4KNYJeTtdn0ARovZDJOJXqmANCUgJhsHYnGXG Bux9R/sykX/nxys53Qc1BSZprGwjPPGerLmiNQiztGUphFhscgJisSeJc Q==; X-IronPort-AV: E=Sophos;i="6.08,164,1712617200"; d="scan'208";a="19601020" 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: AdqnnfbMcS0v9JwdQ5WJyuprWk82kw== Date: Thu, 16 May 2024 14:38:00 +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-16T14:37:56Z; 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=0fdd1d69-cf84-43d4-9d82-51d1be53ad89; 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 Q2xhc3NpZmllZCBhczoge09QRU59DQoNCj4gRGlkIHlvdSBoYXZlIGNoYW5jZSB0byBkbyBiZWxv dz8NCj4gVXNpbmcgcHNxbCBkbw0KDQo+IFx4DQo+IHNlbGVjdCAqIGZyb20gcGdfc3RhdF9hbGxf dGFibGVzIHdoZXJlIHJlbG5hbWUgPSAnYS5hY2NwJzsNCg0KU29ycnksIG1pc3NlZCB0aGF0IGJp dC4NCkZyb20gdGhpcyBvdXRwdXQgeW91IGNhbiBzZWUgdGhhdCBubyBzdGF0cyBoYXZlIGJlZW4g Y29sbGVjdGVkIHNpbmNlIHRoZSBsYXN0IHR3byBvdmVybmlnaHQgdXBkYXRlcy4NCg0KcG9zdGdy ZXM9IyBzZWxlY3QgKiBmcm9tIHBnX3N0YXRfYWxsX3RhYmxlcyB3aGVyZSByZWxuYW1lPSdhY2Nw JzsNCi1bIFJFQ09SRCAxIF0tLS0tLS0tKy0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t DQpyZWxpZCAgICAgICAgICAgICAgIHwgODExNDg2MzgxDQpzY2hlbWFuYW1lICAgICAgICAgIHwg YQ0KcmVsbmFtZSAgICAgICAgICAgICB8IGFjY3ANCnNlcV9zY2FuICAgICAgICAgICAgfCAxNjU0 NzY3DQpzZXFfdHVwX3JlYWQgICAgICAgIHwgOTAxODExODgwDQppZHhfc2NhbiAgICAgICAgICAg IHwgMTQ2MDcwMzgzDQppZHhfdHVwX2ZldGNoICAgICAgIHwgMzA1OTQ5OTY5DQpuX3R1cF9pbnMg ICAgICAgICAgIHwgMjA1Njk0OA0Kbl90dXBfdXBkICAgICAgICAgICB8IDANCm5fdHVwX2RlbCAg ICAgICAgICAgfCAxNjYyNjk5DQpuX3R1cF9ob3RfdXBkICAgICAgIHwgMA0Kbl9saXZlX3R1cCAg ICAgICAgICB8IDI5NA0Kbl9kZWFkX3R1cCAgICAgICAgICB8IDc1MTYyDQpuX21vZF9zaW5jZV9h bmFseXplIHwgMA0Kbl9pbnNfc2luY2VfdmFjdXVtICB8IDc1MTYyDQpsYXN0X3ZhY3V1bSAgICAg ICAgIHwNCmxhc3RfYXV0b3ZhY3V1bSAgICAgfCAyMDI0LTA1LTE1IDAzOjI1OjE2LjAwNzM4Nisw MA0KbGFzdF9hbmFseXplICAgICAgICB8DQpsYXN0X2F1dG9hbmFseXplICAgIHwgMjAyNC0wNS0x NSAwMzoyNToxNi4wMDg4NzMrMDANCnZhY3V1bV9jb3VudCAgICAgICAgfCAwDQphdXRvdmFjdXVt X2NvdW50ICAgIHwgMTg4OA0KYW5hbHl6ZV9jb3VudCAgICAgICB8IDE5ODM2DQphdXRvYW5hbHl6 ZV9jb3VudCAgIHwgMTcxNQ0KDQoNClBoaWwgSG9yZGVyDQpEYXRhYmFzZSBNZWNoYW5pYw0KDQpU aGFsZXMNCkxhbmQgJiBBaXIgU3lzdGVtcw0KDQoNCntPUEVOfQ0KVGhlIGluZm9ybWF0aW9uIGNv bnRhaW5lZCBpbiB0aGlzIGUtbWFpbCBpcyBjb25maWRlbnRpYWwuIEl0IGlzIGludGVuZGVkIG9u bHkgZm9yIHRoZSBzdGF0ZWQgYWRkcmVzc2VlKHMpIGFuZCBhY2Nlc3MgdG8gaXQgYnkgYW55IG90 aGVyIHBlcnNvbiBpcyB1bmF1dGhvcmlzZWQuIElmIHlvdSBhcmUgbm90IGFuIGFkZHJlc3NlZSwg eW91IG11c3Qgbm90IGRpc2Nsb3NlLCBjb3B5LCBjaXJjdWxhdGUgb3IgaW4gYW55IG90aGVyIHdh eSB1c2Ugb3IgcmVseSBvbiB0aGUgaW5mb3JtYXRpb24gY29udGFpbmVkIGluIHRoaXMgZS1tYWls LiBTdWNoIHVuYXV0aG9yaXNlZCB1c2UgbWF5IGJlIHVubGF3ZnVsLiBJZiB5b3UgaGF2ZSByZWNl aXZlZCB0aGlzIGUtbWFpbCBpbiBlcnJvciwgcGxlYXNlIGluZm9ybSB0aGUgb3JpZ2luYXRvciBp bW1lZGlhdGVseSBhbmQgZGVsZXRlIGl0IGFuZCBhbGwgY29waWVzIGZyb20geW91ciBzeXN0ZW0u DQoNClRoYWxlcyBVSyBMaW1pdGVkLiBBIGNvbXBhbnkgcmVnaXN0ZXJlZCBpbiBFbmdsYW5kIGFu ZCBXYWxlcy4gUmVnaXN0ZXJlZCBPZmZpY2U6IDM1MCBMb25nd2F0ZXIgQXZlbnVlLCBHcmVlbiBQ YXJrLCBSZWFkaW5nLCBCZXJrcyBSRzIgNkdGLiBSZWdpc3RlcmVkIE51bWJlcjogODY4MjczDQoN ClBsZWFzZSBjb25zaWRlciB0aGUgZW52aXJvbm1lbnQgYmVmb3JlIHByaW50aW5nIGEgaGFyZCBj b3B5IG9mIHRoaXMgZS1tYWlsLg0K