Re: [Gnumed-devel] Re: GNUmed packaging help needed

[Karsten Hilbert]

On Mon, Mar 09, 2009 at 12:11:10PM +0100, Karsten Hilbert wrote:

> If you aren't fully convinced that it is hard to automate
> correctly you could, by definition, simply do it, no ? :-)
> 
> It's surely possible but it takes quite a bit of code.

Here is some pseudo code:

1) find all PostgreSQL servers on the machine

        - local TCP/IP
        - UNIX domain sockets
        - may not even be running currently

2) within those detect all GNUmed databases

        - skip some, like "postgres" and "templateX"

3) ask user which database in which server to upgrade

4) ask user which version to upgrade to

        - verify "to > from"

5) detect whether existing databases would be overwritten

        - ask user for confirmation

6) generate upgrade script based on the above


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