EmbeddedPostgres.java

try (EmbeddedPostgreSQL db = EmbeddedPostgreSQL.start()) {
  try (Handle h = DBI.open(db.getPostgresDatabase())) {
    h.execute("CREATE DATABASE breakfast");
    h.execute("CREATE USER brianm with password 'secret'");
    h.execute("grant all privileges on database breakfast to brianm");
  }

  try (Handle h = DBI.open(db.getDatabase("brianm", "breakfast"))) {
    h.execute("create table food (id serial primary key, name text)");
    h.execute("insert into food (name) values ('pancake')");
  }
}

pom.xml

 <dependency>
    <groupId>com.nesscomputing.components</groupId>
    <artifactId>ness-pg-embedded</artifactId>    
    <version>2.5.0</version> <!-- 2.5.X is postgres 9.3 -->
    <scope>test</scope>
</dependency>