Using Homebrew’s PostgreSQL on Mac OS X

You’re on Mac OS X and you need to use PostgreSQL, but you’re used to GNU/Linux where there is usually a dedicated postgres system user for doing database administrator tasks. This is just a quick note to people who might have installed PostgreSQL from Homebrew and find themselves scratching their head for the next step.