X-Original-To: pgsql-admin-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 1F4719FB1EE for ; Wed, 23 Aug 2006 19:59:43 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 38346-09 for ; Wed, 23 Aug 2006 19:59:39 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id F0C1A9F9F2F for ; Wed, 23 Aug 2006 19:59:39 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.6/8.13.6) with ESMTP id k7NMxaJg025459; Wed, 23 Aug 2006 18:59:36 -0400 (EDT) To: "Sriram Dandapani" cc: "Joshua D. Drake" , pgsql-admin@postgresql.org Subject: Re: pg_hba changes not honored In-reply-to: <6992E470F12A444BB787B5C937B9D4DF0574FF3E@ca-mail1.cis.local> References: <6992E470F12A444BB787B5C937B9D4DF0574FF3E@ca-mail1.cis.local> Comments: In-reply-to "Sriram Dandapani" message dated "Wed, 23 Aug 2006 15:50:55 -0700" Date: Wed, 23 Aug 2006 18:59:36 -0400 Message-ID: <25458.1156373976@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.152 tagged_above=0 required=5 tests=AWL, SPF_HELO_PASS, SPF_PASS X-Spam-Level: X-Archive-Number: 200608/256 X-Sequence-Number: 22799 "Sriram Dandapani" writes: > 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. Hm. OK, that means we need to look closer at how you're using pg_ctl. Are you sure you're pointing it at the right data directory? Does it claim to have successfully signaled the postmaster? What PG version is this exactly, and on what platform? regards, tom lane