[Dbconfig-common-devel] Status of "editing pg_hba.conf"

[Karsten Hilbert]

On Thu, Jan 25, 2007 at 11:59:18AM +0100, Karsten Hilbert wrote:

> - GNUmed connects gm-dbo to new GNUmed database
> 	- why: to run the rest of the GNUmed DDL such
> 	       that everything is owned by gm-dbo
> 	- not every PG object can be given explicit
> 	  ownership yet (we still support PG 7.4)
> 	- this can be done by requiring md5 access
> 	  for gm-dbo even on UNIX domain sockets
>  	- for that, however, we need to edit pg_hba.conf
> 	- personally, I am fine with popping up an editor
> 	  with pg_hba.conf in it and showing instructions
> 	  on what to do

I think I may have found a solution. PostgreSQL has an SQL
equivalent for SU. I'll try connecting as the superuser and
SUing to gm-dbo inside the database and then creating all
the objects. They should then all be owned by gm-dbo.

This should allow us to then instruct the admin to add

local   samegroup       +gm-logins          md5

or whatever she choses to pg_hba.conf after installation.

Karsten
-- 
GPG key ID E4071346 @ wwwkeys.pgp.net
E167 67FD A291 2BEA 73BD  4537 78B9 A9F9 E407 1346