Skip to main content

Database Backup

Database backups are a fundamental practice for assuring data integrity of your application.

As the Credo AI application uses postgres, the following is a notional procedure for performing a database backup using standard tooling.

If you are using a managed database solution with snapshot support, we recommend you consider using those features to handle backups and restorations.

With psql and pg_dump​

Log in to your PostgreSQL server:

psql -U <username> -h <hostname> -d <database_name>

Create a backup of your database:

pg_dump -U <username> -h <hostname> -d <database_name> -F c -b -v -f <backup_file_name>.backup