Re: BUG #15644: not able to up the database

On Thu, Feb 21, 2019 at 2:05 AM PG Bug reporting form
<noreply(at)postgresql(dot)org> wrote:
> /opt/app/PostgreSQL/10/bin/postgres: error while loading shared libraries:
> libssl.so.1.0.0: cannot open shared object file: No such file or directory

Hi,

I don't know how any of this stuff is packaged on RHEL, but clearly a
necessary library has disappeared. Did you install a newer OpenSSL
(1.1.1?) that caused the older one to be removed, or something like
that? Something to do with the "heartbleed" patches and version
changes that happened a while back, or something else like that?
1.0.0 disappeared on several distributions.

How did you install PostgreSQL? Judging by the path, that's some less
common packages (and you didn't apply updates) or you compiled it from
source; either way that seems potentially more prone to problems with
dependencies.

By the way, 10.4 is missing 172 bugfixes:

https://why-upgrade.depesz.com/show?from=10.4&to=10.7

--
Thomas Munro
https://enterprisedb.com