Guest User

Untitled

a guest
Jan 19th, 2018
91
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.53 KB | None | 0 0
  1. backupdb () {
  2. if [ $# -eq 0 ]
  3. then
  4. echo "db_name not specified"
  5. else
  6. db_name=$1
  7. db_name_copy=${db_name}_copy
  8. psql -c "DROP DATABASE $db_name_copy;"
  9. psql -c "CREATE DATABASE $db_name_copy WITH TEMPLATE $db_name;"
  10. fi
  11. }
  12.  
  13. restoredb () {
  14. if [ $# -eq 0 ]
  15. then
  16. echo "db_name not specified"
  17. else
  18. db_name=$1
  19. db_name_copy=${db_name}_copy
  20. psql -c "DROP DATABASE $db_name;"
  21. psql -c "CREATE DATABASE $db_name WITH TEMPLATE $db_name_copy;"
  22. fi
  23. }
Add Comment
Please, Sign In to add comment