Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- backupdb () {
- if [ $# -eq 0 ]
- then
- echo "db_name not specified"
- else
- db_name=$1
- db_name_copy=${db_name}_copy
- psql -c "DROP DATABASE $db_name_copy;"
- psql -c "CREATE DATABASE $db_name_copy WITH TEMPLATE $db_name;"
- fi
- }
- restoredb () {
- if [ $# -eq 0 ]
- then
- echo "db_name not specified"
- else
- db_name=$1
- db_name_copy=${db_name}_copy
- psql -c "DROP DATABASE $db_name;"
- psql -c "CREATE DATABASE $db_name WITH TEMPLATE $db_name_copy;"
- fi
- }
Add Comment
Please, Sign In to add comment