Phil DeGuzman (JOHNGALT)
Cisco Systems
Business Technologist
Cisco Systems
JOHNGALT Member since 2012 28 posts
Cisco Systems
Posted: February 8, 2017
Last activity: February 24, 2017
Posted: 8 Feb 2017 13:12 EST
Last activity: 24 Feb 2017 15:17 EST

PGAdmin III - Access to database denied

I have a Pega 7.2.1 Personal Edition instance and want to investigate some of the data. I have used PGAdmin on other instances so I know it is working fine. However, on this instance I enter the server connection information, am prompted for the password then get an error:

"Access to database denied" - FATAL: no pg_hba.conf entry for host "<removed IP address>", user "pega", database "postgres", SSL off

I am then instructed to add something to the pg_hba.conf file, but when I make the edits I am still seeing the same errors again.

I do not have this issue with other Pega instances (like one's I used for training).

***Updated by moderator: Lochan to remove proprietary info; updated topic categories***

Data Integration System Administration
Moderation Team has archived post, This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.