The schema for the "dialect" attribute accepts the string "org.apache.lucene.store.jdbc.dialect.PostgresDialect", but the actual Compass class name is "org.apache.lucene.store.jdbc.dialect.PostgreSQLDialect".
The workaround is to use the "dialectClass" attribute instead.