Re: [Gnumed-devel] Re: Development testing on Production (?) servers -- was 0.3-rc4 released

[Karsten Hilbert]

On Mon, Aug 18, 2008 at 08:24:55PM -0700, James Busser wrote:

>> I see no problem.
>> Create backup (or schema scripts) of current db. (use pgadmin3 or  
>> pg_dump)
>> Create new db with different name.
>> Restore data from backup or generate schema in the new database. (use 
>> psql \i command, pgadmin did not work)
>> Modify gm-from-cvs.conf adding a profile pointing to the new database.
>
> Karsten's recent comment (below). It only makes me wonder if there is  
> additional manual work beyond what Jerzy listed above for example the  
> need to do a global replace on name within the bootstrap scripts

If Jerzy's approach with dump/restore is used then, no,
changing anything in the bootstrapping scripts is not
required.

> Would there be a problem to use same permissions as would have been used 
> for the production version?

There would. The users would need to be given explicit
access to the new database.

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