Nextcloud version : 23.0.2
Operating system and version : Arch Linux
Apache or nginx version : N/A
PHP version : 8.0.14
The issue you are facing:
My postgres database needed a major update from v13 to v14, and in the process of updating it, I managed to delete both the current postgres data folder, as well as the backup. I can take care of backing up my explicit Nextcloud files, but I need to figure out what else can be saved such as my passwords database from the passwords app, my calendars, tasks, etc.
I’m in a great bind here.
Is this the first time you’ve seen this error? : Y
Steps to replicate it:
- Prepare to upgrade postgres database major version
- Backup your /var/lib/postgres/data folder
- Delete your /var/lib/postgres/data folder and your backup of the data folder on accident
- ?
- Cry
I’m omitting the logs section since I clearly know what the heck I did and what the problem is.
I’m seeking help in finding out what I can recover/save, and how to do it. As mentioned above, I mostly care about my passwords as my latest off site backup is not as up to date as it should be. Next would come my calendar and todo list - I think I’m okay with losing other things beside these three things.
I also should mention that as far as the three app related things I mentioned above - I don’t care if I have to recover these things manually so long as I understand how to do that. If I can get a plaintext version of those things I’ll consider it a win. In other words, if I can rewrite my calendar entries, my todo list, and my passwords all in a .txt, I’m happy.
I’m really in a bind here - my last data directory backup is about a year old and I have concerns as to how helpful it would be.
Edit: I’ve found some automatic password backups which are up to date, but all information is encrypted, of course. How would I go about decrypting the values? If I imported the json into a separate nextcloud instance with the same Nextcloud username and password, would that work? Alternatively, what could I do? I do have a backup of my postgres/data from about a year ago, a postgres 12 version database. I’m thinking this may contain the server secret, based on what I’m reading?
I have yet to find data for the calendar or tasks apps.
Second Edit: It looks like I have something I can try to save the passwords from the automatic backup above, but I’m still unsure about the calendar or tasks apps data.