Howto - Upgrade PostgreSQL 8.4 to PostgreSQL 9.3 for GNUmed

Here it is

0.) do a full backup. Save it on some other media then your harddisk ! Do it,
now.

1.) Install PG 9.3 ( I tried with 32bit but should not matter).
- http://get.enterprisedb.com/postgresql/postgresql-9.3.1-1-windows.exe

2.) Run the installer and select (English_UnitedStates) for locale (others
might work as well). Make sure it installs itself on port 5433 (or other but
never ! 5432).

3.) Make sure both PG 8.4 and PG 9.3 are running (e.g. via pgadmin3 from PG
9.3)

4.) open a command shell (dos box) - "run as" administrator (!) in Win7

5.) type : RUNAS /USER:postgres "CMD.EXE"
- this will open another black box (command shell) for user postgres
- for the password use 'postgrespassword' (default)

6.) type: SET PATH=%PATH%;C:\Programme\PostgreSQL\9.3\bin;
- instead of Programme it might be Program Files on your computer

7.) type: cd c:\windows\temp
- changes directory to a writable temporary directory

8.) type: pg_dump -p 5432 -Fc -f gnumedv18.backup gnumed_v18

9.) type: pg_dumpall -p 5432 --globals-only > globals.sql

Important : Protect your PG 8.4 by shutting it down temporarly

10.) type in the first command shell : net stop postgresql-8.4
- check that is says : successfully stopped

11.) psql -p 5433 -f globals.sql
- this will restore roles in the new database (PG 9.3 on port 5433)

12.) pg_restore -p 5433 --dbname postgres --create gnumedv18.backup
- this will restore the database v18 into the PG 9.3 on port 5433

Congratulations. You are done. Now to check some things.

########################################
Here you could run the fingerprint script on both databases to check for an
identical hash

https://gitorious.org/gnumed/gnumed/source/f4c52e7b2b874a65def2ee1b37d8ee3fb3566ceb:gnumed/gnumed/server/gm-fingerprint_db.py

########################################

13.) Open gnumed.conf in c:\programme\gnumed-client\
For the profile GNUmed database on this machine ("TCP/IP": Windows/Linux/Mac)]
change port=5432 to 5433.

14. Run the GNUmed client and check that it is working. If it works (no wrong
schema hash detected) you should see all your patient and data.

15. If you have managed to see you patients and everything is there close
GNUmed client 1.3.x.

16.) in the first command shell type: net stop postgresql-9.3

17.) Go to c:\Ptogramme\PostgresPlus\8.4SS\data and open postgresql.conf. Find
port = 5432 and change it to port = 5433

18.) Go to c:\Programme\Postgresql\9.3\data and open postgresql. Find port =
5433 and change it to 5432. This effectively switches ports for PG 8.4 and 9.3
so PG 9.3 runs on the default port 5432.

19.)  Open gnumed.conf in c:\programme\gnumed-client\
For the profile GNUmed database on this machine ("TCP/IP": Windows/Linux/Mac)]
change port=5433 to 5432.

20.) Restart PG 9.3 with: net start postgresql-9.3.

21.) Open the GNUmed client and connect (to PG 9.3 on port 5432).

22.) Leave PG 8.4 in a shutdown state.

So far we have transferred database v18 from PG 8.4 to 9.3. No data from PG
8.4 is touched/lost.

23.) Now you are free to install gnumed-server v19 and gnumed -client 1.4.
Having installed gnumed-server v19 select 'database upgrade' (not boostrap
database) and it will upgrade your v18 database to a v19 database.

In case you experience problems you can always shut down PG 9.3, switch ports again, install client 1.3.x, start PG 8.4 (net start postgresql-8.4) and work with your old setup.

GNUmed 1.4.0 - PostgreSQL upgrade to 9.1

The release notes prominently tell us that GNUmed 1.4.x requires at least PostgreSQL 9.1.

If you are running the Windows packages and have let GNUmed install PostgreSQL for you you are good to go since it comes with PostgreSQL 9.2 already.

If you are on Ubuntu or Debian Chances are your system still has PostgreSQL 8.x installed.

First check if you run any software that requires you to continue using PostgreSQL 8.x. If so you can install PG 9.1 side by side with it. If not let PG 9.1 replace PG 8.x

It usually works like this.

sudo apt-get install postgresql-9.1
sudo pg_upgradecluster 8.4 main

Then if you don't need PG 8.4 anymore you could

sudo pg_dropcluster --stop 8.4 main
sudo apt-get purge postgresql-8.4

Have fun.

GNUmed 1.4.0 released

Hello all,

I am glad to be able to announce the immediate availability
of the GNUmed 1.4.0 Feature Release.


************************************************
 There are two important things to consider
 before upgrading !

 1) GNUmed 1.4/19.0 REQUIRES PostgreSQL 9.1

 2) Before starting the new client for the first
    time it is VERY advisable to set up an
    organization and a unit thereof to be your
    praxis and praxis location.

************************************************


It brings about the following new features:


        1.4.0

        NEW: generic search in lists
        NEW: nested placeholders
        NEW: placeholder $$
        NEW: list sorting by column header click [thanks J.Luszawski]
        NEW: "Grünes Rezept" for Germany
        NEW: manage your praxis with its branches
        NEW: auto-hint "GVK-GU überfällig"
        NEW: placeholder $$
        NEW: placeholder $$
        NEW: placeholder $$
        NEW: dialog for post-processing template-generated documents
        NEW: meta test type editing
        NEW: management of billables
        NEW: turn patient report results into waiting list entries
        NEW: show relevant measurements in current substances list
        NEW: AUDIT alcohol disorder screening
        NEW: print/export of EMR timeline
        NEW: ATRIA OAC bleeding risk score
        NEW: export of individual document parts
        NEW: EMR tree: support showing revisions
        NEW: manual deletion of encounters

        IMPROVED: hook nesting/cycling detection
        IMPROVED: document in chart mailing of document parts
        IMPROVED: just set DB lang at startup if missing, do not ask
        IMPROVED: substance intake EA: PRW_aim context dependant on substance
        IMPROVED: encounter EA: improved display of patient context
        IMPROVED: new patient EA: warn on existing external ID
        IMPROVED: new patient EA: warn on existing name + DOB
        IMPROVED: substance PRW: prefer previously used as suggestions
        IMPROVED: report failing auto-hints to the user
        IMPROVED: make  be category "admin" so they do not 
delete to soapU
        IMPROVED: measurements workflow adjustments [thanks Jim and Rogerio]
        IMPROVED: enable generic lists" extra buttons to operate on 
multi-selections
        IMPROVED: access level role names
        IMPROVED: check MD5 sum of newly inserted document objects for extra 
paranoia
        IMPROVED: current medication list template
        IMPROVED: backup/restore automatically applies DB settings adjustments
        IMPROVED: default episode "administrative" rather than "administration"
        IMPROVED: EMR tree: listing/editing switch button label
        IMPROVED: EMR tree: show journal for unassociated episodes pool
        IMPROVED: EMR tree: keep expansion state across node edits
        IMPROVED: current_meds_tables/*_notes placeholder can now span pages
        IMPROVED: waiting list [thanks Jerzy]
        IMPROVED: streamlined form templates management
        IMPROVED: display of long-text test results
        IMPROVED: improved SOAP selection list
        IMPROVED: more clinically relevant display of substance intake start
        IMPROVED: test results plotting: deal with "N" pseudo-numeric 
values
        IMPROVED: patient search now supports "LASTNAME, NICKNAME"
        IMPROVED: document tree: keep expansion state across node edits

        19.0

        Requires PostgreSQL 9.1 !

        FIX: disable faulty clin-encounter.sql in v4 -> v5

        NEW: view changes for Jerzy's plugins
        NEW: support data checksums with PG 9.3

        IMPROVED: much simplified table mod announcement signal
        IMPROVED: include FKs in schema version check
        IMPROVED: remove .ddd/.unit from ref.atc
        IMPROVED: EMR entry on deleting a document


Downloads available from:

        http://www.gnumed.de/downloads/client/1.4/
        http://www.gnumed.de/downloads/server/v19/


Client installation:

 Easily installable packages for your platform of choice
 will be available shortly.

 Meanwhile you can run the client from a downloaded tarball
 or use the net based client installer:

        http://www.gnumed.de/downloads/client/gm-install_client_locally.sh

 which you need to download, make executable, and run.

 More information available here:

        http://wiki.gnumed.de/bin/view/Gnumed/InstallerGuideHomeShort


Database installation / upgrade:

 Note that this release, as usual, DOES require
 a database upgrade which you install by

        $> gm-upgrade_server 18 19

 or

        $> cd .../server/bootstrap/
        $> ./upgrade-db.sh 19

 Related information is found here:

        http://wiki.gnumed.de/bin/view/Gnumed/GmManualServerUpgrade


Please download, install, and report problems !

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

mobilECG - accessible clinical-grade electrocardiography

There is a crowdfunding campaign for a medical grade mobile ecg at a fraction of the usual cost.

Go have a look at it and support it.

http://www.indiegogo.com/projects/mobilecg-accessible-clinical-grade-electrocardiography

I am in contact with the creators to see if we can connect it to GNUmed somehow.

GNUmed video presentation

Hi,

for those who are interested in Rogério's talk:

   http://hemingway.softwarelivre.org/fisl14/high/41b/sala41b-high-201307051200.ogg

attendance of the talk was "higher than expected". Hope this will have some influence.

GNUmed 1.3.6 released

Hello all,

I am glad to be able to announce the immediate availability
of the GNUmed 1.3.6 Maintenance Release. It features the
following bug fixes and minor improvements:

Changelog:

        1.3.6

 FIX: exception on merging patients with identical addresses [thanks Jim]
 FIX: exception on repeatedly updating LOINC [thanks A.Maier]
 FIX: exception on getattr() in braindead-tree-items-data-access workaround [thanks V.Banait]
 FIX: exception on detecting patient ID column in patient listing ctrl [thanks Marc]

 IMPROVED: show "U" for soapU data rather than "?" [thanks Jim]
 IMPROVED: print recalls from vaccinations list

        18.6

 FIX: clin_root_item_soap_cat check needs dropping


Downloads available from:

        http://www.gnumed.de/downloads/client/1.3/
        http://www.gnumed.de/downloads/server/v18/


Client installation:

 Easily installable packages for your platform of choice
 will be available shortly.

 Meanwhile you can run the client from a downloaded tarball
 or use the net based client installer:

        http://www.gnumed.de/downloads/client/gm-install_client_locally.sh

 which you need to download, make executable, and run.

 More information available here:

        http://wiki.gnumed.de/bin/view/Gnumed/InstallerGuideHomeShort


Database installation / upgrade:

 Note that this release, as usual, does NOT require a
 database upgrade. However, fixes to the database
 have been provided which you should install
 with either

        gm-fixup_server 18

 or

        cd .../server/bootstrap/
        ./fixup-db.sh 18

 Related information is found here:

        http://wiki.gnumed.de/bin/view/Gnumed/GmManualServerUpgrade


Please download, install, and report problems !

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

Medical Scores available in GNUmed

GNUmed has a lot of scores readily available for use in the medical record.

Grünes Rezept via GNUmed

Mit GNUmed kann man ab sofort ein grünes Rezept bedrucken.

GNUmed - searching in lists

Will be in GNUmed 1.4.

GNUmed 1.3.1 for Virtual machines, Live-DVD and cloud

Get it from https://sourceforge.net/projects/gnumedlive/files/

GNUmed - Überblick per Video

GNUmed 1.3.1 released

Hello all,

I am glad to be able to announce the immediate availability
of the GNUmed 1.3.1 Maintenance Release. It features the
following bug fixes and minor improvements:

Changelog:

        1.3.1

 FIX: make gmHL7 import optional [thanks J.Luszawski/A.Tille]
 FIX: exception on showing timeline [thanks S.Hilbert]
 FIX: exception on searching across EMRs [thanks V.Banait]
 FIX: exception on formatting external IDs in overview [thanks S.Hilbert]
 FiX: exception on merging patients with same comm channel [thanks M.Angermann]

 IMPROVED: have prerequisite check look for python-hl7 [thanks J.Luszawski]
 IMPROVED: patient overview waiting list hint tooltip [thanks J.Busser]

        18.1

 FIX: gm-doctors must be member of gm-public
 FIX: exception dumping schema revision history of early DB versions [thanks Š.Laczi]

 IMPROVED: bootstrapper now checks gm.schema_revision AND public.gm_schema_revision


Downloads available from:

        http://www.gnumed.de/downloads/client/1.3/
        http://www.gnumed.de/downloads/server/v18/


Client installation:

 Easily installable packages for your platform of choice
 will be available shortly.

 Meanwhile you can run the client from a downloaded tarball
 or use the net based client installer:

        http://www.gnumed.de/downloads/client/gm-install_client_locally.sh

 which you need to download, make executable, and run.

 More information available here:

        http://wiki.gnumed.de/bin/view/Gnumed/InstallerGuideHomeShort


Database installation / upgrade:

 Note that this release, as usual, does NOT require a
 database upgrade. However, fixes to the database
 have been provided which you should install
 with either

        $> gm-fixup_server 18

 or

        $> cd .../server/bootstrap/
        $> ./fixup-db.sh 18

 Related information is found here:

        http://wiki.gnumed.de/bin/view/Gnumed/GmManualServerUpgrade


Please download, install, and report problems !

Thanks,
Karsten

GNUmed 1.3.0 released

Hello all,

I am glad to be able to announce the immediate availability
of the GNUmed 1.3.0.3 "御目出度う御座います" Feature Release !


Downloads available from:

        http://www.gnumed.de/downloads/client/1.3/
        http://www.gnumed.de/downloads/server/v18/


Client installation:

 Easily installable packages for your platform of choice
 will be available shortly.

 Meanwhile you can run the client from a downloaded tarball
 or use the net based client installer:

        http://www.gnumed.de/downloads/client/gm-install_client_locally.sh

 which you need to download, make executable, and run.

 More information available here:

        http://wiki.gnumed.de/bin/view/Gnumed/InstallerGuideHomeShort


Database installation / upgrade:

 Note that this release, as usual, DOES require a database
 upgrade from v17 to v18 if you already have a database and
 wish to retain the patient data you documented therein. For
 uprading you can use the script provided in the tarball:

        .../server/bootstrap/upgrade-db.sh 17 18

 Alternatively, you can use the network upgrader:

        http://www.gnumed.de/downloads/server/net_upgrade-gnumed_server.sh

 which you need to download, make executable and run.

 If you wish to install a fresh database (without upgrading
 an existing one) you can use the install script:

        .../server/bootstrap/bootstrap-latest.sh

 or, again, the network based installer:

        http://www.gnumed.de/downloads/server/net_install-gnumed_server.sh

 Note that both ways WILL DELETE existing databases !

 More information on installation or upgrading is found here:

        http://wiki.gnumed.de/bin/view/Gnumed/GmManualServerInstall
        http://wiki.gnumed.de/bin/view/Gnumed/GmManualServerUpgrade


Changelog:

        1.3.0.3

 NEW: visualize the EMR using TheTimelineProject
 NEW: placeholder $$
 NEW: DEGAM UTI 2012 guideline
 NEW: status line in each edit area
 NEW: Xe(La)TeX based forms engine
 NEW: plain text based/generic postprocessing forms engine
 NEW: placeholder $$ operating on keyword expansions
 NEW: encryptable placeholder $$
 NEW: look for installed plugins list in config files, too
 NEW: medical staff vs non-medical staff permissions handling
 NEW: generic gmTextCtrl supporting keyword expansion macros
 NEW: current substances grid: generate Rx either from DB or from form template
 NEW: GVK-Rezept prescription template (darf in D nicht verwendet werden)
 NEW: revamped measurements handling including test panels
 NEW: placeholder $$, selecting SOAP via issues list
 NEW: placeholder $$, selecting SOAP via episodes list
 NEW: progress notes can now be created from EMR tree
 NEW: score: Bird Criteria for Polymyalgia rheumatica
 NEW: score: prediction of bacterial conjunctivitis
 NEW: placeholder $$, include/export documents
 NEW: list placeholders from within client
 NEW: show (e)GFR in substance intake EA
 NEW: placeholder $$, selecting test results from list
 NEW: Epworth Sleepiness Scale
 NEW: placeholder $$ for messages with due date

 IMPROVED: document tree: better labels, tooltips added
 IMPROVED: measurement EA: show most recent value of test type
 IMPROVED: measurement EA: plot adjacent results upon saving
 IMPROVED: support a comment on bills
 IMPROVED: EMR tree: load data when expanding nodes
 IMPROVED: vaccinations list: print vaccinations via template
 IMPROVED: better dynamic text expansion dialog
 IMPROVED: drug component PRW: disambiguate which drug will be picked
 IMPROVED: waiting list: filter by active patient
 IMPROVED: report generator: be smarter about patient ID columns
 IMPROVED: patient overview: display last modified of occupation
 IMPROVED: substances grid: show preparation of items
 IMPROVED: placeholder $$ can let user select entries
 IMPROVED: measurements grid labels
 IMPROVED: (Xe)(La)TeX forms engine recursively substitutes placeholders
 IMPROVED: address: street/subunit level comment can now be removed
 IMPROVED: do not loose has_allergy=True on merging patients
 IMPROVED: health issue EA: safer workflow
 IMPROVED: SOAP plugin: improved selection of most-recent information
 IMPROVED: EMR tree browser: display entire EMR as journal
 IMPROVED: placeholder handler: always properly escape data based on target 
form engine
 IMPROVED: depreciate gmNotebookedProgressNoteInputPlugin from "GNUmed Default" 
workplace
 IMPROVED: EMR Journal: order grouped by encounter or order by last modified of 
items
 IMPROVED: SimpleSoap plugin: enable keyword based text expansions
 IMPROVED: patient overview: show comment on contact in tooltip
 IMPROVED: waiting list entry double-click workflow [thanks J.Busser]
 IMPROVED: database translation contribution code
 IMPROVED: login dialog help text [thanks J.Busser]
 IMPROVED: patient searcher logic [thanks J.Busser]
 IMPROVED: non-overdue recalls display in patient overview
 IMPROVED: provider inbox: much improved workflow

        18.0

 IMRPOVED: add missing PKs to cfg.cfg_* tables for Bucardo use [thanks Marc]
 IMPROVED: include PK columns in schema version check


Please download, install, and report problems !

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

GNUmed Updates for Windows, Mac and Linux

The good news is that GNUmed has seen a steady development over the last few years. The way it currently looks this will not change. The next major release (version 1.3) is about to be released.

To bring this new release to the Windows platform as well as other Linux distributions besides Debian Linux we need help. If you are willing to learn what it takes by being mentored from start to end please contact us.

We have the ressources to teach you how to prepare and distribute packages for Debian, Ubuntu, openSUSE, Fedora, Mac and Windows but we currently lack the time to prepare the packages every time a new version of GNUmed is released.

If you want to help bringing the latest and greates GNUmed to more people (by creating packages) please let us know.

Regards,
Sebastian Hilbert
GNUmed packager