Is there a process in Diyotta where I can take a periodic backup of Postgres?
Yes there is an option to take periodic backup of the Postgres metadata using the below option
- Login to the putty using the diyotta user.
- Traverse to the path [ diyotta/controller/bin].
- Then try to run the script ./pgbackup.sh
This script would generate a backup of the existing metadata with a timestamp appended to the backup file name. These backup files are present at this particular location [ /diyotta/controller/backups]
Note: If we are taking a weekly backup, try to delete the older backups which are already present in the folder. So that would extricate some space