Contents

Standup.script :node do
  def run
    install_packages 'postgresql-8.4 libpq-dev'
  
    upload script_file('pg_hba.conf'),
           :to => '/etc/postgresql/8.4/main/pg_hba.conf',
           :sudo => true
  
    upload script_file('postgresql.conf'),
           :to => '/etc/postgresql/8.4/main/postgresql.conf',
           :sudo => true
  
    tune_kernel
  
    sudo 'service postgresql-8.4 restart'
  end
  
  def exec_sql sql, local = false
    command = "psql -c \"#{sql}\" -U postgres -w"
    if local
      local_exec command
    else
      exec command
    end
  end
  
  def create_database name, local = false
    if exec_sql("select * from pg_database where datname = '#{name}'", local) =~ /1 row/
      false
    else
      exec_sql "create database #{name}", local
      true
    end
  end
  
  def dump_command database, username = 'postgres', *args
    "pg_dump -c #{database} -U #{username} -w"
  end
  
  def load_command database, username = 'postgres', *args
    "psql #{database} -U #{username} -w"
  end
  
  protected
  
  def tune_kernel
    sysctl_params = ['kernel.shmmax=134217728', 'kernel.shmall=2097152']
  
    remote_update '/etc/sysctl.conf',
                  sysctl_params.join("\n"),
                  :delimiter => '# standup script postgresql',
                  :sudo => true
  
    sysctl_params.each {|p| sudo "sysctl -w #{p}"}
  end
end

Version data entries

15 entries across 15 versions & 1 rubygems

Version	Path
standup-0.3.26	scripts/postgresql.rb
standup-0.3.25	scripts/postgresql.rb
standup-0.3.24	scripts/postgresql.rb
standup-0.3.23	scripts/postgresql.rb
standup-0.3.22	scripts/postgresql.rb
standup-0.3.20	scripts/postgresql.rb
standup-0.3.19	scripts/postgresql.rb
standup-0.3.18	scripts/postgresql.rb
standup-0.3.17	scripts/postgresql.rb
standup-0.3.16	scripts/postgresql.rb
standup-0.3.15	scripts/postgresql.rb
standup-0.3.14	scripts/postgresql.rb
standup-0.3.13	scripts/postgresql.rb
standup-0.3.12	scripts/postgresql.rb
standup-0.3.11	scripts/postgresql.rb