Received: from maia.hub.org (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id B116D632A82 for ; Mon, 26 Apr 2010 04:10:18 -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 35874-08 for ; Mon, 26 Apr 2010 07:10:08 +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 A8A7C632982 for ; Mon, 26 Apr 2010 04:10:07 -0300 (ADT) Received: (qmail 7110 invoked by uid 210); 26 Apr 2010 07:10: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.022729 secs); 26 Apr 2010 07:10:04 -0000 Received: from mail.nsoft.lt (77.240.249.53) by mail.csc.lt with SMTP; 26 Apr 2010 07:10: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 1C4448E04C for ; Mon, 26 Apr 2010 10:10:02 +0300 (EEST) Message-ID: <4BD53C4B.7020000@nsoft.lt> Date: Mon, 26 Apr 2010 10:10: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: when does postgresql read from pg_hba.conf ?? Content-Type: multipart/alternative; boundary="------------050004070109010003000505" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.894 tagged_above=-10 required=5 tests=BAYES_50=0.8, HTML_MESSAGE=0.001, HTML_OBFUSCATE_10_20=0.093 X-Spam-Level: X-Archive-Number: 201004/328 X-Sequence-Number: 34422 This is a multi-part message in MIME format. --------------050004070109010003000505 Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit Hello, list from the postgresql documentation I know, that "The pg_hba.conf file is read on start-up and when the main server process receives a SIGHUP signal. If you edit the file on an active system, you will need to signal the server (using pg_ctl reload or kill -HUP) to make it re-read the file." But there have been an incident this Saturday that indicates, that these are not the only triggers for reading pg_hba.conf. One of our clients edited pg_hba.conf that day (not correctly I must add), but neither restarted nor reloaded the postgresql (logs below confirm that). Anyway at some point the system started using the newly edited file causing some problems. What could cause the pg_hba.conf to be read by postgresql ? OS: Win XP SP3 DB: Postgresql 8.3 The log (from pg_log): 2010-04-24 13:49:43 EEST LOG: loaded library "$libdir/plugins/plugin_debugger.dll" 2010-04-24 13:51:07 EEST LOG: loaded library "$libdir/plugins/plugin_debugger.dll" 2010-04-24 13:52:31 EEST LOG: loaded library "$libdir/plugins/plugin_debugger.dll" 2010-04-24 13:53:54 EEST LOG: loaded library "$libdir/plugins/plugin_debugger.dll" 2010-04-24 13:55:22 EEST LOG: loaded library "$libdir/plugins/plugin_debugger.dll" 2010-04-24 13:56:45 EEST LOG: loaded library "$libdir/plugins/plugin_debugger.dll" 2010-04-24 13:57:38 EEST LOG: loaded library "$libdir/plugins/plugin_debugger.dll" 2010-04-24 13:57:38 EEST LOG: invalid IP mask "md5" in file "C:/Program Files/PostgreSQL/8.3/data/pg_hba.conf" line 72: Unknown host 2010-04-24 13:57:38 EEST FATAL: missing or erroneous pg_hba.conf file 2010-04-24 13:57:38 EEST HINT: See server log for details. 2010-04-24 13:57:46 EEST LOG: loaded library "$libdir/plugins/plugin_debugger.dll" 2010-04-24 13:57:46 EEST LOG: invalid IP mask "md5" in file "C:/Program Files/PostgreSQL/8.3/data/pg_hba.conf" line 72: Unknown host 2010-04-24 13:57:46 EEST FATAL: missing or erroneous pg_hba.conf file 2010-04-24 13:57:46 EEST HINT: See server log for details. 2010-04-24 13:58:05 EEST LOG: loaded library "$libdir/plugins/plugin_debugger.dll" 2010-04-24 13:59:28 EEST LOG: loaded library "$libdir/plugins/plugin_debugger.dll" 2010-04-24 13:59:58 EEST LOG: loaded library "$libdir/plugins/plugin_debugger.dll" -- Julius Tuskenis Programavimo skyriaus vadovas UAB nSoft mob. +37068233050 --------------050004070109010003000505 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: 8bit Hello, list

from the postgresql documentation I know, that "The pg_hba.conf file is read on start-up and when the main server process receives a SIGHUP signal. If you edit the file on an active system, you will need to signal the server (using pg_ctl reload or kill -HUP) to make it re-read the file."

But there have been an incident this Saturday that indicates, that these are not the only triggers for reading pg_hba.conf. One of our clients edited pg_hba.conf that day (not correctly I must add), but neither restarted nor reloaded the postgresql (logs below confirm that). Anyway at some point the system started using the newly edited file causing some problems. What could cause the pg_hba.conf to be read by postgresql ?

OS: Win XP SP3
DB: Postgresql 8.3

The log (from pg_log):
2010-04-24 13:49:43 EEST LOG:  loaded library "$libdir/plugins/plugin_debugger.dll"
2010-04-24 13:51:07 EEST LOG:  loaded library "$libdir/plugins/plugin_debugger.dll"
2010-04-24 13:52:31 EEST LOG:  loaded library "$libdir/plugins/plugin_debugger.dll"
2010-04-24 13:53:54 EEST LOG:  loaded library "$libdir/plugins/plugin_debugger.dll"
2010-04-24 13:55:22 EEST LOG:  loaded library "$libdir/plugins/plugin_debugger.dll"
2010-04-24 13:56:45 EEST LOG:  loaded library "$libdir/plugins/plugin_debugger.dll"
2010-04-24 13:57:38 EEST LOG:  loaded library "$libdir/plugins/plugin_debugger.dll"
2010-04-24 13:57:38 EEST LOG:  invalid IP mask "md5" in file "C:/Program Files/PostgreSQL/8.3/data/pg_hba.conf" line 72: Unknown host
2010-04-24 13:57:38 EEST FATAL:  missing or erroneous pg_hba.conf file
2010-04-24 13:57:38 EEST HINT:  See server log for details.
2010-04-24 13:57:46 EEST LOG:  loaded library "$libdir/plugins/plugin_debugger.dll"
2010-04-24 13:57:46 EEST LOG:  invalid IP mask "md5" in file "C:/Program Files/PostgreSQL/8.3/data/pg_hba.conf" line 72: Unknown host
2010-04-24 13:57:46 EEST FATAL:  missing or erroneous pg_hba.conf file
2010-04-24 13:57:46 EEST HINT:  See server log for details.
2010-04-24 13:58:05 EEST LOG:  loaded library "$libdir/plugins/plugin_debugger.dll"
2010-04-24 13:59:28 EEST LOG:  loaded library "$libdir/plugins/plugin_debugger.dll"
2010-04-24 13:59:58 EEST LOG:  loaded library "$libdir/plugins/plugin_debugger.dll"
-- 
Julius Tuskenis
Programavimo skyriaus vadovas
UAB nSoft
mob. +37068233050
--------------050004070109010003000505--