Contents

module Pvcglue
  class Packages
    class Postgresql < Pvcglue::Packages

      def installed?
        get_minion_state(:postgresql_updated_at)
      end

      def install!
        Pvcglue::Env.initialize_stage_env
        connection.write_to_file_from_template(:root, 'postgresql.conf.erb', '/etc/postgresql/9.6/main/postgresql.conf', 'postgres', 'postgres', '0644')
        connection.write_to_file_from_template(:root, 'pg_hba.conf.erb', '/etc/postgresql/9.6/main/pg_hba.conf', 'postgres', 'postgres', '0644')

        connection.run_get_stdout(:root, '', 'service postgresql restart')
        unless $?.exitstatus == 0
          Pvcglue.logger.error { 'Unable to (re)start postgresql.  Getting status...' }
          result = connection.run_get_stdout(:root, '', 'systemctl status postgresql.service')
          puts result
          raise('There was a problem restarting PostgreSQL.')
        end

        username = Pvcglue.cloud.stage_env['DB_USER_POSTGRES_USERNAME']
        password = Pvcglue.cloud.stage_env['DB_USER_POSTGRES_PASSWORD']
        db_name = username # just for clarity in later statements.  This also must match database.yml.
        # TODO:  Instead of ssh? below, use ssh!, but allow for the user having been already created.  It's only an issue for when the minion state has been reset
        connection.ssh?(:root, '', %Q[cd /var/lib/postgresql && sudo -u postgres psql -c "CREATE ROLE #{username} LOGIN CREATEDB PASSWORD '#{password}';"])
        connection.ssh!(:root, '', %Q[cd /var/lib/postgresql && sudo -u postgres psql -c "ALTER ROLE #{username} PASSWORD '#{password}' CREATEDB LOGIN"])
        connection.ssh?(:root, '', %Q[cd /var/lib/postgresql && sudo -u postgres psql -c "CREATE DATABASE #{db_name} WITH OWNER #{username}"])
        connection.ssh!(:root, '', %Q[cd /var/lib/postgresql && sudo -u postgres psql #{db_name} -c "ALTER SCHEMA public OWNER TO #{username}"])


        set_minion_state(:postgresql_updated_at, Time.now.utc)
      end

    end

  end
end

Version data entries

4 entries across 4 versions & 1 rubygems

Version	Path
pvcglue-0.9.4	lib/pvcglue/packages/postgresql.rb
pvcglue-0.9.3	lib/pvcglue/packages/postgresql.rb
pvcglue-0.9.2	lib/pvcglue/packages/postgresql.rb
pvcglue-0.9.1	lib/pvcglue/packages/postgresql.rb