search

sethgoldin / davinci-resolve-postgresql-workflow-tools

Effortlessly set up automatic backups and automatic optimizations of DaVinci Resolve Studio's PostgreSQL databases
Other
80 stars 11 forks source link

Back up zero byte #21

Closed BPouet closed 4 years ago

BPouet commented 4 years ago

I have install the script on 2 different servers.

One is working perfectly fine ( Mac osx with davinci 15) The other only create zero byte backup. ( Mac osx davinci 16)

I can't find the reason why. The password and db is ok. I check .pgpass I add the "TRUST" in .conf

is there also a way to backup multiple database?

Cheers!

-BP

sethgoldin commented 4 years ago

Make sure that pg_hba.conf has the correct static IP address for the machine. I've seen several different users enter the incorrect IP address there, which caused the script to spit out zero-byte .backup files.

You can indeed run the script for different databases on the same system. Just run it as many times as you need.

BPouet commented 4 years ago

Thanks for the quick tip!