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:
- 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" 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
