Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- %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
Add Comment
Please, Sign In to add comment