Re: [Health] Restore data to new installation

[Gerald Wiese]

Hey Yusuf,

as the message says your backup file is not found.

Check your files in current working directory by typing "ls" to see if it is there. Did you copy it to your machine where you want to restore?

Anyway don't leave the "<".

Best

Gerald

On 5/7/22 12:30, Yusif Suleiman wrote:

Dear Axel,

Looks like you were trapped in the ditch between vanilla and package based

installation. From your original post:

>>>You are very right.

I now check to see the owner of the db:

The main gnuhealth_database & the new_db I just created are own by tryton, and postgres is own by postgres, according to the list.

I also try to follow this instructions below.

Create an empty database:
su postgres
createdb mydb --encoding='UTF-8' --owner=tryton
psql mydb < backup_Fitrah_DB_2022-04-18_143054
(or what your backup is called)

HTH
Axel

However, while it seem like I am getting it right.

# su postgres

postgres@localhost:/home/user> createdb newdb --encoding='UTF-8' --owner=tryton

then, this error came again

postgres@localhost:/home/user> psql newdb < backup_Fitrah_DB_2022-04-18_143054

bash: backup_Fitrah_DB_2022-04-18_143054: No such file or directory

postgres@localhost:/home/user> psql newdb backup_Fitrah_DB_2022-04-18_143054

psql: error: connection to server on socket "/var/run/postgresql/.s.PGSQL.5432" failed: FATAL:  role "backup_Fitrah_DB_2022-04-18_143054" does not exist

Here I use the complete path of the backup file, with same error

postgres@localhost:/home/user> psql newdb < backup_gnuhealth_Fitrah_DB_fs_2022-04-18_143054

bash: backup_gnuhealth_Fitrah_DB_fs_2022-04-18_143054: No such file or directory

I am still trapped in that ditch, please help.

Yusuf