Re: Which specific flags to use for bash client applications for DaVinci Resolve?

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.

pgdump: https://www.postgresql.org/docs/9.5/static/backup-dump.html
vacuumdb: https://www.postgresql.org/docs/9.5/static/app-vacuumdb.html
reindexdb: https://www.postgresql.org/docs/9.5/static/app-reindexdb.html

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(at)gmail(dot)com> 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
> <https://github.com/sethgoldin/backup-resolve-postgresql>, 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 <https://www.postgresql.org/docs/9.5/static/app-pgdump.html>,
> it seems like:
>
> - Creating a database in the DaVinci Resolve GUI corresponds to
> createdb <https://www.postgresql.org/docs/9.5/static/app-createdb.html>;
> and
> - Pressing "Optimize" in the DaVinci Resolve GUI seems to correspond
> to reindexdb
> <https://www.postgresql.org/docs/9.5/static/app-reindexdb.html> and
> vacuumdb <https://www.postgresql.org/docs/9.5/static/app-vacuumdb.html>
> .
>
> 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?
>
> 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!
> -- Seth
> --
> S E T H G O L D I N
>
> Director of Production Technology and Workflow | Freethink
>
> phone: +1.757.739.5424 <(757)%20739-5424>
> web: freethinkmedia.com
> twitter: @sethgoldin
>