Resolve 9-Cannot create new database

On some machines we've seen the database installation fail, and this causes the database to not start up properly.

A fix for this requires a few command for you to type on the terminal. This will uninstall the database, so the next install of Resolve will install it properly.

Before you run these it's important to make sure you don't have any data or resolve projects saved in your postgres database.

1) Stop the server
sudo /sbin/SystemStarter stop postgresql-8.4
2) Remove menu shortcuts:
sudo rm -rf /Applications/PostgreSQL 8.4
3) Remove the ini file
sudo rm -rf /etc/postgres-reg.ini
4) Removing Startup Items
sudo rm -rf /Library/StartupItems/postgresql-8.4
5) Remove the data and installed files
sudo rm -rf /Library/PostgreSQL/8.4
6) Delete the user postgres
sudo dscl . delete /users/postgres

Now, re-install Resolve, reboot, and then start Resolve.

Hope this helps!

Worked for me too! Thanks!

Andy Sapp
http://www.andysapp.com