pg_hba changes not honored - Mailing list pgsql-admin

From Sriram Dandapani
Subject pg_hba changes not honored
Date
Msg-id 6992E470F12A444BB787B5C937B9D4DF0574FF25@ca-mail1.cis.local
Whole thread Raw
Responses Re: pg_hba changes not honored  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-admin

When I update pg_hba.conf to disallow certain client machines from connectiong (update pg_hba.conf, pg_ctl reload), I still see new connections appearing in the process list from the clients I want to disconnect. Why does this happen. (I noticed this behavior with jdbc connections in jboss with connection pooling)

 

Once pg_hba is reloaded, shouldn’t postmaster refuse to accept connections from the clients not in pg_hba.conf list.

 

Regards

 

Sriram

pgsql-admin by date:

Previous
From: Scott Marlowe
Date:
Subject: Re: [GENERAL] How to detect Postgres deadlocks?
Next
From: Tom Lane
Date:
Subject: Re: pg_hba changes not honored