[Gnumed-devel] upgrading PG on Windows

[Sebastian Hilbert]

Hi all,

I did some testing with regards to upgrading PostgreSQL on WIndows.

The good news: PG 8.4 (PostgresPlus) and PG 9.2 coexist.I installed PGPlus 8.4 
manually and bootstraped GNUmed datbase 18.8 without problems. PG was 
automatically installed on the default port 5432.

The I installed PG 9.2 which comes with GNUmed v19. It installed itself 
automatically on port 5433 so it can coexist. To reproduce download

http://www.gnumed.de/downloads/prerequisites/postgresql-9.2.3-2-windows.exe
http://www.gnumed.de/downloads/prerequisites/SilentInstall.bat

Run silentinstall.bat.

All of the above created UTF-8 databases as one can check with

c:\Program Files\PostgresPlus\8.4SS\bin\psql.exe -l -d postgres -p 5432 -U 
postgres

On my system if gives:

    Name    | Eigent\xFCmer | Kodierung |    Sortierfolge     |     Zeichentyp
    |    Zugriffsrechte
------------+---------------+-----------+---------------------+-----------------
----+-----------------------
 gnumed_v10 | gm-dbo        | UTF8      | German_Germany.1252 | 
German_Germany.1
252 |
 gnumed_v11 | gm-dbo        | UTF8      | German_Germany.1252 | 
German_Germany.1
252 |
 gnumed_v12 | gm-dbo        | UTF8      | German_Germany.1252 | 
German_Germany.1
252 |
 gnumed_v13 | gm-dbo        | UTF8      | German_Germany.1252 | 
German_Germany.1
252 |
 gnumed_v14 | gm-dbo        | UTF8      | German_Germany.1252 | 
German_Germany.1
252 |
 gnumed_v15 | gm-dbo        | UTF8      | German_Germany.1252 | 
German_Germany.1
252 |

You can use pgadmin3 to connect to both PG installations at the same time.

Anyway I am now working on the backup and restore procedure. So far we have 
established that PG 8.4 and 9.2 can coexist and run at the same time.

PG 8.4 is not touched.
Sebastian