My YunoHost server
Hardware: Raspberry Pi at home
YunoHost version: 4.1.8
I have access to my server : Through SSH | through the webadmin
Are you in a special context or did you perform some particular tweaking on your YunoHost instance ? : just some tiny and mail conf mods
Description of my issue
After a (user-caused) failed backup, my postgresql server will not start.
Currently, the postgres logs give this on an attempted start up:
LOG: invalid record length at 0/2282A70: wanted 24, got 0
LOG: invalid primary checkpoint record
PANIC: could not locate a valid checkpoint record
LOG: startup process (PID 22561) was terminated by signal 6: Aborted
and from around the time of the failure:
LOG: database system was interrupted; last known up at XYZ
LOG: database system was not properly shut down; automatic recovery in progress'
LOG: redo starts at 0/22828E8'
LOG: invalid record length at 0/22829C8: wanted 24, got 0'
LOG: redo done at 0/2282990'
Re the failed backup:
- I tried to do a backup from the webadmin backup section, with everything ticked, which to my surprise meant a 20+gb backup (it was doing things like including existing backup files, because they are in /home/). i had never done it before, so didn’t know how it works. i manually stopped it, maybe from the cli, i cannot remember how, my bad my bad.
Question 1: what is postgresql actually used for? my apps work fine, admin works fine unless i enter the backups section.
Question 2 (depends on q1): do i need to worry about repairing it very carefully?
Looking online at pgql troubleshooting, things don’t look too good. / I’m not sure how to run postgresql server commands, i see only client commands in bash, and i also don’t have a ‘postgres’ command available, which are the two things i have seen used for troubleshooting. i copied the corrupt pgql data dir to work on it, but not sure how to get started.