An understanding and sympathetic person people turn to in a pub or bar to talk about their problems.
He got it all sorted after speaking to the pub psychologist.