BUG #15639: Unable to connect to database with dsn dbi - Mailing list pgsql-bugs

From PG Bug reporting form
Subject BUG #15639: Unable to connect to database with dsn dbi
Date
Msg-id 15639-b53e677fe2bd8d05@postgresql.org
Whole thread Raw
List pgsql-bugs
The following bug has been logged on the website:

Bug reference:      15639
Logged by:          Ding Linda
Email address:      linda.ding@cemtek.com.cn
PostgreSQL version: Unsupported/Unknown
Operating system:   Linux
Description:

I run into a problem with the postgresql server. Is there any way to remove
it separately and do a clean install of Postgresql only?
Here’s one of the error messages I get:

Unable to connect to database with dsn
dbi:Pg:dbname=pmx_quarantine;port=5432;host=mgate2.cemtek.com.cn.cemtek.com.cn:
DBI
connect('dbname=pmx_quarantine;port=5432;host=mgate2.cemtek.com.cn.cemtek.com.cn','',...)
failed: FATAL: no pg_hba.conf entry for host "117.184.46.144", user "pmx6",
database "pmx_quarantine", SSL on
FATAL: no pg_hba.conf entry for host "117.184.46.144", user "pmx6", database
"pmx_quarantine", SSL off at
/opt/pmx6/lib/site_perl/5.8.7/PureMessage/Reports/Reductor.pm line 67
at /opt/pmx6/bin/pmx-prd-reduce line 46

and also

/opt/pmx6/postgres/bin/pg_ctl: error while loading shared libraries:
libpq.so.5: cannot open shared object file: No such file or directory
when I try to start the server manually.

Apparently something went wrong during the pgsql installation and I’m not
sure how to fix the host problem and add the missing LD_LIBRARY_PATH
variable.


pgsql-bugs by date:

Previous
From: Michael Paquier
Date:
Subject: Re: BUG #15636: PostgreSQL 11.1 pg_basebackup backup to a CIFSdestination throws fsync error at end of backup
Next
From: PG Bug reporting form
Date:
Subject: BUG #15640: FATAL: XX000: cannot read pg_class without having selected a database