Backups

Scheduled database backups can be configured for Databases and for the Coolify PostgreSQL database itself.

These schedules are based on cron expressions, so you can configure them to run as often as you want. For more information about cron expressions, see our cron syntax documentation.

PostgreSQL

Coolify creates a full backup of your PostgreSQL databases. You can specify which database to backup, with a comma separated list.

Tip

Coolify’s own database is also backed up using this method.

Backup command

pg_dump --format=custom --no-acl --no-owner --username <username> <databaseName>

Restore command

The backup has custom format, so you can restore it using the following command (or with any equivalent tool):

pg_restore --verbose --clean -h localhost -U postgres -d postgres pg-dump-postgres-1697207547.dmp

MySQL

mysqldump -u root -p <password> <datatabaseName>

MariaDB

mariadb-dump -u root -p <password> <datatabaseName>

MongoDB

mongodump --authenticationDatabase=admin --uri=<uri> --gzip --archive=<archive>

Or if you exclude some collections:

mongodump --authenticationDatabase=admin --uri=<uri> --gzip --archive=<archive> --excludeCollection=<collectionName> --excludeCollection=<collectionName>

S3 Backups

You can also define your own S3 compatible storage to store your backups.