retry-migrate-db-v0-v1.sh (1265B)
1 #!/bin/sh 2 # This file is in the public domain. 3 # Call with exchange configuration file as the exchange user (with DB access). 4 set -eu 5 CONF=${1:-/etc/taler-exchange/taler-exchange.conf} 6 DB=$(taler-exchange-config -c "$CONF" -s exchangedb-postgres -o config) 7 DBNAME=$(echo "$DB" | awk -F / '{print $4}') 8 DIR=$2 9 echo "Migrating to new schema" 10 taler-exchange-dbinit -c "$CONF" -r 11 12 for t in $(echo " 13 exchange.cs_nonce_locks 14 exchange.denominations 15 exchange.exchange_sign_keys 16 exchange.global_fee 17 exchange.known_coins 18 exchange.prewire 19 exchange.wire_accounts 20 exchange.wire_targets 21 exchange.reserves 22 exchange.batch_deposits 23 exchange.aggregation_tracking 24 exchange.aggregation_transient 25 exchange.close_requests 26 exchange.coin_deposits 27 exchange.contracts 28 exchange.history_requests 29 exchange.purse_requests 30 exchange.purse_decision 31 exchange.purse_deletion 32 exchange.purse_deposits 33 exchange.purse_merges 34 exchange.refunds 35 exchange.account_merges 36 exchange.reserves_close 37 exchange.reserves_in 38 exchange.reserves_open_deposits 39 exchange.reserves_open_requests 40 exchange.reserves_out 41 exchange.revolving_work_shards 42 exchange.wire_fee 43 exchange.wire_out 44 exchange.work_shards") 45 do 46 echo "Restoring Table $t" 47 psql --set="search_path=exchange" "$DB" < "$DIR/$t.sql" 48 done 49 echo "Done" 50 exit 0