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 1s4HAD-002OEy-1E for pgsql-general@arkaria.postgresql.org; Tue, 07 May 2024 09:31:09 +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 1s4HA8-001mL0-EM for pgsql-general@arkaria.postgresql.org; Tue, 07 May 2024 09:31:05 +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 1s4HA8-001mKs-13 for pgsql-general@lists.postgresql.org; Tue, 07 May 2024 09:31:05 +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 1s4HA1-001yvA-Mp for pgsql-general@lists.postgresql.org; Tue, 07 May 2024 09:31:04 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=uk.thalesgroup.com; q=dns/txt; s=B01; t=1715074258; x=1746610258; h=from:to:date:message-id:references:in-reply-to: content-transfer-encoding:mime-version:subject; bh=lUIjpGB2JkMCTQxrtMMS1VK9kCbp9MCjUtCVVP10qDs=; b=RRW5A/UMNVZxiUnN97dw466oEDd2p1R5qXhvIcufpGI3XX4QizAbpliO 48EQP8cu4h2yMbYJmFKD+0cegzXScMO57L24wYwTd+YspkoB3o1ZRZATZ saviYozbwfL3QJn0UFBfgUnrJeMaBKd5YjY7WVnxLEshj4+ZUoaiekT6L 413gMYnuaW4VM5rJDzkhdpCQnymsOpm20ZVyFJzApLXNy61BfPkIF46cp K0jFwgWbDlXpUtRms3Eh3pEdsnUsJnRoDiG0m/8Uqv3zZssaBhR9ix7aM lQ/Tylp3sNhjMovDGZmT8dot5AOYcWkp/8BeZg4/MZvpZJKUMv4gpGBen Q==; X-IronPort-AV: E=Sophos;i="6.07,260,1708387200"; d="scan'208";a="19163319" Subject: RE: Restore of a reference database kills the auto analyze processing. X-Trellix: Whitelist From: HORDER Philip To: Adrian Klaver , "pgsql-general@lists.postgresql.org" Thread-Topic: [EXTERNAL EMAIL] Re: Restore of a reference database kills the auto analyze processing. Thread-Index: Adqcp3JgvdjOETQQS7CKrmgOUek/vwAAjfUAAO3fEmA= Date: Tue, 7 May 2024 09:30:43 +0000 Message-ID: <465c9417c1c1422198cf9efea228c593@uk.thalesgroup.com> References: <5910d4dcbe244548bbf482dad0ceca83@uk.thalesgroup.com> <5cff371d-3c3f-41a6-894c-bff3fc79bd96@aklaver.com> In-Reply-To: <5cff371d-3c3f-41a6-894c-bff3fc79bd96@aklaver.com> Accept-Language: en-GB, en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: 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 U29ycnksIHBnX2R1bXAuDQoNClBoaWwgSG9yZGVyDQpEYXRhYmFzZSBNZWNoYW5pYw0KDQoNCg0K LS0tLS1PcmlnaW5hbCBNZXNzYWdlLS0tLS0NCkZyb206IEFkcmlhbiBLbGF2ZXIgPGFkcmlhbi5r bGF2ZXJAYWtsYXZlci5jb20+DQpTZW50OiAwMiBNYXkgMjAyNCAxNzo1OQ0KVG86IEhPUkRFUiBQ aGlsaXAgPFBoaWwuSG9yZGVyQHVrLnRoYWxlc2dyb3VwLmNvbT47IHBnc3FsLWdlbmVyYWxAbGlz dHMucG9zdGdyZXNxbC5vcmcNClN1YmplY3Q6IFtFWFRFUk5BTCBFTUFJTF0gUmU6IFJlc3RvcmUg b2YgYSByZWZlcmVuY2UgZGF0YWJhc2Uga2lsbHMgdGhlIGF1dG8gYW5hbHl6ZSBwcm9jZXNzaW5n Lg0KDQoNCg0KT24gNS8yLzI0IDg6NTIgQU0sIEhPUkRFUiBQaGlsaXAgd3JvdGU6DQo+IFJ1bm5p bmcgUG9zdGdyZXMgMTUuMyB3aXRoIFBvc3RHSVMgMy4zDQo+DQo+IE9uIFdpbmRvd3MgMTAgKHll cywgSSBrbm93KQ0KPg0KPiBJdOKAmXMgYSBzaW5nbGUgbm9kZSBkYiB3aXRoIG5vIHJlcGxpY2F0 aW9uLCB0b3BwaW5nIG91dCBhdCBhYm91dCAyMDBHQi4NCj4NCj4gV2UgaGF2ZSBhIHNjaGVtYSAo QSkgaW4gdGhlIGRlZmF1bHQgJ3Bvc3RncmVzJyBtYWludGVuYW5jZSBkYXRhYmFzZSwNCj4gd2hp Y2ggb3VyIHNvZnR3YXJlIHNlcnZpY2VzIGNvbm5lY3QgdG8sIHdpdGggb25lIHNldCBvZiB1c2Vy cyAoU1UpDQo+DQo+IFdlIGhhdmUgYW5vdGhlciBkYXRhYmFzZSwgbGV04oCZcyBjYWxsIGl0IExG TSwgd2hpY2ggY29udGFpbnMgcmVmZXJlbmNlDQo+IGRhdGEgZm9yIHNvbWUgQ09UUyBzb2Z0d2Fy ZS4gIEkgZG9uJ3Qga25vdyB3aGF0J3MgaW4gaXQsIHdlIGp1c3QgZ2V0DQo+IGdpdmVuIHVwZGF0 ZXMgZm9yIGl0IGluIHBnX2JhY2t1cCBiaW5hcnkgZmlsZXMsIGFib3V0IDJNQiBlYWNoLg0KDQpE byB5b3UgbWVhbiBwZ19iYXNlYmFja3VwLCBwZ19kdW1wIG9yIHNvbWV0aGluZyBlbHNlPw0KDQoN Ci0tDQpBZHJpYW4gS2xhdmVyDQphZHJpYW4ua2xhdmVyQGFrbGF2ZXIuY29tDQpUaGUgaW5mb3Jt YXRpb24gY29udGFpbmVkIGluIHRoaXMgZS1tYWlsIGlzIGNvbmZpZGVudGlhbC4gSXQgaXMgaW50 ZW5kZWQgb25seSBmb3IgdGhlIHN0YXRlZCBhZGRyZXNzZWUocykgYW5kIGFjY2VzcyB0byBpdCBi eSBhbnkgb3RoZXIgcGVyc29uIGlzIHVuYXV0aG9yaXNlZC4gSWYgeW91IGFyZSBub3QgYW4gYWRk cmVzc2VlLCB5b3UgbXVzdCBub3QgZGlzY2xvc2UsIGNvcHksIGNpcmN1bGF0ZSBvciBpbiBhbnkg b3RoZXIgd2F5IHVzZSBvciByZWx5IG9uIHRoZSBpbmZvcm1hdGlvbiBjb250YWluZWQgaW4gdGhp cyBlLW1haWwuIFN1Y2ggdW5hdXRob3Jpc2VkIHVzZSBtYXkgYmUgdW5sYXdmdWwuIElmIHlvdSBo YXZlIHJlY2VpdmVkIHRoaXMgZS1tYWlsIGluIGVycm9yLCBwbGVhc2UgaW5mb3JtIHRoZSBvcmln aW5hdG9yIGltbWVkaWF0ZWx5IGFuZCBkZWxldGUgaXQgYW5kIGFsbCBjb3BpZXMgZnJvbSB5b3Vy IHN5c3RlbS4NCg0KVGhhbGVzIFVLIExpbWl0ZWQuIEEgY29tcGFueSByZWdpc3RlcmVkIGluIEVu Z2xhbmQgYW5kIFdhbGVzLiBSZWdpc3RlcmVkIE9mZmljZTogMzUwIExvbmd3YXRlciBBdmVudWUs IEdyZWVuIFBhcmssIFJlYWRpbmcsIEJlcmtzIFJHMiA2R0YuIFJlZ2lzdGVyZWQgTnVtYmVyOiA4 NjgyNzMNCg0KUGxlYXNlIGNvbnNpZGVyIHRoZSBlbnZpcm9ubWVudCBiZWZvcmUgcHJpbnRpbmcg YSBoYXJkIGNvcHkgb2YgdGhpcyBlLW1haWwuDQo=