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:[EMAIL PROTECTED] Sent: Wednesday, August 23, 2006 3:11 PM To: Sriram Dandapani Cc: pgsql-admin@postgresql.org Subject: Re: [ADMIN] pg_hba changes not honored "Sriram Dandapani" <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
