BUG #16490: We cannot able to access production database remotely - Mailing list pgsql-bugs

From PG Bug reporting form
Subject BUG #16490: We cannot able to access production database remotely
Date
Msg-id 16490-a38e24401adb2dfa@postgresql.org
Whole thread Raw
List pgsql-bugs
The following bug has been logged on the website:

Bug reference:      16490
Logged by:          Megha P
Email address:      meghap@crgroup.co.in
PostgreSQL version: 9.6.0
Operating system:   Windows
Description:

Hi Team,

We are using the Postgres database for Jira. Now we want to give read-only
access to a database for a user. Read-only access has given to the user in
the database. This is done in Testing Environment first before Production.
In the testing environment, users can access the database remotely by using
Pgadmin. But the production database cannot be able to access.

We have made the same entry as UAT  pg_hba config file in Production DB and
tried but most updating the configuration file, the services didn’t seem to
turn up for Postgresql, we have rolled back to the original config file for
pb_hba.

Kindly suggest on the same


pgsql-bugs by date:

Previous
From: Thomas Munro
Date:
Subject: Re: Potential G2-item cycles under serializable isolation
Next
From: Julien Rouhaud
Date:
Subject: Re: pg_stat_statements: duplicated external query texts with MSY2