{"id":857,"date":"2017-03-07T16:57:23","date_gmt":"2017-03-08T00:57:23","guid":{"rendered":"http:\/\/www.hdhead.com\/?p=857"},"modified":"2018-11-08T21:56:59","modified_gmt":"2018-11-09T05:56:59","slug":"resolve-database-backup","status":"publish","type":"post","link":"https:\/\/www.hdhead.com\/?p=857","title":{"rendered":"Resolve Database Backup"},"content":{"rendered":"<p>This Python script dumps one DaVinci Resolve\u00a0Postgres database at a time and saves it in the current user\u2019s Documents directory twice a day. The interval is set inside the script itself. The script does not require OS level scheduling.<\/p>\n<p>User controls available inside the script:<\/p>\n<ul>\n<li>Backup\u00a0interval<\/li>\n<li>Days to keep old backups<\/li>\n<li>Database name<\/li>\n<li>Database login information<\/li>\n<li>Postgres version number<\/li>\n<\/ul>\n<p>It is important to set the correct Postgres version for the script to run.<\/p>\n<p>Usage is the same in Windows and OS X. Execute the script at any time, or add it to the startup programs for automatic start. In Windows you can rename the extension to .pyw to suppress the console window.<\/p>\n<p>Python 2.7 in required in Windows. OS X already comes with Python, but you need to associate the .py extension with the Python Launcher if you want to execute the script by double clicking. The script currently does not support the Linux version of Resolve.<\/p>\n<p><a href=\"http:\/\/www.hdhead.com\/wp-content\/uploads\/scripts\/pgrbackup.py\"><strong>Download pgrbackup.py.<\/strong><\/a><\/p>\n<p>GitHub:\u00a0<a href=\"https:\/\/github.com\/IgorRidanovic\/Resolve-backup-Postgres\">https:\/\/github.com\/IgorRidanovic\/Resolve-backup-Postgres<\/a><\/p>\n<p>If you are running Resolve Disc Database instead of Postgres database <a href=\"http:\/\/www.hdhead.com\/?p=841\">use this backup tool.<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>This Python script dumps one DaVinci Resolve\u00a0Postgres database at a time and saves it in the current user\u2019s Documents directory twice a day. The interval is set inside the script itself. The script does not require OS level scheduling. User controls available inside the script: Backup\u00a0interval Days to keep old backups Database name Database login &hellip; <a href=\"https:\/\/www.hdhead.com\/?p=857\" class=\"more-link\">Continue reading <span class=\"screen-reader-text\">Resolve Database Backup<\/span> <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":860,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[8],"tags":[],"class_list":["post-857","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-tools"],"_links":{"self":[{"href":"https:\/\/www.hdhead.com\/index.php?rest_route=\/wp\/v2\/posts\/857","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.hdhead.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.hdhead.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.hdhead.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.hdhead.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=857"}],"version-history":[{"count":7,"href":"https:\/\/www.hdhead.com\/index.php?rest_route=\/wp\/v2\/posts\/857\/revisions"}],"predecessor-version":[{"id":880,"href":"https:\/\/www.hdhead.com\/index.php?rest_route=\/wp\/v2\/posts\/857\/revisions\/880"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.hdhead.com\/index.php?rest_route=\/wp\/v2\/media\/860"}],"wp:attachment":[{"href":"https:\/\/www.hdhead.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=857"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.hdhead.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=857"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.hdhead.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=857"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}