Problems restoring PostgreSQL database

Hi,

I've created a brand new installation of macOS Big Sur on a fresh partition, from scratch rather than upgrading*. I install Resolve 17.1 and try and restore my PostgreSQL databases, naming them as they were before, but it comes up with an error message, saying that databases with the same names already exist. How is this possible? I then try and connect to the alleged existing database at the same address that they were on before, and now it tells me there's nothing to connect to. What's going on? I've tried using pgAdmin 4, but it isn't showing that there are existing databases, not that I know how to use it. I've also tried uninstalling and reinstalling Resolve. Where are PostgreSQL databases stored anyway? I don't want to be creating duplicate databases with slightly different names cluttering up my system.

On a side note, I've installed Desktop Video 12.0, but it isn't seeing my UltraStudio 4K mini connected via thunderbolt 3. Have restarted, tried a cold boot, tried uninstall/reinstall, nothing. Will try 11.7 tomorrow.

Big Sur 11.2.3

* FYI the disk container that my Mojave Resolve partition was on, was deleted

Will try 11.7 tomorrow.

Couldn't wait that long

11.7 worked, the difference being that during installation it actually pointed out to me that an extension was being blocked by OS Security & Privacy settings, which the 12.0 installer did not. Sorted it out for 11.7, then when I saw that worked, I installed 12.0, and that works fine too now, so it's just a matter of making sure the 12.0 installer flags this problem.

Update: I tried creating a new test PostgreSQL database and that didn't work either. So I installed 16.2.8, same thing, comes up with this error message:

PostgresQL connection error.png (190.8 KiB) Viewed 607 times

Did some digging and found this thread, which suggested that Postgres wasn't installed. So I look in the Resolve 17 installer under Customise; nothing there. Do the same check in the Resolve 16 installer, this one does list PostgreSQL, but the option isn't ticked, as if it is already installed on my machine. I tick the option anyway, and now I can see databases pop up in pgAdmin 4.

So I try my luck with Resolve 17 again, and try to connect to my "existing" Postgres database. There's an error, so I check the log, and finally it admits that this database doesn't exist, unlike what Resolve had told me yesterday! I restore it from my backup, and everything now seems to be working.

I had thought about installing the Resolve 17 Project Server earlier on in this process, but on the Support page it makes no mention of being needed in order to use PostgreSQL databases (and neither does the New Features manual), just about adding "support for multiple users on different workstations to open and work on the same project at the same time." Since I am the only one who will use these projects, I thought I would be ok.

But is this the reason I couldn't restore this database sooner, would it have installed Postgres on my system? And now that I have Postgres working through the v16 installer, do I need to upgrade Project Server to the 17.1 version for any reason?

Edit: after reinstalling Big Sur for an unrelated problem, I just went straight to installing the Project Server 17.1 with Resolve 17.1, and was able to restore and connect to Postgres databases just fine.