chirale

IT and beyond

3-2-1 backup is not a timer to backup. It’s a well covered backup strategy to avoid data loss storing 3 copies of valuable data in different places. At least 3 backups, 2 of which are locally stored in different devices, and 1 is stored externally, for example a cloud storage service. Here’s a recipe of …

Continue reading

In this howto I will show how to backup all PostgreSQL databases, roles and permission on a server and restore them on another server on a docker. 1. Backup databases on origin server To backup all PostgreSQL databases automatically, preserving roles and permission, you can create this cron.d script (this example is from a CentOS): …

Continue reading