Skip site navigation (1) Skip section navigation (2)

Re: pg_hba.conf pre-parsing change

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
Cc: pgsql-hackers(at)postgreSQL(dot)org
Subject: Re: pg_hba.conf pre-parsing change
Date: 2001-07-31 23:20:14
Message-ID: 27855.996621614@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-committerspgsql-hackers
Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> writes:
>> Would it make sense to do fstat calls on these files and reload whenever
>> we observe that the file modification time has changed?  That'd be an
>> additional kernel call per connection attempt, so I'm not at all sure
>> I want to do it ... but it ought to be debated.  Comments anyone?

> We could, but we don't with postgresql.conf so it made sense to keep the
> behavior the same for the two files.

I'm inclined to agree --- for one thing, this allows one to edit the
files in place without worrying that the postmaster will pick up a
partially-edited file.  But I wanted to throw the issue out to pghackers
to see if anyone would be really unhappy about having to SIGHUP the
postmaster after changing the authorization conf files.

In any case, if we don't change the code, the change in behavior from
prior releases needs to be documented...

			regards, tom lane

In response to

Responses

pgsql-hackers by date

Next:From: Tom LaneDate: 2001-07-31 23:39:05
Subject: Re: [PATCHES] Allow IDENT authentication on local connections (Linux only)
Previous:From: Bruce MomjianDate: 2001-07-31 23:14:49
Subject: Re: pg_hba.conf pre-parsing change

pgsql-committers by date

Next:From: Bruce MomjianDate: 2001-07-31 23:39:15
Subject: Re: Re: pg_hba.conf pre-parsing change
Previous:From: Bruce MomjianDate: 2001-07-31 23:14:49
Subject: Re: pg_hba.conf pre-parsing change

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group