Hello Hirama666
Hirama666 Once I read that it is impossible to restore the backup SQL file in RosarioSIS, is this true?
Where did you read that?
Hirama666 What if I made the update with the whole new version, how I can restore my data in the new system?
Hopefully you won't have to restore your database. Please report any issue you may face with the update process at https://github.com/francoisjacquet/rosariosis/issues
If you want to restore a backup, you can for example run the following SQL query:
DROP OWNED BY your_db_user;
And then import your .sql
backup file using this command in the terminal:
$ psql -U your_db_user -d your_db_name -f your_backup_file.sql
Or, if you use PhpPgAdmin, you can execute the above SQL query, and then import your .sql
backup file. Just make sure to uncheck "Paginate results" as always.