BUG #15644: not able to up the database
The following bug has been logged on the website:
Bug reference: 15644
Logged by: ramakrishnan r
Email address: prakash.ramakrishnan.ap@nielsen.com
PostgreSQL version: 10.4
Operating system: CentOS Linux release 7.5.1804
Description:
Hi,
Team not able to the up the database please find the below details.
==> pg_ctl start -mf
/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
no data was returned by command ""/opt/app/PostgreSQL/10/bin/postgres" -V"
The program "postgres" is needed by pg_ctl but was not found in the
same directory as "/opt/app/PostgreSQL/10/bin/pg_ctl".
Check your installation.
postgres@sydcosausd001.enterprisenet.org:/home/postgres
postgres@sydcosausd001.enterprisenet.org:/Postgres/pgDATA/data
==> ls
base pg_commit_ts pg_ident.conf pg_replslot pg_stat_tmp
PG_VERSION postgresql.conf
current_logfiles pg_dynshmem pg_logical pg_serial pg_subtrans
pg_wal postgresql.conf.include
data10.tar.gz pg_hba.conf pg_multixact pg_snapshots pg_tblspc
pg_xact postgresql.conf.include.skd.20181009
global pg_hba.conf_bkp pg_notify pg_stat pg_twophase
postgresql.auto.conf postmaster.opts
On Thu, Feb 21, 2019 at 2:05 AM PG Bug reporting form
<noreply@postgresql.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