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 1s9hPw-004Mh2-GB for pgsql-general@arkaria.postgresql.org; Wed, 22 May 2024 08:33:50 +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 1s9hPu-00Ezi1-Ek for pgsql-general@arkaria.postgresql.org; Wed, 22 May 2024 08:33:46 +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 1s9hPt-00Ezht-Rz for pgsql-general@lists.postgresql.org; Wed, 22 May 2024 08:33:46 +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 1s9hPp-000AcT-GK for pgsql-general@lists.postgresql.org; Wed, 22 May 2024 08:33:45 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=uk.thalesgroup.com; q=dns/txt; s=B01; t=1716366822; x=1747902822; h=from:to:subject:date:message-id: content-transfer-encoding:mime-version; bh=CU50XMFhvFSIRC7LlSiJOuIxUfVl1zfm6qEVsJ8IcXg=; b=ZFwcx58FA1jgi2Y4oUhyD2tMHM8ci8fj/MOUbikR50dpz5hmGgs3r/lW 13Or0d16G+uO5ZI9wem5baLugdduzP6aWjivrQK5jN4yyUUgCon6yZ1/I GVbtq1DsUTfE4KMTQeZlJlD1upbhYK22M9gOBck182HyZnGH4gIjLOU+5 SbhAi79+mfb+GXwAxecxKrdfAEp1OjXsX7XOBssN0pKzEhQX4TiC3qOGL Dqsjt8Aq4m8qRcRy6Zfi29ev1YNOjMzaLimkhyx22SGMqhB1UgDtAXr5S Fz1fX7rMETDFy3q0hwYdcuBd7GeYkAQSSQI6FNnygxtGrphj6i+GJtfCV Q==; X-IronPort-AV: E=Sophos;i="6.08,179,1712617200"; d="scan'208";a="19810230" 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: AdqsH5Yg6lT7MloSQu6KnkszXY+6jQ== Date: Wed, 22 May 2024 08:33:39 +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-22T08:33:35Z; 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=5b35fd1a-1773-488b-b505-16b6f02d2d91; 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 Q2xhc3NpZmllZCBhczoge09QRU59DQoNCj4gSnVzdCBmb3IgY29uZmlybWF0aW9uIHlvdXIgc2V0 dGluZ3MgYXJlIHN0aWxsPzoNCg0KPiBhdXRvdmFjdXVtX21heF93b3JrZXJzID0gMTANCj4gbG9n X2F1dG92YWN1dW1fbWluX2R1cmF0aW9uID0gMA0KDQpZZXMuDQoNCj4gWW91IHNhaWQgcHJldmlv dXNseToNCj4gIlRoZSBvbmx5IHdheSBJIGNhbiBmaW5kIG9mIGdldHRpbmcgdGhlIGFuYWx5emVy IGJhY2sgaXMgdG8gcmVzdGFydCBQb3N0Z3Jlcy4iDQo+DQo+IFRvIGJlIGNsZWFyIHRoaXMgbWVh bnM6DQo+IDEpIFRoZSBsZm0gZGF0YWJhc2UgaXMgZHJvcHBlZC9jcmVhdGVkLg0KWWVzLCB1c2lu ZyBkcm9wZGIgYW5kIHBnX3Jlc3RvcmUNCg0KPiAyKSBUaGVyZSBpcyBhIHJvdW5kIG9mIGF1dG92 YWN1dW0gaW1tZWRpYXRlbHkgYWZ0ZXIgdGhlIGxmbSBpcyByZXN0b3JlZC4NClllcywgc29tZSB0 YWJsZXMgaW4gdGhlIGxmbSBkYXRhYmFzZSwgYnV0IG5vdCBhbGwsIGFuIGFwcGFyZW50bHkgcmFu ZG9tIHNlbGVjdGlvbiwgYW55d2hlcmUgYmV0d2VlbiAyIGFuZCAyMSB0YWJsZXMsIGFjcm9zcyB0 aGUgbGZtIHNjaGVtYXMsIHB1YmxpYyAmIHBnX2NhdGFsb2cuDQoNCj4gMykgYXV0b3ZhY3V1bSB0 aGVuIGdvZXMgc2lsZW50Lg0KWWVzLiBEZWFkIGluIGEgZGl0Y2guIEJ1dCB3aXRoIG5vIGVycm9y cy4NCg0KPiA0KSBCZWZvcmUgdGhlIG5leHQgZHJvcC9jcmVhdGUgbGZtIHlvdSByZXN0YXJ0IHRo ZSBQb3N0Z3JlcyBzZXJ2ZXIgYW5kIGF1dG92YWN1dW0gc3RhcnRzIGFnYWluLg0KSSBoYXZlbid0 IHJlc3RhcnRlZCBpbiBhIHdlZWssIGFuZCB0aGUgcGF0dGVybiByZW1haW5zLCB3aXRoIGEgYml0 IG9mIGFuYWx5emUgYXQgZWFjaCByZWxvYWQgb2YgbGZtLCBhbmQgdGhlbiBub3RoaW5nLg0KDQo+ IFdoYXQgaXMgaW4gdGhlIGxvZ3Mgd2hlbiB5b3UgZG8gdGhlIHJlc3RhcnQ/DQpOb3RoaW5nIG5v dGFibGU6DQoxKSBkZW5pZWQgY29ubmVjdGlvbnMsIHdoaWxlIHJlc3RhcnRpbmcNCjIpIGF1dGhv cml6ZWQgY29ubmVjdGlvbnMNCjMpIGF1dG8gYW5hbHl6ZSBnb2luZyBpbnRvIG92ZXJkcml2ZToN ClNlZSBiZWxvdw0KDQo+IElzIHRoZXJlIHNvbWUgcHJvY2VzcyB0aGF0IHJ1bnMgc2hvcnRseSBh ZnRlciB0aGUgZHJvcC9jcmVhdGUgbGZtIGN5Y2xlPw0KTm90IHRoYXQgSSBjYW4gc2VlLg0KDQpF eHRyYWN0IG9mIHBvc3RncmVzIGxvZyBmb3IgYSB0eXBpY2FsIHJlc3RhcnQgOg0KMjAyNC0wNS0x MyAwNTo1NjoxOS4xNTEgR01UIFs0Njg4XTogWzk5LTFdIGRiPSx1c2VyPSxhcHA9LGNsaWVudD0g TE9HOiAgc2h1dHRpbmcgZG93bg0KMjAyNC0wNS0xMyAwNTo1NjoxOS4xNjIgR01UIFs0Njg4XTog WzEwMC0xXSBkYj0sdXNlcj0sYXBwPSxjbGllbnQ9IExPRzogIGNoZWNrcG9pbnQgc3RhcnRpbmc6 IHNodXRkb3duIGltbWVkaWF0ZQ0KMjAyNC0wNS0xMyAwNTo1NjoxOS43NTEgR01UIFszNDRdOiBb MS0xXSBkYj1bdW5rbm93bl0sdXNlcj1bdW5rbm93bl0sYXBwPVt1bmtub3duXSxjbGllbnQ9MTEu MjIuMzMuNDQgTE9HOiAgY29ubmVjdGlvbiByZWNlaXZlZDogaG9zdD0xMS4yMi4zMy40NCBwb3J0 PTU0NzMwDQoyMDI0LTA1LTEzIDA1OjU2OjE5Ljc1MiBHTVQgWzM0NF06IFsyLTFdIGRiPXBvc3Rn cmVzLHVzZXI9YV9hLGFwcD1bdW5rbm93bl0sY2xpZW50PTExLjIyLjMzLjQ0IEZBVEFMOiAgdGhl IGRhdGFiYXNlIHN5c3RlbSBpcyBzaHV0dGluZyBkb3duDQoyMDI0LTA1LTEzIDA1OjU2OjE5Ljg0 MyBHTVQgWzQzMjRdOiBbMS0xXSBkYj1bdW5rbm93bl0sdXNlcj1bdW5rbm93bl0sYXBwPVt1bmtu b3duXSxjbGllbnQ9MTEuMjIuMzMuNDQgTE9HOiAgY29ubmVjdGlvbiByZWNlaXZlZDogaG9zdD0x MS4yMi4zMy40NCBwb3J0PTU0NzMxDQoyMDI0LTA1LTEzIDA1OjU2OjE5Ljg0NSBHTVQgWzQzMjRd OiBbMi0xXSBkYj1sZm0yLHVzZXI9ZnNfYWRtaW4sYXBwPVt1bmtub3duXSxjbGllbnQ9MTEuMjIu MzMuNDQgRkFUQUw6ICB0aGUgZGF0YWJhc2Ugc3lzdGVtIGlzIHNodXR0aW5nIGRvd24NCi4uLg0K MjAyNC0wNS0xMyAwNTo1NjoyMC4zMTkgR01UIFs0Njg4XTogWzEwMS0xXSBkYj0sdXNlcj0sYXBw PSxjbGllbnQ9IExPRzogIGNoZWNrcG9pbnQgY29tcGxldGU6IHdyb3RlIDMyNiBidWZmZXJzICgw LjElKTsgMCBXQUwgZmlsZShzKSBhZGRlZCwgMCByZW1vdmVkLCAwIHJlY3ljbGVkOyB3cml0ZT0w LjA3MyBzLCBzeW5jPTEuMDA2IHMsIHRvdGFsPTEuMTY4IHM7IHN5bmMgZmlsZXM9MzMsIGxvbmdl c3Q9MC4yODEgcywgYXZlcmFnZT0wLjAzMSBzOyBkaXN0YW5jZT01ODgga0IsIGVzdGltYXRlPTI2 NDI1IGtCDQoyMDI0LTA1LTEzIDA1OjU3OjEzLjg4OSBHTVQgWzQyMjBdOiBbMS0xXSBkYj0sdXNl cj0sYXBwPSxjbGllbnQ9IExPRzogIGRhdGFiYXNlIHN5c3RlbSB3YXMgc2h1dCBkb3duIGF0IDIw MjQtMDUtMTMgMDU6NTY6MjAgR01UDQoyMDI0LTA1LTEzIDA1OjU3OjEzLjkyMSBHTVQgWzQyMzZd OiBbMS0xXSBkYj1bdW5rbm93bl0sdXNlcj1bdW5rbm93bl0sYXBwPVt1bmtub3duXSxjbGllbnQ9 MTEuMjIuMzMuNDQgTE9HOiAgY29ubmVjdGlvbiByZWNlaXZlZDogaG9zdD0xMS4yMi4zMy40NCBw b3J0PTU0ODYzDQoyMDI0LTA1LTEzIDA1OjU3OjEzLjkyMiBHTVQgWzQyMzZdOiBbMi0xXSBkYj1w b3N0Z3Jlcyx1c2VyPWFfYSxhcHA9W3Vua25vd25dLGNsaWVudD0xMS4yMi4zMy40NCBGQVRBTDog IHRoZSBkYXRhYmFzZSBzeXN0ZW0gaXMgc3RhcnRpbmcgdXANCi4uLg0KMjAyNC0wNS0xMyAwNTo1 NzoxNC41NzIgR01UIFs0ODY4XTogWzEtMV0gZGI9W3Vua25vd25dLHVzZXI9W3Vua25vd25dLGFw cD1bdW5rbm93bl0sY2xpZW50PTExLjIyLjMzLjQ0IExPRzogIGNvbm5lY3Rpb24gcmVjZWl2ZWQ6 IGhvc3Q9MTEuMjIuMzMuNDQgcG9ydD01NDg2OQ0KMjAyNC0wNS0xMyAwNTo1NzoxNC42MDggR01U IFs0ODY4XTogWzItMV0gZGI9bGZtMix1c2VyPWZzX2FkbWluLGFwcD1bdW5rbm93bl0sY2xpZW50 PTExLjIyLjMzLjQ0IExPRzogIGNvbm5lY3Rpb24gYXV0aGVudGljYXRlZDogaWRlbnRpdHk9ImZz X2FkbWluIiBtZXRob2Q9bWQ1IChFOi9Qb3N0Z3JlU1FMLzE1L2RhdGEvcGdfaGJhLmNvbmY6MTA4 KQ0KMjAyNC0wNS0xMyAwNTo1NzoxNC42MDggR01UIFs0ODY4XTogWzMtMV0gZGI9bGZtMix1c2Vy PWZzX2FkbWluLGFwcD1bdW5rbm93bl0sY2xpZW50PTExLjIyLjMzLjQ0IExPRzogIGNvbm5lY3Rp b24gYXV0aG9yaXplZDogdXNlcj1mc19hZG1pbiBkYXRhYmFzZT1sZm0yDQouLi4NCjIwMjQtMDUt MTMgMDU6NTc6MjkuMzA1IEdNVCBbNjA0OF06IFsxLTFdIGRiPSx1c2VyPSxhcHA9LGNsaWVudD0g TE9HOiAgYXV0b21hdGljIGFuYWx5emUgb2YgdGFibGUgImxmbS5mcy5paiINCmF2ZyByZWFkIHJh dGU6IDcuODEzIE1CL3MsIGF2ZyB3cml0ZSByYXRlOiAwLjAwMCBNQi9zDQpidWZmZXIgdXNhZ2U6 IDM1MCBoaXRzLCA1IG1pc3NlcywgMCBkaXJ0aWVkDQpzeXN0ZW0gdXNhZ2U6IENQVTogdXNlcjog MC4wMSBzLCBzeXN0ZW06IDAuMDAgcywgZWxhcHNlZDogMC4wMCBzDQoyMDI0LTA1LTEzIDA1OjU3 OjQ0LjIwOSBHTVQgWzYxNDBdOiBbMS0xXSBkYj0sdXNlcj0sYXBwPSxjbGllbnQ9IExPRzogIGF1 dG9tYXRpYyB2YWN1dW0gb2YgdGFibGUgImxmbTIuZnMuaWoiOiBpbmRleCBzY2FuczogMA0KcGFn ZXM6IDAgcmVtb3ZlZCwgMiByZW1haW4sIDIgc2Nhbm5lZCAoMTAwLjAwJSBvZiB0b3RhbCkNCnR1 cGxlczogMSByZW1vdmVkLCAyIHJlbWFpbiwgMCBhcmUgZGVhZCBidXQgbm90IHlldCByZW1vdmFi bGUNCnJlbW92YWJsZSBjdXRvZmY6IDU5NzE3NjYwOCwgd2hpY2ggd2FzIDAgWElEcyBvbGQgd2hl biBvcGVyYXRpb24gZW5kZWQNCm5ldyByZWxmcm96ZW54aWQ6IDU5NzE3NjYwNSwgd2hpY2ggaXMg MzcyIFhJRHMgYWhlYWQgb2YgcHJldmlvdXMgdmFsdWUNCmluZGV4IHNjYW4gbm90IG5lZWRlZDog MCBwYWdlcyBmcm9tIHRhYmxlICgwLjAwJSBvZiB0b3RhbCkgaGFkIDAgZGVhZCBpdGVtIGlkZW50 aWZpZXJzIHJlbW92ZWQNCmF2ZyByZWFkIHJhdGU6IDcuNDgxIE1CL3MsIGF2ZyB3cml0ZSByYXRl OiA1LjYxMSBNQi9zDQpidWZmZXIgdXNhZ2U6IDM3IGhpdHMsIDQgbWlzc2VzLCAzIGRpcnRpZWQN CldBTCB1c2FnZTogMyByZWNvcmRzLCAyIGZ1bGwgcGFnZSBpbWFnZXMsIDE1NzQ5IGJ5dGVzDQpz eXN0ZW0gdXNhZ2U6IENQVTogdXNlcjogMC4wMCBzLCBzeXN0ZW06IDAuMDAgcywgZWxhcHNlZDog MC4wMCBzDQoyMDI0LTA1LTEzIDA1OjU3OjU5LjMxMiBHTVQgWzYwNjRdOiBbMS0xXSBkYj0sdXNl cj0sYXBwPSxjbGllbnQ9IExPRzogIGF1dG9tYXRpYyB2YWN1dW0gb2YgdGFibGUgInBvc3RncmVz LmEuYWNhcCI6IGluZGV4IHNjYW5zOiAxDQpwYWdlczogMCByZW1vdmVkLCAxIHJlbWFpbiwgMSBz Y2FubmVkICgxMDAuMDAlIG9mIHRvdGFsKQ0KdHVwbGVzOiA1NiByZW1vdmVkLCAyNCByZW1haW4s IDAgYXJlIGRlYWQgYnV0IG5vdCB5ZXQgcmVtb3ZhYmxlDQpyZW1vdmFibGUgY3V0b2ZmOiA1OTcx NzY2MzMsIHdoaWNoIHdhcyAwIFhJRHMgb2xkIHdoZW4gb3BlcmF0aW9uIGVuZGVkDQpuZXcgcmVs ZnJvemVueGlkOiA1OTcxNzY1NTksIHdoaWNoIGlzIDE0MTg2IFhJRHMgYWhlYWQgb2YgcHJldmlv dXMgdmFsdWUNCmluZGV4IHNjYW4gbmVlZGVkOiAxIHBhZ2VzIGZyb20gdGFibGUgKDEwMC4wMCUg b2YgdG90YWwpIGhhZCA1NiBkZWFkIGl0ZW0gaWRlbnRpZmllcnMgcmVtb3ZlZA0KaW5kZXggImFw cF9jdHh0X2FyZWFfcGsiOiBwYWdlczogNiBpbiB0b3RhbCwgMCBuZXdseSBkZWxldGVkLCAzIGN1 cnJlbnRseSBkZWxldGVkLCAzIHJldXNhYmxlDQppbmRleCAiYWNhcF9hcmVhX2hpeCI6IHBhZ2Vz OiAyNyBpbiB0b3RhbCwgMCBuZXdseSBkZWxldGVkLCAwIGN1cnJlbnRseSBkZWxldGVkLCAwIHJl dXNhYmxlDQppbmRleCAiYWNhcF9wcm9jZXNzX2lkX2l4IjogcGFnZXM6IDIgaW4gdG90YWwsIDAg bmV3bHkgZGVsZXRlZCwgMCBjdXJyZW50bHkgZGVsZXRlZCwgMCByZXVzYWJsZQ0KYXZnIHJlYWQg cmF0ZTogMTguODgxIE1CL3MsIGF2ZyB3cml0ZSByYXRlOiA2Ljc0MyBNQi9zDQpidWZmZXIgdXNh Z2U6IDEwNCBoaXRzLCAxNCBtaXNzZXMsIDUgZGlydGllZA0KV0FMIHVzYWdlOiAxIHJlY29yZHMs IDEgZnVsbCBwYWdlIGltYWdlcywgNzU3NyBieXRlcw0Kc3lzdGVtIHVzYWdlOiBDUFU6IHVzZXI6 IDAuMDAgcywgc3lzdGVtOiAwLjAwIHMsIGVsYXBzZWQ6IDAuMDAgcw0KDQoNClBoaWwgSG9yZGVy DQpEYXRhYmFzZSBNZWNoYW5pYw0KDQpUaGFsZXMNCkxhbmQgJiBBaXIgU3lzdGVtcw0KDQoNCg0K e09QRU59DQpUaGUgaW5mb3JtYXRpb24gY29udGFpbmVkIGluIHRoaXMgZS1tYWlsIGlzIGNvbmZp ZGVudGlhbC4gSXQgaXMgaW50ZW5kZWQgb25seSBmb3IgdGhlIHN0YXRlZCBhZGRyZXNzZWUocykg YW5kIGFjY2VzcyB0byBpdCBieSBhbnkgb3RoZXIgcGVyc29uIGlzIHVuYXV0aG9yaXNlZC4gSWYg eW91IGFyZSBub3QgYW4gYWRkcmVzc2VlLCB5b3UgbXVzdCBub3QgZGlzY2xvc2UsIGNvcHksIGNp cmN1bGF0ZSBvciBpbiBhbnkgb3RoZXIgd2F5IHVzZSBvciByZWx5IG9uIHRoZSBpbmZvcm1hdGlv biBjb250YWluZWQgaW4gdGhpcyBlLW1haWwuIFN1Y2ggdW5hdXRob3Jpc2VkIHVzZSBtYXkgYmUg dW5sYXdmdWwuIElmIHlvdSBoYXZlIHJlY2VpdmVkIHRoaXMgZS1tYWlsIGluIGVycm9yLCBwbGVh c2UgaW5mb3JtIHRoZSBvcmlnaW5hdG9yIGltbWVkaWF0ZWx5IGFuZCBkZWxldGUgaXQgYW5kIGFs bCBjb3BpZXMgZnJvbSB5b3VyIHN5c3RlbS4NCg0KVGhhbGVzIFVLIExpbWl0ZWQuIEEgY29tcGFu eSByZWdpc3RlcmVkIGluIEVuZ2xhbmQgYW5kIFdhbGVzLiBSZWdpc3RlcmVkIE9mZmljZTogMzUw IExvbmd3YXRlciBBdmVudWUsIEdyZWVuIFBhcmssIFJlYWRpbmcsIEJlcmtzIFJHMiA2R0YuIFJl Z2lzdGVyZWQgTnVtYmVyOiA4NjgyNzMNCg0KUGxlYXNlIGNvbnNpZGVyIHRoZSBlbnZpcm9ubWVu dCBiZWZvcmUgcHJpbnRpbmcgYSBoYXJkIGNvcHkgb2YgdGhpcyBlLW1haWwuDQo=