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 1s7Y29-0069iK-2O for pgsql-general@arkaria.postgresql.org; Thu, 16 May 2024 10:08:23 +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 1s7Y28-005F3E-WB for pgsql-general@arkaria.postgresql.org; Thu, 16 May 2024 10:08:21 +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 1s7Y28-005Etx-HM for pgsql-general@lists.postgresql.org; Thu, 16 May 2024 10:08:20 +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 1s7Y25-000TnE-Et for pgsql-general@lists.postgresql.org; Thu, 16 May 2024 10:08:19 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=uk.thalesgroup.com; q=dns/txt; s=A01; t=1715854097; x=1747390097; h=from:to:subject:date:message-id: content-transfer-encoding:mime-version; bh=zNYPmTjHqe10B6wjgHWbT459/lsY5iHaGNzlhtUNps8=; b=WvNzXoVx4Q5qu2DQljsaixteGpakrcmkSnA/j+PpdKg/d6VbI/6SxUke 4FmmfB0XKu5J0FJ3LIoEQbw2EXpfpFwD+lF2oNQukdith5CekP8I6U+1S 27wtAH/fR65GSGniOTsffew0xI58mlvoGgyAxXw71puWHBj5nA+JePEUg 7nTzGpKq7Xie8CR0m2hDNlx9pWLYtMULnI0RZMQfUnj1VF116lWzQUMnl IBfUPbyfMwHh6YE8YkfXx63fS8nlwj2Yl4aRejh1SNhRPZbz2HeHvYxrK o92YtepAv8lqwFKZyVZv6UmuceIqb7iaK6AS6mOIwoU0DuSkQ3/wYaPKz w==; X-IronPort-AV: E=Sophos;i="6.08,164,1712617200"; d="scan'208";a="126438133" 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: AdqneO0LcS0v9JwdQ5WJyuprWk82kw== Date: Thu, 16 May 2024 10:08:12 +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-16T10:08:09Z; 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=bbb84bd9-7738-4650-be9d-2b2584438f2d; 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 Q2xhc3NpZmllZCBhczoge09QRU59DQoNCj4gLS1vaWRzIGhhdmUgbm90IGJlZW4gc3VwcG9ydGVk IHdpdGggcGdfZHVtcCBzaW5jZSB2MTENCg0KWW91J3JlIGFic29sdXRlbHkgY29ycmVjdCwgdGhp cyBjb21tYW5kIGNhbWUgZnJvbSBteSBub3Rlcywgd2hpY2ggYXJlIG9idmlvdXNseSBvdXQgb2Yg ZGF0ZS4NCg0KV2UncmUgcnVubmluZyBQb3N0Z3JlcyAxNSBwZ19kdW1wLCBhbmQgSSd2ZSB1cGRh dGVkIG15IG5vdGVzLg0KSSdtIGRvdWJsZS1jaGVja2luZyB0aGUgY29tbWFuZCBvcHRpb25zIHdp dGggdGhlIGd1eSB3aG8gY3JlYXRlcyB0aGVzZSBmaWxlcywgYnV0IGhlJ3Mgb24gaG9saWRheS4g IEkgZXhwZWN0IHdlIGp1c3QgZHJvcHBlZCB0aGUgT0lEIG9wdGlvbi4NCg0KPiBGWUksIC0tYmxv YnMgaXMgb25seSBuZWVkZWQgd2hlbiBkdW1waW5nIGEgc3BlY2lmaWMgdGFibGUgb3Igc2NoZW1h LCBvdGhlcndpc2UgaXQgaGFwcGVucyBieSBkZWZhdWx0Lg0KDQpUaGFua3MsIEkgZGlkbuKAmXQg a25vdyB0aGF0Lg0KDQpQaGlsIEhvcmRlcg0KRGF0YWJhc2UgTWVjaGFuaWMNCg0KVGhhbGVzDQpM YW5kICYgQWlyIFN5c3RlbXMNCg0KDQp7T1BFTn0NClRoZSBpbmZvcm1hdGlvbiBjb250YWluZWQg aW4gdGhpcyBlLW1haWwgaXMgY29uZmlkZW50aWFsLiBJdCBpcyBpbnRlbmRlZCBvbmx5IGZvciB0 aGUgc3RhdGVkIGFkZHJlc3NlZShzKSBhbmQgYWNjZXNzIHRvIGl0IGJ5IGFueSBvdGhlciBwZXJz b24gaXMgdW5hdXRob3Jpc2VkLiBJZiB5b3UgYXJlIG5vdCBhbiBhZGRyZXNzZWUsIHlvdSBtdXN0 IG5vdCBkaXNjbG9zZSwgY29weSwgY2lyY3VsYXRlIG9yIGluIGFueSBvdGhlciB3YXkgdXNlIG9y IHJlbHkgb24gdGhlIGluZm9ybWF0aW9uIGNvbnRhaW5lZCBpbiB0aGlzIGUtbWFpbC4gU3VjaCB1 bmF1dGhvcmlzZWQgdXNlIG1heSBiZSB1bmxhd2Z1bC4gSWYgeW91IGhhdmUgcmVjZWl2ZWQgdGhp cyBlLW1haWwgaW4gZXJyb3IsIHBsZWFzZSBpbmZvcm0gdGhlIG9yaWdpbmF0b3IgaW1tZWRpYXRl bHkgYW5kIGRlbGV0ZSBpdCBhbmQgYWxsIGNvcGllcyBmcm9tIHlvdXIgc3lzdGVtLg0KDQpUaGFs ZXMgVUsgTGltaXRlZC4gQSBjb21wYW55IHJlZ2lzdGVyZWQgaW4gRW5nbGFuZCBhbmQgV2FsZXMu IFJlZ2lzdGVyZWQgT2ZmaWNlOiAzNTAgTG9uZ3dhdGVyIEF2ZW51ZSwgR3JlZW4gUGFyaywgUmVh ZGluZywgQmVya3MgUkcyIDZHRi4gUmVnaXN0ZXJlZCBOdW1iZXI6IDg2ODI3Mw0KDQpQbGVhc2Ug Y29uc2lkZXIgdGhlIGVudmlyb25tZW50IGJlZm9yZSBwcmludGluZyBhIGhhcmQgY29weSBvZiB0 aGlzIGUtbWFpbC4NCg==