Re: [Health] Restore data to new installation

[Yusif Suleiman]

Dear Armand,

Please, how can I check the gnuhealth database owner?

Maybe this procedure will be easier for me.

Yusuf.

---

From: Health <health-bounces+yusifsuleiman=hotmail.com@gnu.org> on behalf of Armand MPASSY-NZOUMBA via Health <health@gnu.org>
Sent: Thursday, May 5, 2022 9:33 AM
To: General GNU Health discussion and help <health@gnu.org>
Cc: Armand MPASSY-NZOUMBA <armandmpassy@yahoo.com>
Subject: Re: [Health] Restore data to new installation

 

Hello Yusuf,

According to the error message, you are using the wrong user. May you check the gnuhealth database owner and use it?

Kind regards 

Armand 

On 5. May 2022, at 07:55, Yusif Suleiman <yusifsuleiman@hotmail.com> wrote:



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