title: Postgresql Multiple Database VS Multiple Schemas
body: <p>We are in the process of building a cluster for our hosted services at work, the final product will be used to host multiple separate services. We are in the middle of deciding on how we want to setup our databases. We are running a postgresql database server which all services in the cluster will use. The debate right now is whether to give each service its own schema in a single database or to give each service its own database.</p>
  
  <p>We just aren't sure which is the better solution for us. None of our services have a common structure and data does not need to be shared. What we are more concerned about is ease of use.</p>
  
  <p>Here's what we care most about, we are really hoping for an objective vs opinion based answer.</p>
  
  <p>Backups</p>
  
  <p>Disaster recovery - all services vs individual</p>
  
  <p>Security between services</p>
  
  <p>Performance</p>
  
  <p>For some additional information, the cluster is hosted within AWS with our database being an RDS instance. </p>