Creating a postgis template database in chef

chef.log

[Mon, 15 Oct 2012 22:45:22 +0000] DEBUG: Processing execute[create-postgis-template-db] on vagrant.vm
[Mon, 15 Oct 2012 22:45:22 +0000] INFO: Processing execute[create-postgis-template-db] action run (postgis::server line 25)
[Mon, 15 Oct 2012 22:45:22 +0000] DEBUG: Skipping execute[create-postgis-template-db] due to not_if command `        PGPASSWORD=R3n41rAfFMQzoOghaAYV psql -d postgis -U postgres >/dev/null 2&>1
`

gistfile1.rb

POSTGRES_CREDS = {
    'PGPASSWORD' => Chef::Config[:solo] ? 
        File.read('/etc/postgresql/9.1/main/.org_grok').strip 
        : node[:postgresql][:password],
    'PGUSER' => 'postgres',
}

#ideally, this would be done using the database cookbook. Unfortunately, that's
#broken on an omnibus install. Which of course, is what we use.
execute 'create-postgis-template-db' do
    environment POSTGRES_CREDS
    
    command <<-EOC
        createdb postgis
        createlang plpgsql postgis
        psql -d postgis -f /usr/share/postgresql-9.1/contrib/postgis-1.5/postgis.sql
        psql -d postgis -f /usr/share/postgresql-9.1/contrib/postgis-1.5/spatial_ref_sys.sql
    EOC
    not_if <<-EOC
        PGPASSWORD=#{node[:postgresql][:password]} psql -d postgis -U postgres >/dev/null 2&>1
    EOC
end

shell.log

vagrant@vagrant:~$ PGPASSWORD=R3n41rAfFMQzoOghaAYV psql -d postgis -U postgres >/dev/null 2&>1 && echo yes || echo no
no
vagrant@vagrant:~$