In which Andy proves he really doesn’t know as much about Unix and particularly OS/X as he probably should and certainly wishes!
This is one of my rambling streams of semi-conscious tinkering to get something working. Yes it has actually been edited for brevity but I’m keeping all the weird error messages on here so search engines will help some other poor sod.
At first I thought it was because I was tired but even after a few hours sleep, the following doesn’t make sense:
su -l postgres
Why doesn’t that make sense? Because I don’t know the password to the postgres user because it was added during the installation and I am pretty sure I didn’t supply the password at installation. I don’t know the account and don’t know how to change its password.