Add spec/acceptance test for inherit option to postgresql::server::role