Received: from maia.hub.org (unknown [200.46.208.211]) by mail.postgresql.org (Postfix) with ESMTP id 2CA5B6335A9 for ; Mon, 26 Apr 2010 12:53:19 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.208.211]) (amavisd-maia, port 10024) with ESMTP id 03144-07 for ; Mon, 26 Apr 2010 15:53:07 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from mail.csc.lt (mail.csc.lt [193.138.191.5]) by mail.postgresql.org (Postfix) with ESMTP id CB5AA633036 for ; Mon, 26 Apr 2010 12:53:07 -0300 (ADT) Received: (qmail 14997 invoked by uid 210); 26 Apr 2010 15:53:04 -0000 Received: from mail.nsoft.lt by mail (envelope-from , uid 201) with qmail-scanner-2.05st (clamdscan: 0.95.3/10819. spamassassin: 3.2.1. perlscan: 2.05st. Clear:RC:1(77.240.249.53):. Processed in 0.011741 secs); 26 Apr 2010 15:53:04 -0000 Received: from mail.nsoft.lt (77.240.249.53) by mail.csc.lt with SMTP; 26 Apr 2010 15:53:04 -0000 Received: from [192.168.16.103] (unknown [77.240.249.53]) (using TLSv1 with cipher DHE-RSA-CAMELLIA256-SHA (256/256 bits)) (No client certificate requested) by mail.nsoft.lt (Postfix) with ESMTPS id 95BB38E04C for ; Mon, 26 Apr 2010 18:53:02 +0300 (EEST) Message-ID: <4BD5B6DF.6000505@nsoft.lt> Date: Mon, 26 Apr 2010 18:53:03 +0300 From: Julius Tuskenis Organization: UAB nSoft User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; lt; rv:1.9.1.9) Gecko/20100317 Lightning/1.0b1 Thunderbird/3.0.4 MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: Re: when does postgresql read from pg_hba.conf ?? References: <4BD53C4B.7020000@nsoft.lt> <20100426153851.GA3963@alvh.no-ip.org> In-Reply-To: <20100426153851.GA3963@alvh.no-ip.org> Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-0.099 tagged_above=-10 required=5 tests=AWL=-0.899, BAYES_50=0.8 X-Spam-Level: X-Archive-Number: 201004/331 X-Sequence-Number: 34425 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? The pg_hba.conf is read each time the client connects to the postgresql ? Why there is nothing about that in documentation ? (Or did I manage to mis this?....) -- Julius Tuskenis Programavimo skyriaus vadovas UAB nSoft mob. +37068233050