Re: Explicit configuration file - Mailing list pgsql-hackers

From Peter Eisentraut
Subject Re: Explicit configuration file
Date
Msg-id Pine.LNX.4.30.0112121806160.627-100000@peter.localdomain
Whole thread Raw
In response to Re: Explicit configuration file  (mlw <markw@mohawksoft.com>)
List pgsql-hackers
mlw writes:

> One huge problem I have with symlinks is an admin has to "notice" that
> two files in two separate directories, possibly on two different
> volumes, are the same file, so it is very likely the ramifications of
> editing one file are not obvious.
>
> If, in the database configuration file, pghbaconfig points to
> "/etc/pg_hba.conf" it is likely, that the global significance of the
> file is obvious.

How about making the "local" pg_hba.conf symlinked to /etc/pg_hba.conf?
Should be the same, no?

I guess I'm losing the symlink debate, but anyway...

Consider this:  What if I want to share my postgresql.conf file (because
of the clever performance tuning) but not my pg_hba.conf file (because I
have completely different databases and users in each server).  I think
that case should be covered as long as we're moving in this direction.

I think looming in the back is the answer, "add an 'include' directive to
postgresql.conf".

-- 
Peter Eisentraut   peter_e@gmx.net



pgsql-hackers by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: pg_dump: Sorted output, referential integrity
Next
From: Peter Eisentraut
Date:
Subject: Re: Explicit configuration file