Need to write a bash script to automate the process of creating a backup of database and the media files, and then use the Google Drive APIs to push to one of the folders. Currently, we plan to register it as a corn job, and will execute this script every 3 hours.
Bonus
A smart way of organizing these backups in google drive will be great. One of the ways could be to group all backups weekly to one folder.
@23yashm this was the issue I was talking about. Have a look at pg_dump! All you need to do is get into the container, generate a backup and bring it back to the host machine. (look for other alternatives too).
Need to write a bash script to automate the process of creating a backup of
database
and themedia
files, and then use the Google Drive APIs to push to one of the folders. Currently, we plan to register it as a corn job, and will execute this script every 3 hours.Bonus A smart way of organizing these backups in google drive will be great. One of the ways could be to group all backups weekly to one folder.