[Health] Restore data to new installation

[Yusif Suleiman]

Dear All,

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.

Regards,

Yusuf

# 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