Jathavan Sriram wrote a great article back in 2014 about how to use pgAdmin III tools in bash, instead of having to use the psql shell. PostgreSQL 9.5.4 or later (as provided by the DaVinci Resolve Studio installer).This script has been tested and works for PostgreSQL servers for: To verify that everything is in working order, you can periodically check the log files located in /usr/local/DaVinci-Resolve-PostgreSQL-Workflow-Tools/logs. It's neither necessary nor desirable to run the script more than once per individual Resolve database. The script creates systemd units and timers, so these automatic backups and automatic database optimizations will continue on schedule, even after the system is rebooted.
Prompt you for how often you want to optimize the database.Be sure to use systemd notation like 1h or 3h or 1d, etc.Prompt you for how often you want to back the database up and.In Terminal, from within your ~/Downloads/davinci-resolve-postgresql-workflow-tools-master folder, execute the script:.From an admin user account, download the repository davinci-resolve-postgresql-workflow-tools-master to your ~/Downloads folder.For more information, see Scripting OS X. The scripts do not use any incompatible word splitting or array indices, so the scripts should be easily converted to native zsh in future releases of macOS. However, these scripts' shebangs still specify the use of bash, which is still included in Catalina. Starting in macOS Catalina, the default shell is zsh. To verify that everything is in working order, you can periodically check the log files located in ~/DaVinci-Resolve-PostgreSQL-Workflow-Tools/logs. The script creates macOS launchd user agents, so these automatic backups and automatic database optimizations will continue on schedule, even after the system is rebooted. Once you run through this script, you will be automatically backing up and optimizing your database according to whatever parameters you entered. Prompt you for how often you want to optimize the database, in seconds.Prompt you for how often you want to back the database up, in seconds and.Prompt you for the path of the folder where your backups will go.Prompt you for the name of your PostgreSQL database.% ~/Downloads/davinci-resolve-postgresql-workflow-tools-master/macos-install.sh
0 kommentar(er)
