title: Fresh PG install on Ubuntu
body: <p>I am setting up a Digital Ocean Ubuntu server to host my new site on and having trouble setting up postgres.</p>
  
  <p>I installed it fine but when I try to access it using <code>psql</code> I get:</p>
  
  <blockquote>
    <p>psql: FATAL:  role "demo" does not exist</p>
  </blockquote>
  
  <p>A few quick questions:</p>
  
  <ol>
  <li><p>Has installing postgres create an standard ubuntu user account?</p></li>
  <li><p>How do I create a new postgres account, I have tried <code>createuser</code> but get the following:</p>
  
  <p>demo@dubbo:~$ createuser
  Enter name of role to add: demopg
  Shall the new role be a superuser? (y/n) y
  createuser: could not connect to database postgres: FATAL:  role "demo" does not exist</p></li>
  </ol>
  
  <p>I guess that once I have a postgres user I should then be able to create a db for my application to use.</p>