Re: [Health] Upgrading gnuhealth 3.2 to 3.4

[Axel Braun]

Hello Maah,

Am Montag, 30. September 2019, 20:55:58 CEST schrieb Maah Moussa:

> I am facing troubles upgrading the database from 3.2 to 3.4 on OpenSuse.
> Same as some posts I have seen which I haven’t seen a conclusion. Please
> let me know if there is a new process to try.

In general the process as described here 
https://en.wikibooks.org/wiki/GNU_Health/Upgrade
applies.

- stop gnuhealth (systemctl stop gnuhealth)
- create a backup of your system
(gnuhealth-control backup --backdir <directory> --database <dbname>)

- upgrade your installation. If you run an older version of Leap, you need to 
add the GNU Health 3.4 repository beforehand. Example Leap 15.0:

zypper ar -f https://download.opensuse.org/repositories/Application:/ERP:/
GNUHealth:/3.4/openSUSE_Leap_15.0 gh34

- now run the upgrade
zypper up gnuhealth

- you may want to check that the latest version is installed:
zypper if gnuhealth

- apply the database patch as user 'postgres', see 
/usr/share/doc/packages/gnuhealth/upgrade/3.4

su postgres
psql <dbname> < /usr/share/doc/packages/gnuhealth/upgrade/3.4/upgrade_34.sql

[exit from user postgres]

- Upgrade the DB:
trytond-admin -c /etc/tryton/trytond.conf --all -v -d <dbname>

- start gnuhealth:
systemctl start gnuhealth