Create postgres users and databases from Chef

db_server.rb

include_recipe "postgresql::server90"

# inspiration from 
# https://gist.github.com/637579

execute "create-root-user" do
    code = <<-EOH
    psql -U postgres -c "select * from pg_user where usename='root'" | grep -c root
    EOH
    command "createuser -U postgres -s root"
    not_if code 
end

execute "create-database-user" do
    code = <<-EOH
    psql -U postgres -c "select * from pg_user where usename='#{node[:dbuser]}'" | grep -c #{node[:dbuser]}
    EOH
    command "createuser -U postgres -sw #{node[:dbuser]}"
    not_if code 
end


execute "create-database" do
    exists = <<-EOH
    psql -U postgres -c "select * from pg_database WHERE datname='#{node[:dbname]}'" | grep -c #{node[:dbname]}
    EOH
    command "createdb -U postgres -O #{node[:dbuser]} -E utf8 -T template0 #{node[:dbname]}"
    not_if exists
end
    


# content in node.json
#{ 
#  "postgresql" : {
#        "version": 9.0, 
#        "dir": "/etc/postgresql/9.0/main"
#  },
#  "dbuser": "user",
#  "dbname": "db"
#}

database_user in https://github.com/opscode-cookbooks/database also seems to accomplish this... (posting here since it was the first google result)

I'm just now coming from this cookbook: Looks good in theory, but has a lot of unnecessary dependencies on other cookbooks like mysql, aws, xfs - I'd rather use something more focused on dealing with postgres...

The database cookbook is also very awkward to reliably reset a postgresql password with.

Only r.entries[0]['count'] == '0' worked out for me