Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1q259Z-0005tC-8C for pgsql-bugs@arkaria.postgresql.org; Thu, 25 May 2023 07:12:53 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1q259X-0006Zz-Ku for pgsql-bugs@arkaria.postgresql.org; Thu, 25 May 2023 07:12:51 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1q259X-0006Zq-C8 for pgsql-bugs@lists.postgresql.org; Thu, 25 May 2023 07:12:51 +0000 Received: from ma03-relay.lansolnet.com ([176.95.46.36]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1q259Q-0021cU-Q6 for pgsql-bugs@lists.postgresql.org; Thu, 25 May 2023 07:12:50 +0000 Received: from unknown ([192.168.8.231]) by ma03-relay.lansolnet.com; Thu, 25 May 2023 09:12:43 +0200 Received: from MBX200D.cloud4partner.com (192.168.8.233) by MBX200B.cloud4partner.com (192.168.8.231) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_CBC_SHA384_P384) id 15.1.669.32; Thu, 25 May 2023 09:12:40 +0200 Received: from MBX200E.cloud4partner.com (192.168.8.234) by MBX200D.cloud4partner.com (192.168.8.233) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_CBC_SHA384_P384) id 15.1.669.32; Thu, 25 May 2023 09:12:40 +0200 Received: from MBX200E.cloud4partner.com ([fe80::881b:2a52:f04f:d634]) by MBX200E.cloud4partner.com ([fe80::881b:2a52:f04f:d634%13]) with mapi id 15.01.0669.032; Thu, 25 May 2023 09:12:40 +0200 From: Hans Buschmann To: "Wetmore, Matthew (CTR)" , PostgreSQL Bug List Subject: AW: BUG #17943: Undefined symbol LLVMBuildGEP in llvmjit.so during pg_restore Thread-Topic: BUG #17943: Undefined symbol LLVMBuildGEP in llvmjit.so during pg_restore Thread-Index: AQHZjkO5ermnUca6mkyX9srS7AwBB69pjBCAgAEEFis= Date: Thu, 25 May 2023 07:12:40 +0000 Message-ID: <33878dc6517d40ec90a29afd4fbde4b9@nidsa.net> References: <17943-56bb8c6bd4409b9f@postgresql.org>,<73e6193160a44474866472ceae1069ff@express-scripts.com> In-Reply-To: <73e6193160a44474866472ceae1069ff@express-scripts.com> Accept-Language: de-DE, en-US Content-Language: de-DE X-MS-Has-Attach: X-MS-TNEF-Correlator: x-originating-ip: [192.168.8.240] Content-Type: multipart/alternative; boundary="_000_33878dc6517d40ec90a29afd4fbde4b9nidsanet_" MIME-Version: 1.0 X-cloud-security-sender: buschmann@nidsa.net X-cloud-security-recipient: pgsql-bugs@lists.postgresql.org X-cloud-security-Virusscan: CLEAN X-cloud-security-disclaimer: This E-Mail was scanned by E-Mailservice on ma03-relay.lansolnet.com with D4B111983D96 X-cloud-security-connect: unknown[192.168.8.231], TLS=1, IP=192.168.8.231 X-cloud-security: scantime:.5209 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --_000_33878dc6517d40ec90a29afd4fbde4b9nidsanet_ Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable ________________________________ Von: Wetmore, Matthew (CTR) Gesendet: Mittwoch, 24. Mai 2023 19:27 An: Hans Buschmann Betreff: BUG #17943: Undefined symbol LLVMBuildGEP in llvmjit.so during pg_= restore > 1. is the restore user the owner of the view (have to be owner to refresh= ) and do they have SELECT on the view's table(s)? For clarification, this is a pg_restore of a full database dump as practice= d for about 7 years now. The test was under the builtin postgres role, so there seem no missing crea= te role problems. The sequence of commands is (abbreviated): create database target_db; (in another cmd window) pg_restore -d target_db full_compressed_dump_from_pg15.dmp