Postgres error in Nextcloud app with volumes

[ekevu123]

I tried to move my Nextcloud app data to a block storage volume because I ran out of space, however, that failed.

Now I keep getting this error inside the application: Error : Addons Error - Error setting up postgresql. Status code: 500 message: connect ECONNREFUSED 127.0.0.1:5432

I cannot even import the last backup due to the same error.

How can I get access again?

[subven]

What did you move? The whole app directory (including db etc.) or just appdata? Symlinks? More infos please

[ekevu123]

@subven I tried to move the data directory in the storage submenu of the Nextcloud application.

[subven]

@ekevu123 okay so you moved Default - /home/yellowtent/appsdata/9cff92f2-blah-blah-9455-5261ee1fe533 using the Cloudron storage UI.

Have you tried to restore an older Nextcloud backup to a different subdomain? My first guess would be file permission related. I would suggest to stop the app, revert the data directory to its default location (/home/yellowtent/appsdata/ following the original app ID as folder name) and copy over the data that was moved to the volume by hand. Keep an eye on file permissions within the directory. My permissions look like this:

root@my:/home/yellowtent/appsdata/9cff92f2-cf59-4a7e-9455-5261ee1fe533# ls -la
total 44028
drwxr-xr-x   3 yellowtent yellowtent     4096 Aug 19 01:32 .
drwxr-xr-x  27 yellowtent yellowtent     4096 Okt  1 08:46 ..
-rw-r--r--   1 yellowtent yellowtent     5892 Okt  3 02:02 config.json
drwxrwx--- 159 www-data   www-data       4096 Okt  1 03:09 data
-rw-r--r--   1 yellowtent yellowtent 24890717 Okt  3 02:02 dump.rdb
-rw-r--r--   1 root       root          64510 Mai 14 02:07 fsmetadata.json
-rw-r--r--   1 yellowtent yellowtent 20104904 Okt  3 02:02 postgresqldump

[ekevu123]

@subven I do not have all the options you have here, but this is my output:

ls -la
total 12
drwxr-xr-x 3 yellowtent yellowtent 4096 Oct  3 09:41 .
drwxr-xr-x 3 yellowtent yellowtent 4096 Jun 26 11:40 ..
drwxrwx--- 9 www-data   www-data   4096 Sep 11 14:46 data

I cannot reinstall the backup in the same instance because I ran out of space in the disk. Moving the data directory failed, so I cannot revert it either.

My best alternative is to delete the app completely and then set it up again, either through backup or generally new, if I cannot solve this problem here. I was hoping to get access, though, so that I can still make the necessary changes.

[subven]

@ekevu123 you can copy over the missing files from your backup by hand and put them where they belong in the apps root dir ^^ Because you have no config.json etc. app is unable to start. These files should be small as data is the big chunk but be careful to not run out of space!

[ekevu123]

@subven That makes sense, however, I do not have the storage space in that Cloudron instance to do that with a second app, so I'll probably need to delete it and set it up again anyway then. But then re-implementing the backup from scratch might be even more helpful after I will have deleted it already.

[subven]

You don't need a second app. Copy the files your app is missing from your latest backup (without using Cloudrons "restore from backup" function). Take a look at my output. Compare with the files in your backup and the one in your (broken) live app.