Received: from maia.hub.org (maia-4.hub.org [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 9189F637585 for ; Mon, 26 Apr 2010 14:50:04 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 43992-05-5 for ; Mon, 26 Apr 2010 17:49:55 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from spinlock.commandprompt.com (host-215.commandprompt.net [207.173.203.215]) by mail.postgresql.org (Postfix) with ESMTP id A7C3163788C for ; Mon, 26 Apr 2010 13:33:16 -0300 (ADT) Received: from localhost (localhost [127.0.0.1]) by spinlock.commandprompt.com (Postfix) with ESMTP id AAB5134803A; Mon, 26 Apr 2010 09:33:15 -0700 (PDT) Received: from spinlock.commandprompt.com ([127.0.0.1]) by localhost (spinlock.commandprompt.com.commandprompt.com [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id SIkk0mbY+uVI; Mon, 26 Apr 2010 09:33:15 -0700 (PDT) Received: from perhan.alvh.no-ip.org (unknown [190.95.9.187]) by spinlock.commandprompt.com (Postfix) with ESMTPSA id 46D98348036; Mon, 26 Apr 2010 09:33:15 -0700 (PDT) Received: by perhan.alvh.no-ip.org (Postfix, from userid 1000) id ED9616E48C; Mon, 26 Apr 2010 12:33:12 -0400 (CLT) Date: Mon, 26 Apr 2010 12:33:12 -0400 From: Alvaro Herrera To: Julius Tuskenis Cc: pgsql-admin@postgresql.org Subject: Re: when does postgresql read from pg_hba.conf ?? Message-ID: <20100426163312.GB3963@alvh.no-ip.org> References: <4BD53C4B.7020000@nsoft.lt> <20100426153851.GA3963@alvh.no-ip.org> <4BD5B6DF.6000505@nsoft.lt> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: <4BD5B6DF.6000505@nsoft.lt> User-Agent: Mutt/1.5.20 (2009-06-14) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.9 tagged_above=-10 required=5 tests=BAYES_00=-1.9 X-Spam-Level: X-Archive-Number: 201004/334 X-Sequence-Number: 34428 Julius Tuskenis wrote: > Hello, Alvaro Herrera > > 2010.04.26 18:38, Alvaro Herrera rašė: > >Hmm, isn't the file read every time a backend starts on Windows? > >This would explain the problem if the file was edited between 13:56:45 > >and 13:57:38. > > > Do you want to say that on windows postgresql acts differently? Yes. > The pg_hba.conf is read each time the client connects to the > postgresql ? Yes. > Why there is nothing about that in documentation ? (Or did I > manage to mis this?....) I don't know. -- Alvaro Herrera http://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 support