This problem occurs only when the changes are made while postmaster is running and pg_ctl is used to reload config files.
When the changes are applied and postmaster is stopped and restarted, it works fine. -----Original Message----- From: Joshua D. Drake [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 23, 2006 3:44 PM To: Tom Lane Cc: Sriram Dandapani; pgsql-admin@postgresql.org Subject: Re: [ADMIN] pg_hba changes not honored Tom Lane wrote: > "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 ... That is actually quite common, especially on Ubuntu :) Joshua D. Drake > > regards, tom lane > > ---------------------------(end of broadcast)--------------------------- > TIP 4: Have you searched our list archives? > > http://archives.postgresql.org > -- === The PostgreSQL Company: Command Prompt, Inc. === Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240 Providing the most comprehensive PostgreSQL solutions since 1997 http://www.commandprompt.com/ ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
