The JPA annotation says that there should be a database sequence called roles_id_seq which is the one PostgreSQL creates behind the scenes for the IDENTITY column.

Now, if you get that exception it could be because the schema is not found Schema validation, so we need to investigate why is it so. It could also be a problem with the PostgreSQL JDBC Driver too, but we need to investigate it.