title: Getting Postgresql Running In Mac: Database "postgres" does not exist
body: <p>I followed these instructions to get postgresql running on mac. Note that I am using Homebrew to install, and the current version installable through brew is 9.2.1, so I changed the version numbers in the instructions here: <a href="http://rails3hub.blogspot.com/2012/02/install-postgresql-9-on-os-x.html" rel="noreferrer">http://rails3hub.blogspot.com/2012/02/install-postgresql-9-on-os-x.html</a></p>
  
  <p>Everything went swimmingly, but I can't get into psql to create dbs and whatnot. if I try <code>psql</code> i get <code>psql: FATAL:  database "myusername" does not exist</code></p>
  
  <p>if i try <code>psql -U root</code> i get <code>psql: FATAL:  role "postgres" does not exist</code></p>
  
  <p>if i try to follow the instruction in the blog to use pgAdmin as my postgres console, eg <code>psql -d postgres &lt; /usr/local/Cellar/postgresql/9.2.1/share/postgresql/extension/adminpack--1.0.sql</code> i get the same role "postgres" does not exist error.</p>
  
  <p>I have no clue how to get this up and running, I simply want to get into psql just as I would mysql -U root, create a db, and get started with a site.</p>
  
  <p>Anybody have any advice? I can post more information, and I'm on Mac OSX fyi.</p>