Solution to asset server not working anymore after upgrading to Lion

I upgraded to Lion to use Unity with my newly upgraded to 5.1 iPhone 4S and my asset server stopped working. I could not even access the asset server from command line. After a couple weeks of trying to fix this problem I figured out what was going on.

It turns out that when you upgrade to Lion, the user for Unity asset server PostgreSQL database was turned into a Mac user. I was able to access the asset server while logged in with this new user. I couldn't connect from Unity, but I could run an export of my projects from command line. Then I had to completely erase and reinstall my Mac and upgrade to Lion and then install the asset server and import the projects and it worked fine from there.

Hopefully, this is helpful to someone else who runs into the same problem.