mvandenbeuken

package :postgres_user do
  runner %{echo "CREATE ROLE #{DEPLOY_USER} WITH LOGIN ENCRYPTED PASSWORD '#{DEPLOY_POSTGRES_PASSWORD}';" | sudo -u postgres psql}
  
  verify do
    @commands << "echo 'SELECT ROLNAME FROM PG_ROLES' | sudo -u postgres psql | grep #{DEPLOY_USER}"
  end
end

package :postgres_database do
  runner "sudo -u postgres createdb --owner=#{DEPLOY_USER} #{DB_NAME}"