Backup Postgresql Database

Get answers to your questions about color grading, editing and finishing with DaVinci Resolve.
  • Author
  • Message
Offline

Nikolas_92

  • Posts: 2
  • Joined: Fri Apr 23, 2021 5:26 pm
  • Real Name: Nicolas chollet

Backup Postgresql Database

PostFri Apr 23, 2021 5:36 pm

Hi everyone

I'm trying to setup a postgresql database with Resolve.
Everything is good but I want a secure backup of the DB.
My server is on a Mac Mini and I save my DB every night with a pg_dump command.

Can I run the pg_dump command multiple time a day, like every 30 minutes, to assure not to loose top much data ?

I there a better way ?
Offline

peterjackson

  • Posts: 1144
  • Joined: Sat Aug 18, 2018 7:12 pm
  • Real Name: Peter Jackson

Re: Backup Postgresql Database

PostFri Apr 23, 2021 7:36 pm

Yes, use Point In Time Recovery (PITR) and/or log streaming to a second PostgreSQL node.
5950x, 3090, 128GB.
Offline

Nikolas_92

  • Posts: 2
  • Joined: Fri Apr 23, 2021 5:26 pm
  • Real Name: Nicolas chollet

Re: Backup Postgresql Database

PostFri Apr 23, 2021 8:15 pm

Thanks,
I tried PITR with PgBarmen but I just don't know how to configure it with my BDD on Osx :/
All the help I've seen is for BDD on Linux and serveur backup also on Linux

Return to DaVinci Resolve

Who is online

Users browsing this forum: Bing [Bot], panos_mts, raynardwilson, xunile and 204 guests