[Dbconfig-common-devel] PostgreSQL access rights handling

[sean finney]

On Fri, Sep 23, 2005 at 04:35:39PM +0200, Karsten Hilbert wrote:
> When I try to install it for the very first time PostgreSQL
> does not offer the proper access rights to have the database
> installed. One would first have to modify pg_hba.conf for
> the install to succeed.
> 
> What is the suggested procedure to solve this common problem
> (making sure the database server has appropriate access
>  rights before attempting to install a database) ?

i don't know that we've come to an agreement on the matter, actually.
i'm very much hesitant to append/delete lines from the pg_hba.conf
automatically, and it's questionable whether policy would
allow it at all.

a while back andreas and i discussed the possibility of asking
upstream postgres folks to introduce a "conf.d" style directory
in which we could dynamically add information, but i don't think
anythying came of it (or, that he or i contacted them at all, heh).

if that's not a possibility, i'm thinking that a happy medium
for the time being would be to add code to dbconfig-common that

a - guesses by reading pg_hba.conf and based on install settings if
    there will be a problem
b - if (a), generate and output via debconf the line that should be added,
    and tell the admin what to do before hitting "ok".


what do you think?  i've got a pretty big backlog of work right now and
i can't promise to have time to implement something like that soon,
so, um, patches are welcome :)


	sean

-- 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 189 bytes
Desc: Digital signature
Url : http://lists.alioth.debian.org/pipermail/dbconfig-common-devel/attachments/20050924/949f5751/attachment.pgp