|
From: | Gerald Wiese |
Subject: | Re: [Health] Restore data to new installation |
Date: | Sat, 7 May 2022 13:49:51 +0200 |
User-agent: | Mozilla/5.0 (X11; Linux x86_64; rv:91.0) Gecko/20100101 Thunderbird/91.5.0 |
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
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 postgrespostgres@localhost:/home/user> createdb newdb --encoding='UTF-8' --owner=tryton
then, this error came againpostgres@localhost:/home/user> psql newdb < backup_Fitrah_DB_2022-04-18_143054bash: backup_Fitrah_DB_2022-04-18_143054: No such file or directory
postgres@localhost:/home/user> psql newdb backup_Fitrah_DB_2022-04-18_143054psql: 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 errorpostgres@localhost:/home/user> psql newdb < backup_gnuhealth_Fitrah_DB_fs_2022-04-18_143054bash: backup_gnuhealth_Fitrah_DB_fs_2022-04-18_143054: No such file or directory
I am still trapped in that ditch, please help.Yusuf
[Prev in Thread] | Current Thread | [Next in Thread] |