Re: [Health] Restore data to new installation

[Yusif Suleiman]

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