I was running into a similar issue, and IF NOT EXISTS seemed to be invalid.

I followed the instructions here instead (dropping the database) and am back up and running.

Description

I just tried to "Move Data" for a Linkding install on Linode, and I got:

Error : Inactive - Error getting IP of postgresql service

Logs

Oct 14 19:14:36 box:taskworker Starting task 359. Logs are at /home/yellowtent/platformdata/logs/xxx-yyy-zzz/apptask.log
Oct 14 19:14:36 box:taskworker Running task of type app
Oct 14 19:14:36 box:apptask run: startTask installationState: pending_data_dir_migration runState: stopped
Oct 14 19:14:36 box:tasks update 359: {"percent":10,"message":"Deleting old containers"}
Oct 14 19:14:36 box:apptask deleteContainer: deleting app containers (app, scheduler)
Oct 14 19:14:36 box:shell apptask /usr/bin/sudo -S /home/yellowtent/box/src/scripts/configurelogrotate.sh remove xxx-yyy-zzz
Oct 14 19:14:36 box:tasks update 359: {"percent":45,"message":"Ensuring app data directory"}
Oct 14 19:14:36 box:tasks update 359: {"percent":50,"message":"Setting up addons"}
Oct 14 19:14:36 box:services setupAddons: Setting up ["localstorage","postgresql","oidc"]
Oct 14 19:14:36 box:services setupAddons: setting up addon localstorage with options {}
Oct 14 19:14:36 box:services setupLocalStorage
Oct 14 19:14:36 box:shell services /usr/bin/sudo -S /home/yellowtent/box/src/scripts/mkdirvolume.sh /home/yellowtent/appsdata/xxx-yyy-zzz/data
Oct 14 19:14:36 box:services Setting up postgresql
Oct 14 19:14:36 box:services setupAddons: setting up addon postgresql with options {}
Oct 14 19:14:36 box:apptask run: app error for state pending_data_dir_migration: BoxError: Error getting IP of postgresql service at getContainerDetails (/home/yellowtent/box/src/services.js:310:20) at process.processTicksAndRejections (node:internal/process/task_queues:95:5) at async Object.setupPostgreSql [as setup] (/home/yellowtent/box/src/services.js:1495:20) at async Object.setupAddons (/home/yellowtent/box/src/services.js:621:9) at async migrateDataDir (/home/yellowtent/box/src/apptask.js:542:5) { reason: 'Inactive', details: {} }
Oct 14 19:14:36 box:tasks setCompleted - 359: {"result":null,"error":{"stack":"BoxError: Error getting IP of postgresql service\n at getContainerDetails (/home/yellowtent/box/src/services.js:310:20)\n at process.processTicksAndRejections (node:internal/process/task_queues:95:5)\n at async Object.setupPostgreSql [as setup] (/home/yellowtent/box/src/services.js:1495:20)\n at async Object.setupAddons (/home/yellowtent/box/src/services.js:621:9)\n at async migrateDataDir (/home/yellowtent/box/src/apptask.js:542:5)","name":"BoxError","reason":"Inactive","details":{},"message":"Error getting IP of postgresql service"}}
Oct 14 19:14:36 box:tasks update 359: {"percent":100,"result":null,"error":{"stack":"BoxError: Error getting IP of postgresql service\n at getContainerDetails (/home/yellowtent/box/src/services.js:310:20)\n at process.processTicksAndRejections (node:internal/process/task_queues:95:5)\n at async Object.setupPostgreSql [as setup] (/home/yellowtent/box/src/services.js:1495:20)\n at async Object.setupAddons (/home/yellowtent/box/src/services.js:621:9)\n at async migrateDataDir (/home/yellowtent/box/src/apptask.js:542:5)","name":"BoxError","reason":"Inactive","details":{},"message":"Error getting IP of postgresql service"}}
Oct 14 19:14:36 box:taskworker Task took 0.155 seconds
Oct 14 19:14:36 BoxError: Error getting IP of postgresql service
Oct 14 19:14:36 BoxError: Error getting IP of postgresql service
Oct 14 19:14:36 BoxError: Error getting IP of postgresql service
Oct 14 19:14:36 BoxError: Error getting IP of postgresql service

Troubleshooting Already Performed

I've tried restarting, re-trying the task. I installed postgresql on my Linode box, even though it's never been needed before.

System Details

Generate Diagnostics Data

Cloudron Version

8.3.2

Ubuntu Version

No LSB modules are available.
Distributor ID:	Ubuntu
Description:	Ubuntu 24.04.2 LTS
Release:	24.04
Codename:	noble

Cloudron installation method

Manual with `./cloudron-setup`

Output of cloudron-support --troubleshoot

Vendor: Linode Product: Compute Instance
Linux: 6.8.0-79-generic
Ubuntu: noble 24.04
Processor: AMD EPYC 7713 64-Core Processor
BIOS pc-q35-7.2  CPU @ 2.0GHz x 1
RAM: 2015320KB
Disk: /dev/sda        7.8G
[OK]	node version is correct
[OK]	IPv6 is enabled and public IPv6 address is working
[OK]	docker is running
[OK]	docker version is correct
[OK]	MySQL is running
[OK]	nginx is running
[OK]	dashboard cert is valid
[OK]	dashboard is reachable via loopback
[OK]	box v8.3.2 is running
[WARN]	netplan configuration is empty. this might be OK depending on your networking setup
[OK]	DNS is resolving via systemd-resolved
[OK]	Dashboard is reachable via domain name
[WARN]	Domain example.com expiry check skipped because whois does not have this information
[OK]	unbound is running