This is the complete pg_hba contents local all all trust # IPv4 local connections: host all all 127.0.0.1/32 trust #host all all 172.31.0.84/24 trust # IPv6 local connections: host all all ::1/128 trust ps ax | grep INSERT shows a few processes from client machines not in pg_hba.conf The processes that do INSERTS keep appearing from other clients not in pg_hba.conf There is only 1 postmaster running The connections that keep appearing are from jdbc clients. -----Original Message----- From: Tom Lane [mailto:tgl@xxxxxxxxxxxxx] Sent: Wednesday, August 23, 2006 3:11 PM To: Sriram Dandapani Cc: pgsql-admin@xxxxxxxxxxxxxx Subject: Re: [ADMIN] pg_hba changes not honored "Sriram Dandapani" <sdandapani@xxxxxxxxxxxxxxx> writes: > 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. Sounds to me like a mistake in your pg_hba file, ie, there is still a line that allows them to connect. We've also heard of people editing the wrong copy of pg_hba.conf, or sighup'ing the wrong postmaster ... regards, tom lane
