Re: [Gnumed-devel] Re: v0.5 rc2 and ? upgrading the database 10->11?

[Karsten Hilbert]

On Fri, Jun 26, 2009 at 10:03:23AM -0700, Jim Busser wrote:

> In the client, we do now have under the GNUmed menu "Announce  
> maintenance" (to-be-renamed Announce downtime)

Done.

> which gives users notice 
> although does not itself disconnect the users. Before upgrading 
> therefore, does one need to give the postgres server instructions from 
> the command line to stop running and/or otherwise sever the connections, 
> thus kicking off any users who would have ignored the notice?

Possibly, yes, if there was no other way.

> Can we maybe insert into the upgrade script, between the two ECHO  
> paragraphs, a new (middle) one below? Also in the original paragraph  
> "The existing database" can we say "will be" (not "is")?

Done.

> This will update an existing GNUmed version 10
> database to the version 11 schema. It does not do
> any harm to the data contained within.
>
> It must be run as root or via sudo (or postgres??)
> and the database must not be in use by other users.

Done.

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