Interesting. I was unaware that Resolve used PostgreSQL. I looked at Resolve a year or two ago but the Linux version was still pricey while the basic Mac/Windows versions could be downloaded for free. Looks like there may be a free version for Linux, now. I'll have to check it out.
In any case, you may find the answers in online documentation.
Note that a properly configured PostgreSQL database may require little or no manual vacuum as the autovacuum process will handle things well most of the time.
From poking around on the forums it appears that newer versions of Davinci Resolve don't install the database by default. I'm not sure if it is an option necessary for some features or if they have changed from using PostgreSQL for internal data.
If the manuals don't get you far enough and you have more questions please be sure to include the versions of Resolve and your OS in your question.
Cheers,
Steve
On Mon, Jan 29, 2018 at 7:46 AM Seth Goldin <sethgoldin@xxxxxxxxx> wrote:
Hello all,--
I apologize if this is off-topic for this specific mailing list--if it is, let me know, and I can post it to the right spot instead.
I'm a complete newbie with PostgreSQL, or any kind of database language for that matter, but I'm trying to figure out how I might automate some workflows.
I'm using a video post-production application called Blackmagic DaVinci Resolve. It relies on PostgreSQL 9.5, but because its GUI is rather limited, I created a bash script and launchd agent for ./pg_dump, so that I could backup databases automatically.
The bash script was based on a blog post from someone who had intimate knowledge of PostgreSQL.
Using ./pg_dump for backups is great, and it exactly corresponds to pressing DaVinci Resolve's "Backup" button in its GUI.
So, I'd love to automate a few more functions.
Whereas pressing "Backup" in the DaVinci Resolve GUI seems to correspond to pg_dump, it seems like:My issue is that I don't know what flags to use. Can any PostgreSQL gurus inform me what flags I should include and omit?
- Creating a database in the DaVinci Resolve GUI corresponds to createdb; and
- Pressing "Optimize" in the DaVinci Resolve GUI seems to correspond to reindexdb and vacuumdb.
I've already tried monkeying around in `postgresql.conf`, increasing the logging level, hitting some GUI buttons and staring at `ps -ef` to try to get a sense of how I might be able to run bash client applications, but I was just left scratching my head.
The ultimate goal here is to come up with one simple little program to create a proper database and immediately load "Optimize" and "Backup" bash scripts right into launchd in one fell swoop.
Can anyone help me out by figuring out exactly what the right bash commands would be for createdb, reindexdb, and vacuumdb? Maybe someone could examine `ps -ef` while pressing the GUI buttons and inform what the equivalent bash commands would be?
Thanks in advance!
-- SethS E T H G O L D I NDirector of Production Technology and Workflow | Freethinkphone: +1.757.739.5424web: freethinkmedia.comtwitter: @sethgoldin
