patternsqlMinor
What is the easiest way to backup PostgreSQL and send backups to Google Drive?
Viewed 0 times
postgresqleasiestthebackupsgooglewhatwayandsenddrive
Problem
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.
Solution
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
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!
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
PostgreSQLers 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!
Context
StackExchange Database Administrators Q#138773, answer score: 3
Revisions (0)
No revisions yet.