I have two gnuhealth installed, the first one(HaemaDB) is working in a laboratory for production and the second one (CLIDB) is new installation.
Both installations are of the same system version (Opensuse leap 13.5, gnuhealth 3.8.0-lp153.4.3.1, gnuhealth client 3.8.1-bp153.2.4).
I do backup the data from the first system (HaemaDB) and I want to restore the data into the second system (CLIDB) database.
I follow the wiki instructions below. The backup files are located on new installation desktop (CLIDB). but I couldn't succeed in restoring the data.
Please, what am I miss.
# cd Desktop (change to backup files directory)
# createdb CLIDB (Am not sure which database name to use, 1st, 2nd or to create new out of the two, I try all)
createdb: error: could not connect to database template1: connection to server on socket "/var/run/postgresql/.s.PGSQL.5432" failed: FATAL: role "root" does not exist
# gunzip backup_HaemaDB_2022-04-18_143054.gz (this command does not return any error)
# psql CLIDB < backup_HaemaDB_2022-04-18_143054 (I also try this without the symbol of '<' lessthan, but still with error)
psql: error: connection to server on socket "/var/run/postgresql/.s.PGSQL.5432" failed: FATAL: role "root" does not exist