title: rds_superuser role in postgres RDS server
body: <p>I just created a new postgres RDS instace on aws (through the dashboard), and I gave it a default user, lets call him "jack".</p>
  
  <p>When I logged in to the instance, I saw my created user "jack", and that he had a role "<strong>rds_superuser</strong>" attached. (so I thought that I can do the same things that I used to do with superuser on a regular postgres server).</p>
  
  <p>I checked the <a href="https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/Appendix.PostgreSQL.CommonDBATasks.html" rel="noreferrer">documentation</a>, I saw that wasn't possible.</p>
  
  <p>As logged in as the default user "stan", I created a new database user like "stan", and wanted to create a new databases with the owner being the user "stan", I couldn't?</p>
  
  <p>I entered something like this:</p>
  
  <pre><code>CREATE DATABASE foobar WITH OWNER = stan;
  </code></pre>
  
  <p>But I got an error, saying something like:</p>
  
  <p><strong>ERROR:  must be member of role "stan"</strong></p>
  
  <p>So, what I did was, made the role "stan", logged out as the default user "jack", logged into the RDS instance as "stan", and created that database with him as the owner.</p>
  
  <p>Since I had three different users, I had to repeat that last step <strong>three times.</strong></p>
  
  <p>My question, is there a way, that I can make the default user "jack" that I created during RDS postgres creation, capable of creating new databases (like superuser on a regular postgres server installation) and giving the different owners like this:</p>
  
  <pre><code>CREATE DATABASE foobar WITH OWNER = stan;
  </code></pre>
  
  <p>Tnx,
  Tom</p>