Re: [Health] GNUHealth back-up

[Dr. Axel Braun]

Hello Yusif

the backup taken with gnuhealth_control consists of 2 parts:

- files and attachments in /var/lib/tryton - copy them into that place again, 
and take care about owner and access rights

- the database, which is a SQL backup taken with pg_dump
you can use e.g. pg_restore to restore 
https://www.postgresql.org/docs/14/app-pgrestore.html

(out of my head: it should work with 
psql your_new_DB < what_your_file_is_called.sql
as well)

HTH
Axel
Am Dienstag, 8. März 2022, 21:57:54 CET schrieb Yusif Suleiman:
> Hi.
> Thank you, it worked. I appreciate.
> Please, how can I upload those files on another/new database.
> 
> Regarding the upgrade to 3.8 or 4.0, will it not affect the records and the
> configuration.. Regards.
> Yusuf
> ________________________________
> From: Gerald Wiese <wiese@gnuhealth.org>
> Sent: Friday, February 25, 2022 11:31 AM
> To: Yusif Suleiman <yusifsuleiman@hotmail.com>; health@gnu.org
> <health@gnu.org>; edgar@hagenbichler.at <edgar@hagenbichler.at> Subject:
> Re: GNUHealth back-up
> 
> Dear Yusif,
> 
> those characters '<' and '>' are placeholders. Please try it again without
> them and those brackets [].
> 
> Besides I'd recommend to use an absolute path like
> /home/yourusername/Desktop
> 
> Also there is GNU Health 3.8 and even 4.0 beta, if you want to upgrade.
> 
> About your second question regarding the invoice: Please tell what steps you
> did, otherwise it's difficult to say if you missed one.
> 
> Best
> 
> Gerald
> 
> On 2/24/22 23:46, Yusif Suleiman wrote:
> > Dear All,
> > While working with gnuhealth on a laboratory for production, we decided to
> > back-up the data. I followed the documentation on Wiki Control Center, in
> > order to back up my db before going to the production Dbase, and I have
> > these errors.
> > 
> > Someone should please help me. 'Desktop' is directory for saving the
> > backup, and 'UCHealth' is the name of the database on my system.
> > 
> > # gnuhealth-control version
> > 3.6.5.1-openSUSE
> > 
> > usage: gnuhealth-control command [options]
> > 
> > Command:
> >    version : Show version
> >    backup  : Backup the gnuhealth kernel, attach dir and database
> >    update  : Download and install the patches
> >    getlang : Get and install / update the language pack code
> >    status  : Show environment and GNU Health Tryton server status
> > 
> > Options:
> >   --backdir  : destination directory for the backup file
> >   --dry-run  : Check, download and preview, but don't actually update
> >   process
> >   --database : database name to use with the backup command
> > 
> > # gnuhealth-control backup --database
> > 2022-02-24 22:11:56 [INFO] Environment variables
> > 2022-02-24 22:11:56 [INFO] PYTHONPATH =
> > Usage : gnuhealth-control backup --backdir <directory> --database <dbname>
> > 
> > # gnuhealth-control backup --backdir <desktop> --database <UCHealth>
> > bash: syntax error near unexpected token `newline'
> > 
> > # gnuhealth-control backup --backdir <desktop> --database <UCHealth>
> > bash: syntax error near unexpected token `newline'
> > 
> > # gnuhealth-control backup --backdir <desktop> --database [UCHealth]
> > bash: desktop: No such file or directory
> > 
> > # gnuhealth-control backup --backdir [desktop] --database [UCHealth]
> > 2022-02-24 22:15:44 [INFO] Environment variables
> > 2022-02-24 22:15:44 [INFO] PYTHONPATH =
> > 2022-02-24 22:15:44 [ERROR] Backup directory [desktop] not found !
> > 
> >   # gnuhealth-control backup --backdir [Desktop] --database [UCHealth]
> > 
> > 2022-02-24 22:16:00 [INFO] Environment variables
> > 2022-02-24 22:16:00 [INFO] PYTHONPATH =
> > 2022-02-24 22:16:00 [ERROR] Backup directory [Desktop] not found !
> > 
> > Secondly, it was very easy to generate invoice on Demo database, but I try
> > to generate an invoice on my installed database I couldn't. Maybe I miss
> > a step.
> > 
> > looking forward for your support.
> > Regards.
> > Yusuf


-- 
Dr.-Ing. Axel K. Braun 
M: +49.173.7003.154
T: @coogor
Matrix: @docb:matrix.org
PGP Fingerprint: 2E7F 3A19 A4A4 844A 3D09 7656 822D EB64 A3BA 290D
Public Key available at http://www.axxite.com/axel.braun@gmx.de.asc

Meet GNU Health at Geneva Health Forum 24.-26. March 2020 in Geneva/CH
http://gnuhealth.ghf2020.org