Full Database Backup

[Ola Haldor voll]

Good question – I’m interested as well.

[Michael Cinquin]

open the Terminal and :

* to save the database on your Desktop, with a name of davinci_currentdate.tar
/Library/PostgreSQL/8.4/pgAdmin3.app/Contents/SharedSupport/pg_dump -h localhost -U postgres resolve --blobs -f ~/Desktop/davinci_`date "+%y_%m_%d_%H_%M"`.tar --format=custom --verbose

* to restore the database from an archive (WARNING : current database will be erased)
/Library/PostgreSQL/8.4/pgAdmin3.app/Contents/SharedSupport/pg_restore -h localhost -U postgres --single-transaction --clean --dbname=resolve FULLPATH_OF_THE_ARCHIVE

use at your own risks ! the password that the terminal will ask is that of the PostgreSQL database : DaVinci

I use it here successfully up to now

Michael Cinquin

Final Cut Pro – Avid Media Composer editor
DaVinci – Color – Baselight colorist
http://www.michaelcinquin.com/tools : tools for FCP | Color | RED | subtitles | Cinema Tools | Timecode – Keycode calculator

[Rohit Gupta]

The pgAdmin tool has a nice GUI to backup/restore your databases. This is included with the Resolve install (search in spotlight – pgAdmin).

When backing up, remember to add the .backup extension to the filename, else you will have to rename it in Finder.

When restoring, you will have to create a new database, and restore to that database to avoid over-writing the current database.

Hope this helps!

Regards,
Rohit

[Vladimir Kucherov]

Perfect! Thank you Rohit and Michael.

[Ola Haldor voll]

Hmm where exactly am I supposed to find the file or database to backup? I opened pgAdmin and it says there’s no servers.

Nor do I understand how I can open one.

[Guilherme Ramalho]

Hi Ola,

Did you found out how to do the datadase backup ?

[Ola Haldor voll]

Nope.

[Kevin Cannon]

I’m not 100% sure here, but nobody else seems to be chiming in…

It looks like you open pgadmin, then “add a connection to a server,” you’ll be prompted for a name (perhaps “resolve”) a host, port, username, password (case sensitive)…

Most of which can be found in the login screen>database manager>connect screen.

Then you’ll be connected to your resolve server and can select it and access the “backup” tool, which the documentation says is simply a GUI for the pgdump tool.

It generated a 1 GB file for me, I haven’t confirmed that it worked.