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 1s4HHt-002PGI-G2 for pgsql-general@arkaria.postgresql.org; Tue, 07 May 2024 09:39:05 +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 1s4HHq-001qfW-UO for pgsql-general@arkaria.postgresql.org; Tue, 07 May 2024 09:39:03 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1s4HHq-001qe3-BG for pgsql-general@lists.postgresql.org; Tue, 07 May 2024 09:39:03 +0000 Received: from mail.uk.thalesgroup.com ([192.93.164.134]) by makus.postgresql.org with esmtps (TLS1.2) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1s4HHo-001r3l-Cj for pgsql-general@lists.postgresql.org; Tue, 07 May 2024 09:39:02 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=uk.thalesgroup.com; q=dns/txt; s=A01; t=1715074741; x=1746610741; h=from:to:date:message-id:references:in-reply-to: content-transfer-encoding:mime-version:subject; bh=CsT/Zt4LMOdqBKgJuWkAWiQqeJazEXxUMSr1/z7IPKg=; b=paXwuc21KqrLRM5G5aalgRrCH5M8IJq8ZmGouhvgcBQUl+THc6NMaydp T9jwWRkOxCzpuCXJHbkDuTg5aqcn557Gtf2X+HO6VjA8Xbsj/l4mdfmM0 jl7hBofR6dFwgia7GHMp8EdE/OE1tzAqUJMgf/0H33WKRZlW81KOAHseI PSTmHt+kmBe7vmNbRANCzF6jRkFofXs0SXPxx98iVteRHC38f575Q8pKo DOq/vkZmLwjz+z9EsZz3uDnONjg3h/1Sdk3FAYuDwODoy1JXPaL0F2TCV /OCWog9Rf33dvjXyEmJqb8MWRvUsg75JQho7tFq4z9gqOAAwxs+sCXlJi Q==; X-IronPort-AV: E=Sophos;i="6.07,260,1708387200"; d="scan'208";a="126018360" 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/vwAEJJ2AAOpY/fA= Date: Tue, 7 May 2024 09:38:51 +0000 Message-ID: <545ad7354f5f4c239df25faf8e883e98@uk.thalesgroup.com> References: <5910d4dcbe244548bbf482dad0ceca83@uk.thalesgroup.com> <4b64d2cc-1df6-4982-b842-39fb0d886731@aklaver.com> In-Reply-To: <4b64d2cc-1df6-4982-b842-39fb0d886731@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 VGhhbmtzIGZvciB5b3VyIHRpbWUgQWRyaWFuDQoNCg0KPiBJcyB0aGVyZSBlbm91Z2ggZGF0YSBw cm9jZXNzaW5nPw0KDQpZZXMsIG9uZSB0YWJsZSBpcyByZWNlaXZpbmcgdXB3YXJkcyBvZiAyMCBt aWxsaW9uIHJvd3MgZGFpbHkuDQpXZSBub3RpY2VkIHRoZSBwcm9ibGVtIHdoZW4gZmV0Y2ggcGVy Zm9ybWFuY2Ugb24gdGhpcyB0YWJsZSBkZWdyYWRlZCBhZnRlciB1cGRhdGVzLg0KDQo+IEF1dG92 YWN1dW0gaGFzIHRocmVzaG9sZHMgZm9yIHR1cm5pbmcgb24sIGFyZSB5b3Ugc3VyZSB0aG9zZSB0 aHJlc2hvbGRzIGFyZSBqdXN0IG5vdCBiZWluZyBtZXQ/DQoNClllcyB3ZSdyZSBzdXJlLiAgT3Vy IGJpZ2dlc3QgdGFibGUgaXMgc2V0IGZvciBhIGZpeGVkIG51bWJlciBvZiByb3dzIHJhdGhlciB0 aGFuIGEgcGVyY2VudGFnZSwgdGhpcyBnZXRzIGFuIGF1dG8gYW5hbHlzZSBhYm91dCBldmVyeSAx NSBtaW51dGVzLg0KDQpBZnRlciBhbiB1cGRhdGUgdGhpcyBqdXN0IHN0b3BzLCBhbmQgdGhlcmUg YXJlIG5vIGFuYWx5c2UgZW50cmllcyBpbiB0aGUgbG9nIGZpbGUuICBOb25lIGF0IGFsbCwgZm9y IGFueSB0YWJsZS4NCg0KV2hlbiB3ZSByZXN0YXJ0IFBvc3RncmVzIHRoZSBhdXRvIGFuYWx5c2Ug cmVzdGFydHMgYW5kIGNhdGNoZXMgdXAgd2l0aCB0aGUgYmFja2xvZy4NCg0KDQpQaGlsIEhvcmRl cg0KRGF0YWJhc2UgTWVjaGFuaWMNCg0KVGhhbGVzDQpMYW5kICYgQWlyIFN5c3RlbXMNCg0KVGhl IGluZm9ybWF0aW9uIGNvbnRhaW5lZCBpbiB0aGlzIGUtbWFpbCBpcyBjb25maWRlbnRpYWwuIEl0 IGlzIGludGVuZGVkIG9ubHkgZm9yIHRoZSBzdGF0ZWQgYWRkcmVzc2VlKHMpIGFuZCBhY2Nlc3Mg dG8gaXQgYnkgYW55IG90aGVyIHBlcnNvbiBpcyB1bmF1dGhvcmlzZWQuIElmIHlvdSBhcmUgbm90 IGFuIGFkZHJlc3NlZSwgeW91IG11c3Qgbm90IGRpc2Nsb3NlLCBjb3B5LCBjaXJjdWxhdGUgb3Ig aW4gYW55IG90aGVyIHdheSB1c2Ugb3IgcmVseSBvbiB0aGUgaW5mb3JtYXRpb24gY29udGFpbmVk IGluIHRoaXMgZS1tYWlsLiBTdWNoIHVuYXV0aG9yaXNlZCB1c2UgbWF5IGJlIHVubGF3ZnVsLiBJ ZiB5b3UgaGF2ZSByZWNlaXZlZCB0aGlzIGUtbWFpbCBpbiBlcnJvciwgcGxlYXNlIGluZm9ybSB0 aGUgb3JpZ2luYXRvciBpbW1lZGlhdGVseSBhbmQgZGVsZXRlIGl0IGFuZCBhbGwgY29waWVzIGZy b20geW91ciBzeXN0ZW0uDQoNClRoYWxlcyBVSyBMaW1pdGVkLiBBIGNvbXBhbnkgcmVnaXN0ZXJl ZCBpbiBFbmdsYW5kIGFuZCBXYWxlcy4gUmVnaXN0ZXJlZCBPZmZpY2U6IDM1MCBMb25nd2F0ZXIg QXZlbnVlLCBHcmVlbiBQYXJrLCBSZWFkaW5nLCBCZXJrcyBSRzIgNkdGLiBSZWdpc3RlcmVkIE51 bWJlcjogODY4MjczDQoNClBsZWFzZSBjb25zaWRlciB0aGUgZW52aXJvbm1lbnQgYmVmb3JlIHBy aW50aW5nIGEgaGFyZCBjb3B5IG9mIHRoaXMgZS1tYWlsLg0K