cancel
Showing results for 
Search instead for 
Did you mean: 

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

Adventurer

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

Hello all,

 

I apologize if this is off-topic for this specific forum--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 tried reaching out to EnterpriseDB directly to see if I could get some kind of one-off support ticket, but that isn't really possible, and they suggested I post here for some help.

 

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:

  • 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.

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" 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.
5 REPLIES 5
Moderator

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

It would not be possible, without analysis, to give any suggestions which might work right in your environment, infact, the same suggestions might not work after some time in the same environment. So it would be great if you can devote some time understanding the concepts and helping yourself. Here are a few links which you can refer to for the flags that you would want to set:: https://www.postgresql.org/docs/9.0/static/sql-createdatabase.html https://www.postgresql.org/docs/9.5/static/sql-vacuum.html https://www.postgresql.org/docs/9.5/static/sql-reindex.html Since these contain only infomration and not when to use, you can start by going through maintenance blogs by Robert (http://rhaas.blogspot.in) and Raghavendra (http://raghavt.blogspot.in). If you do run into specific issues while trying to implement, you are most welcome to post the errors and questions here and we willl try to help you. Cheers, Amit
Adventurer

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

I do not have the time to learn about this in-depth right now. Are any users here willing to do a one-off consultation for a fee? DM me, please.

Community Manager

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

Hi Seth,

 

Welcome to PostgresRocks!  

Thank you for bringing your questions and comments to this platform. We are excited to have you as a member of this community.

 

In response to your recent post, would you be interested in speaking with EDB regarding a limited engagement to help solve this current concern?  If so, please let me know and I can have an EDB team member contact you for further conversation. 

 

Lori

 

 

 

Adventurer

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

Lori,

 

That would be amazing--I spoke with someone by phone already, and they weren't quite sure how to do this without a recurring subscription. They just told me to post my question here. If we can actually work something out, that would be great!

 

Thanks!

Seth

Community Manager

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

Hi Seth,

 

Happy to discuss this more.

I am taking this offline and will continue our conversation via the Private Message feature. 

 

Lori