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

Where do pg_hba.conf include files live?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: pgsql-hackers(at)postgreSQL(dot)org
Subject: Where do pg_hba.conf include files live?
Date: 2004-12-25 20:40:46
Message-ID: 17658.1104007246@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-hackers
The SGML docs state that include files referenced by "@foo" constructs
in pg_hba.conf "must be in the same directory as pg_hba.conf".  The
actual implementation, however, assumes they must be in DataDir.
This is no longer the same thing after the introduction of the
data_directory and hba_file GUC parameters.

It seems to me that in a context where you are storing pg_hba.conf in a
separate configuration directory, putting the include files in that same
directory is the behavior you'd want.  On the other hand, the contents
of those files would often be data-cluster-specific (since they'd
typically be lists of user or database names).  Maybe the code behavior
is still sensible.

One thing that's probably *not* sensible either way is that the code
forcibly prepends the directory name even if it's fed "@/abs/path".
I think if an absolute path is given it should be honored.  That would
give an "out" for DBAs who want whichever behavior we don't provide.

The changes to fix the code, if we decide the code is wrong rather than
the docs, do not look very large; so I don't think we need to decide
this on the basis of it being too late to change for 8.0.

Comments?

			regards, tom lane

Responses

pgsql-hackers by date

Next:From: RĂ©mi ZaraDate: 2004-12-25 21:15:30
Subject: Re: Regression (semi)fix for netbsd-mac68k
Previous:From: Tom LaneDate: 2004-12-24 20:45:45
Subject: Re: Reclaiming Index Free Pages

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