Thread: 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