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

Thanks, Steve.

Yes, Blackmagic Design changed the pricing last year, and now ship a free
Linux version.

On Windows and Mac, it uses a "disk" database by default, which is a
special configuration of files and folders on the boot drive.

However, on Windows, Mac, and Linux, a PostgreSQL database can be
configured on a local network, for more advanced features, like having
different users on different workstations collaborating in the same
project, or sending different render jobs to different workstations.

The Resolve manual doesn't have any mention of automating the PostgreSQL
functions--the ./pg_dump script I mentioned earlier was just from someone
who was familiar with PostgreSQL administration.

I don't know what special flags to use in the bash commands, which is why I
came here.

I'm using DaVinci Resolve Studio 14.2.1.007 on macOS Sierra 10.12.6 with
PostgreSQL 9.5.9.

Thanks,
-- Seth.

On Mon, Jan 29, 2018 at 11:12 AM Steve Crawford <
scrawford(at)pinpointresearch(dot)com> wrote:

> 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
>>
> --
S E T H G O L D I N
Director of Production Technology and Workflow | Freethink

web: freethink.com <http://www.freethink.com>
twitter: @sethgoldin