Delete PostgreSQL databases from Davinci Resolve on Mac

Want to delete a databases from DaVinci Resolve? This video editor provides users the left sidebar to manage its databases. We can create new databases, backup and restore databases from this database left sidebar. However there is no option to remove or delete a database from there. You can only disconnect databases in DaVinci Resolve so they don’t appear in the Database list. However, disconnected databases can still be reconnected if you remember their name. It is because the disconnected databases are still saved on your computer.

For the disk databases, you can locate them in your file system via Finder on Mac or File Explorer on Windows PC. You can’t find the PostgreSQL databases in the same way. The only way to completely delete a PostgreSQL database is to do so from the command line, or to use the PGAdmin application that accompanies the PostgreSQL installation. If you have selected to install PostgreSQL server during the DaVinci Resolve installation process, the database management tool, pgAmdin, will also be installed. In this quick guide, we will show you how to delete PostgreSQL databases from Davinci Resolve using pgAdmin on Mac.

Search “pgAdmin” on Mac, you will find the pgAdmin3.app. If you try to run this database management tool on your Mac, you may get the “update required” warning as below.

pgadmin3 app not compatible with Mac OS

“pgAdmin3.app” needs to be updated.
The developer of this app needs to update it to work with this version of macOS. Contact the developer for more information.

It is because pgAdmin3 is a 32-bit app. Starting with macOS Catalina, 32-bit apps are no longer compatible with macOS. You will have to download pgAdmin 4 instead.

pgAdmin 4 is a complete rewrite of pgAdmin and it works well with the latest version of macOS. What’s more, the pgAdmin 4 appbundle contains both the pgAdmin 4 Desktop Runtime and Web application. You can now use its web interface to manage PostgreSQL databases on Mac. It is very user-friendly. You can download pgAdmin 4 for Mac from its official website here.

To install pgAdmin 4 on Mac, double click to mount the disk image from the Finder, then drag the pgAdmin 4 appbundle to the desired location, such as the Applications folder.

Launch pgAdmin 4 app on Mac, you will see a warning telling you this is an app downloaded from the internet. Click Open to start the program. After that pgAdmin opens in your Safari browser. And you will be required to set master password first. This will be used to secure and later unlock saved passwords and other credentials in the database management program. After that, it will ask you to input the password to connect to your DaVinci Resolve database server. When you create a new PostgreSQL database in DaVinci Resolve, the default username and password would be postgres and DaVinci. Type in your database password here and click OK button to connect the database server. After the authentication, you will be connected to the DaVinci Resolve database server and all PostgreSQL databases will be listed.

Delete, drop databases from PostgreSQL server using pgAdmin on Mac

To completely remove a PostgreSQL database from your computer, right-click the database that is listed in pgAdmin, and choose Delete/Drop from the contextual menu. A dialog appears to confirm if you really want to drop that database. Click OK to complete remove the database from your computer.

Note that if you are using this database in DaVinci Resolve, you have to quit the project first. Otherwise you won’t be able to drop the database in pgAdmin. You can only remove a database which is not currently being used.

Leave a Comment

Your email address will not be published. Required fields are marked *