Re: pg_hba

Christopher Browne wrote:
> "Arcadius A." <ahouans@sh.cvut.cz_!!!NOSPAM!!!> writes:
>
>>Once, I've asked about the pg_hb.conf file ....
>>IMHO, writing an app for parsing/editing that file *may* be a problem
>>for those who develop control panels used by web hosting companies ....
>>
>>IMHO, moving the info in pg_hb.conf into the DB itself may attract
>>control panel developers.
>
>
> ... Then create a table, along with a trigger/procedure that can dump
> the contents out to pg_hba.conf, and initiate a "kill -HUP".
>
> Shouldn't be /too/ terribly difficult to implement.
>
> And that would indeed be somewhat useful.

Christopher, thanks for the input :-)

But when you have 100+ user accounts in the RDBMS, is It secure to be
dumping a DB to a text file?(remember, system can fail while data is
being written to the text file .... )
And do not forget that there is a defined order for the rules in the
pg_hba.conf file, so,it's not obvious to just dump a DB into it...

BTW: assuming that your trigger/procedure works well without corrupting
  pg_hba.conf, then what's the point of keeping the pg_hba.conf file and
duplicating data since all the info are already available in the RDBMS?

Regards.

Arcadius.