could not load library "/usr/local/lib/postgresql/llvmjit.so"

gistfile1.txt

freshports.org=# SELECT DISTINCT
freshports.org-# PA.category,
freshports.org-# PA.name AS port,
freshports.org-# coalesce(V.date_modified, V.date_entry, V.date_discovery) AS
freshports.org-# date,
freshports.org-# V.vid,
freshports.org-# to_char(coalesce(V.date_modified, V.date_entry,
freshports.org(# V.date_discovery)::date, 'Mon DD') AS date_formatted,
freshports.org-# V.date_modified IS NULL AS new,
freshports.org-# lower(name)
freshports.org-#     FROM commit_log_ports_vuxml CLPV, vuxml V, ports_active PA
freshports.org-#    WHERE CLPV.vuxml_id = V.id
freshports.org-#      AND CLPV.port_id  = PA.id
freshports.org-# ORDER BY coalesce(V.date_modified, V.date_entry, V.date_discovery)
freshports.org-# desc, lower(name)
freshports.org-#    LIMIT 15;
ERROR:  could not load library "/usr/local/lib/postgresql/llvmjit.so": Shared object "libLLVM-9.so" not found, required by "llvmjit.so"
freshports.org=# \q

gistfile2.txt

[dan@supernews:~] $ ls -l /usr/local/lib/postgresql/llvmjit.so
-rwxr-xr-x  1 root  wheel  161712 Jan  4 04:41 /usr/local/lib/postgresql/llvmjit.so
[dan@supernews:~] $ pkg which /usr/local/lib/postgresql/llvmjit.so
/usr/local/lib/postgresql/llvmjit.so was installed by package postgresql12-server-12.5
[dan@supernews:~] $ 

Restarted PostgreSQL - problem went away.

Upgrades today:

Jan 26 13:22:56 supernews pkg[52257]: perl5 upgraded: 5.32.0_1 -> 5.32.1_1 
Jan 26 13:22:59 supernews pkg[52257]: pinentry-curses-1.1.1 installed
Jan 26 13:23:00 supernews pkg[52257]: sqlite3 upgraded: 3.34.0,1 -> 3.34.1,1 
Jan 26 13:23:02 supernews pkg[52257]: pinentry upgraded: 1.1.0_7 -> 1.1.1 
Jan 26 13:23:03 supernews pkg[52257]: p5-IO-Socket-SSL upgraded: 2.068 -> 2.069 
Jan 26 13:23:07 supernews pkg[52257]: bind-tools upgraded: 9.16.10 -> 9.16.11 
Jan 26 13:23:14 supernews pkg[52257]: freshports-www upgraded: 1.52_1 -> 1.53 
Jan 26 13:23:17 supernews pkg[52257]: bind916 upgraded: 9.16.10 -> 9.16.11 
Jan 26 14:40:44 supernews pkg[85075]: freshports-www upgraded: 1.53 -> 1.53.1 

Going back farther we see:

[dan@supernews:~] $ grep postgresql12-server /var/log/messages.1
Jan 24 20:23:30 supernews pkg[76511]: postgresql12-server upgraded: 12.4 -> 12.5 

That was the cause.