Re: [Gnumed-devel] bootstrapping database problem

[Karsten Hilbert]

On Fri, Sep 05, 2008 at 12:59:05AM -0700, Jim Busser wrote:

>>> postgres-alikes gmadm postgres
>>
>> Same here, that last line is only needed if you have a
>> system user gmadm which you want to use to handle the
>> bootstrapping.
>>
>> In fact, the whole pg_ident.conf business is only needed
>> when you want to bootstrap as a user different from either
>> root or postgres.
>
> I noted (from my exclusion of gmadm from my sudoers file) that without 
> sudo, the system user gmadm cannot bootstrap.
>
> Why is that, since I would have thought that proper configuration of  
> postgres would cause PostgreSQL to allow gmadm to do whatever PostgreSQL 
> would allow postgres to do.
>
> Is it a "postgres" thing, or is there something that must be done at the 
> system level that requires that gmadm be a sudoer?

I just checked - the upgrade-db.sh script should work just
fine. The bootstrap-latest.sh still tries to su to
"postgres" in order to check for existing databases and drop
staging databases afterwards. Both are not mandatory,
though. Commenting out those lines should make the
bootstrapper work just fine.

I believe people who are bent on using another account to
bootstrap better know what they do.

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