Re: [Gnumed-devel] backup-…-roles.sql

[Karsten Hilbert]

On Mon, May 30, 2011 at 09:15:21PM -0700, Jim Busser wrote:

> Here is the content of my backup of roles.sql
> 
>       -- -----------------------------------------------------
>       -- Below find a list of database roles which were in use
>       -- in the GNUmed database "gnumed_v15".
>       --
>       -- Only those need to be restored to create a working
>       -- copy of your original database. All other roles can
>       -- be commented out by prepending '-- ' to the relevant
>       -- lines above.
>       -- -----------------------------------------------------
> 
>       -- get_users
>       
> {gm-logins,gm-public,gm-doctors,gnumed_v15,kahi,test-doc,any-doc,test-secretary,test-nurse,gm-dbo}
>       (1 row)
> 
> Can it be explained which might be the "other roles [which] can be commented 
> out by prepending '--' …

All other roles that may have existed in the PostgreSQL
installation from which the database had been backed up.

Those are listed above the snippet of the file you quote above.

> Also, what is gnumed_v15 doing in there among the "roles"?

It is a role, hence it is backed up. Membership in that role
defines which roles can connect to this database. At least
that's the default setup/recommendation GNUmed delivers.

Karsten
-- 
GPG key ID E4071346 @ gpg-keyserver.de
E167 67FD A291 2BEA 73BD  4537 78B9 A9F9 E407 1346