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

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
web: freethinkmedia.com
twitter: @sethgoldin