Re: postgresql bug - Mailing list pgsql-general

From Christoph Moench-Tegeder
Subject Re: postgresql bug
Date
Msg-id YsgT7iP/N2tKBd7+@elch.exwg.net
Whole thread Raw
In response to postgresql bug  (ml@ft-c.de)
List pgsql-general
## ml@ft-c.de (ml@ft-c.de):

> /usr/local/bin/postgres -V
> ld-elf.so.1: Shared object "libicui18n.so.70" not found, required by
> "postgres"

You screwd up your upgrades: that postgres binary was built against
ICU 70, but as hou have shown you have ICU 71 installed:

> find / -name "*libicui*"
> /usr/local/lib/libicuio.a
> /usr/local/lib/libicui18n.so.71
> /usr/local/lib/libicuio.so.71.1
> /usr/local/lib/libicui18n.so.71.1


> /usr/local/lib/compat/pkg/libicui18n.so.68.2
> /usr/local/lib/compat/pkg/libicuio.so.68
> /usr/local/lib/compat/pkg/libicuio.so.68.2
> /usr/local/lib/compat/pkg/libicui18n.so.68

And that looks like you're using portupgrade - in which case you need
to chase a lot of shared library dependencies yourself. pkg_libchk
from ports-mgmt/bsdadminscripts2 may help a little with that, but
it's still an error-prone process and a lot of toil. For that reason
I'd recommend either using packages (from the official builds) or
setting up your own poudriere; all other options will cost you a lot
of time and nerves and require a lot more knowledge and manual
intervention than "simple updates" are supposed to in 2022.

Regards,
Christoph

-- 
Spare Space



pgsql-general by date:

Previous
From: Francisco Olarte
Date:
Subject: Re: postgresql generate ddl returns FK with `()` in it
Next
From: Francisco Olarte
Date:
Subject: Re: Error when pasting function blocks into psql