From: Hans Buschmann <buschmann@nidsa.net>
To: Wetmore, Matthew (CTR) <Matthew.Wetmore@express-scripts.com>
To: PostgreSQL Bug List <pgsql-bugs@lists.postgresql.org>
Subject: AW: BUG #17943: Undefined symbol LLVMBuildGEP in llvmjit.so during pg_restore
Date: Thu, 25 May 2023 07:12:40 +0000
Message-ID: <33878dc6517d40ec90a29afd4fbde4b9@nidsa.net> (raw)
In-Reply-To: <73e6193160a44474866472ceae1069ff@express-scripts.com>
References: <17943-56bb8c6bd4409b9f@postgresql.org>
<73e6193160a44474866472ceae1069ff@express-scripts.com>
________________________________
Von: Wetmore, Matthew (CTR) <Matthew.Wetmore@express-scripts.com>
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 practiced for about 7 years now.
The test was under the builtin postgres role, so there seem no missing create 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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-bugs@postgresql.org
Cc: buschmann@nidsa.net, Matthew.Wetmore@express-scripts.com, pgsql-bugs@lists.postgresql.org
Subject: Re: AW: BUG #17943: Undefined symbol LLVMBuildGEP in llvmjit.so during pg_restore
In-Reply-To: <33878dc6517d40ec90a29afd4fbde4b9@nidsa.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox