I upgraded my Mac to OS X Sierra from OS X Yosemite. Since doing this, a piece of software I use (Da Vinci Resolve) no longer shows my database of projects. Da Vinci Resolve support say this about the problem:
"The issue is that PostgreSQL does not work in Sierra. You would need to go back to El Capitan or earlier, and then restore your database."
I have since installed another hard drive and installed the older OS X Yosemite on it. I now require PostgreSQL to be configured so that my old database shows in Da Vinci Resolve.
I have a backup of the 'data' folder from my PostgreSQL database (26.6GB in size).
I will provide access via remote desktop.