RE: Is there a process in Diyotta where I can take a periodic backup of Postgres?
I have a requirement to take the periodic backup of Postgres. so that in case of any PG crashing issues, I can use that backup file to restore the PG.
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