Untitled

    %x[tar --list --file=#{params[:file]} db.tar]
    unless $?.success?
      raise "Verification failed. Could not find db.tar file in archive"
    end

    %x[dropdb -U #{@pguser} #{@restoredb}]
    %x[createdb -U #{@pguser} #{@restoredb}]
    unless $?.success?
      raise "Restore database failed."
    end

    %x[tar -xzOf #{params[:file]} db.tar > #{@tmpdir}/db.tar]
    %x[pg_restore -U #{@pguser} -d #{@restoredb} #{@tmpdir}/db.tar]
    unless $?.success?
      raise "Restore database failed."
    end

    %x[SIPXCONFIG_ANT_OPTS="-Dsipxconfig.db.name=#{@restoredb}" #{@servicedir}/sipxconfig db upgrade]

    unless params.has_key?(:domain)
      sql_exec @restoredb, "update domain set domain = '#{params[:domain]}';"
    end

    sql_exec @restoredb, "update location set ip_address = '#{params[:ipaddress]}' where primary = TRUE;"

    unless params.has_key?(:dryrun)
      %x[#{@init_d}/sipxconfig stop] if params.has_key?(:restart)
      %x[dropdb -U #{@pguser} #{@db}]
      sql_exec postgres, "alter database \"#{@restoredb}\" rename to \"#{@db}\";"
      %x[#{@init_d}/sipxconfig start] if params.has_key?(:restart)
    end