I am new with PostgreSQL, So my question is: what is the easiest way to make regular backups and send them to Google Drive. Perhaps, there is a tool that can make it or something else.
Postgresql – the easiest way to backup PostgreSQL and send backups to Google Drive
backuppostgresql
Related Question
- Postgresql database backup (and restore) from two servers to third storage place
- Sql-server – Alternative for taking the backup of SQL DB’s on backup drive
- PostgreSQL / pgAdminIII: is it possible to send command line commands via the UI
- Postgresql – How to setup vault and Postgres in Google cloud to have the correct permissions
- Postgresql – reason I should not set the default data location to google drive when setting up PostgreSQL
- Postgresql – How to store and work from a Postgresql database on an external hard drive
Best Answer
You could try:
https://github.com/andreafabrizi/Dropbox-Uploader
to send your pg_dump output to Dropbox. I got this by Googling script load file dropbox. You may find some of the other scripts more to your liking.
Remember the dba's motto - backup or f*ckup and test, test and test again. Personally, I would recommend a local (speed of recovery) and remote (double-sure) copy (as the Americans say, "belt and suspenders").
It is a bash tool, but then I always assume
PostgreSQL
ers are on a decent operating system :-).Update - the bash shell can now be used natively on Windows as well since Microsoft appear to be doing more embracing and less smothering of *nix tools!