when does postgresql read from pg_hba.conf ??
am 26.04.2010 09:10:03 von Julius TuskenisThis 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: quoted-printable
Hello, list
from the postgresql documentation I know, that " class=3D"Apple-style-span"
style=3D"border-collapse: separate; color: rgb(0, 0, 0); font-family: 'T=
imes New Roman'; font-style: normal; font-variant: normal; font-weight: n=
ormal; letter-spacing: normal; line-height: normal; orphans: 2; text-inde=
nt: 0px; text-transform: none; white-space: normal; widows: 2; word-spaci=
ng: 0px; font-size: medium;"> class=3D"Apple-style-span"
style=3D"font-family: verdana,sans-serif; font-size: 12px; line-height: =
18px; text-align: left;">The class=3D"Apple-converted-space">Â style=3D"font-size: 1.4em;">pg_hba.conf class=3D"Apple-converted-space">Â file is read on start-up an=
d
when the main server process receives a class=3D"Apple-converted-space">Â =
SIGHUP name=3D"AEN23296">Â >signal.
If you edit the file on an active system, you will need to signal the
server (using class=3D"LITERAL" style=3D"font-size: 1.4em;">pg_ctl reload class=3D"Apple-converted-space"> or class=3D"Apple-converted-space"> style=3D"font-size: 1.4em;">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<=
br>
2010-04-24 13:57:38 EEST FATAL:Â missing or erroneous pg_hba.conf fi=
le
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<=
br>
2010-04-24 13:57:46 EEST FATAL:Â missing or erroneous pg_hba.conf fi=
le
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"
--=20
Julius Tuskenis
Programavimo skyriaus vadovas
UAB nSoft
mob. +37068233050
--------------050004070109010003000505--