Restore from Instance Backup

[calvinalx]

I noticed that we have Instance backup at Settings page, and was able to download Coolify database dump
e.g. pg-dump-coolify-1706522852.dmp

How do we restore this backup to a new Coolify install? I can't find this anywhere on the docs.
Assuming this is just another Postgres container running, is it possible just import it into the database of a new Coolify setup and possibly re-generate all the configs/file?

Thanks!

[TomEbeyer]

Same question - How to restore coolify backup from the .dmp?

[pedrosorrentino]

Another one with the doubt of how to restore the backup. Any idea?

[xyba1337]

@andrasbacsai Any help, please??

[HarleySalas]

I also really need to move my Coolify over to a new VPS. I've so far wasted a day, trying to figure out how to get it to work.

[devdjdjdj]

Coolify runs a postgres db underneath. try this pg_dump

You can find the credentials in your settings http://youip:8000/settings#backup

[enesbala5]

Having created a db dumb, what is the command to import it and overwrite the current configuration.

I understand it probably is pg_restore, however I would really appreciate some help on the exact command. Thank you

[devdjdjdj]

pg_restore -U username -d dbname -1 filename.dump

[enesbala5]

I have managed to run the pg_restore command within the docker container 'coolify-db'. However these are NOT working to update the db successfully, even though the operation is running without issues.
This is the exact chain of commands I am running:

docker exec -it coolify-db 'bash'

-> I uploaded an image to filebin.net and am running:
wget -O db.dmp <download_link>

pg_restore --verbose --clean -h localhost -U coolify -d postgres db.dmp

---

After this step you can see all the fields updating, however no changes in the dashboard.. Don't know where to go from here.
I have tried setting the db to 'coolify-db' as it's displayed on the instance-backup but to no avail. Also password authentication doesn't seem to be required.

[mohammad-malik]

Would love to know the answer to this?

[enesbala5]

@andrasbacsai This would be really helpful - backup and restore is a very important feature of Coolify - and a massive hassle to have to do manually.

[Shreyaan]

https://gist.github.com/Geczy/83c1c77389be94ed4709fc283a0d7e23

something like this will work

[heyJordanParker]

Any updates here?

Even the backup docs page is not working.

[devdjdjdj]

Looks like the astro blog is broken.

You can find the missing docs here - https://github.com/coollabsio/documentation-coolify/blob/main/src/content/docs/knowledge-base/databases/backups.mdx

[hnykda]

Thanks for the hints. I find this pretty bad that coolify doesn't support this officially. I was trying to recover from the autobackup, but was just getting weird 500 errors such as:

Error: The MAC is invalid. (View: /var/www/html/resources/views/livewire/project/resource/index.blade.php)

even when using the same .env file. But there is zero documentation on that aspect (I was really guessing db names etc.).

[renatoaraujoc]

Hello all,

The best case scenario for a complete coolify backup would be:

Backup script:

1. Stop all containers related to coolify and coolify itself
2. Backup everything under /data/coolify religiously
3. Backup every single volume created by coolify and its apps
4. Create a coolify_{{date}}.tar.gz with everything inside

I believe that if you backup the coolify-db's volume, you don't need to mess with pg_dump or pg_restore

Restore script:

1. Take an user input which you'd type the generated backup from the backup script, ie: colify_{{date}}.tar.gz
2. Restore /data/coolify
3. Restore the coolify's ssh
4. Restore all docker volumes
5. Optimally start all apps or not

Obviously there's should be more steps into this.

The backup and restore script could be baked inside the coolify's UI itself, so you back it up from there and on a new server (or even the same server (older state)) you restore from there as well.

The biggest issue here is to separate the concerns on coolify's data itself and the apps' data, it's not an easy solution to bake. If you choose to to back to an old coolify state, what happens to an app that has new data? Lots of stuff has to be thought of.

@andrasbacsai Coolify looks enough mature today, this functionality (imo) is very needed.