Обсуждение: AW: 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;

From the same dumpfile a restore to an empty db in an instance without jit support has no problems.

> 2. REFRESH locks tables, are those tables built yet in the restore?  Did you try CONCURRENTLY?

As this is a normal pg_restore I cannot influence order or locking.

I use pg_restore without CONCURRENTLY.

Hans Buschmann