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.

JohnGS Advanced User Asked on July 21, 2020 in Architecture.
Add Comment
1 Answers

Yes there is an option to take periodic backup of the Postgres metadata using the below option

  1. Login to the putty using the diyotta user.
  2. Traverse to the path [ diyotta/controller/bin].
  3. 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

Expert Answered on July 28, 2020.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.