coollabsio / coolify

An open-source & self-hostable Heroku / Netlify / Vercel alternative.
https://coolify.io
Apache License 2.0
34.62k stars 1.89k forks source link

[Bug]: Directus + PostgreSQL database backups don't work #4347

Open unknownterritory opened 1 day ago

unknownterritory commented 1 day ago

Error Message and Logs

There's nothing in the Executions list and nothing related to backups in the PostgreSQL logs. It seems like the backups are not triggered at all.

Steps to Reproduce

  1. Fresh install Coolify.
  2. Create a Directus with Postgresql resource
  3. Add a scheduled backup for the Postgresql database, either local or to a working S3 bucket elsewhere. Save.
  4. Click on "Backup Now" for good measure.

Example Repository URL

No response

Coolify Version

v4.0.0-beta.370

Are you using Coolify Cloud?

No (self-hosted)

Operating System and Version (self-hosted)

Ubuntu 24.04.1 LTS

Additional Information

Fresh installation of Coolify. Backups of Coolify itself to an object storage bucket on Scaleway are working just fine. Have two instances of Directus, both with PostgreSQL databases, on the same Hetzner server where Coolify is installed. Both instances are running fine and healthy. I've tried to set up backups for the databases (Postgresql (postgis/postgis:16-3.4-alpine)), both S3 enabled and local backups.

All the backups fail, both the scheduled and the on-demand backups (by pressing Backup Now). Stranger still is that nothing actually happens. No backup related logs or records in the Executions list.

DMdeveloppement commented 1 day ago

Same here. Fresh install + directus with postgres

No backup now, no scheduler and no result

But if I deploy a simple postgres db, backups are ok. Coolify backups work too.

DMdeveloppement commented 1 day ago

Just tested that the same issue append on Coolify CLoud

DMdeveloppement commented 1 day ago

It's maybe on postgis side. When i switch to a directus + postgres (without postgis) backups are working as expected