Guest User

Untitled

a guest
Nov 20th, 2018
141
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.78 KB | None | 0 0
  1. #!/usr/bin/env bash
  2.  
  3. DB_HOST=
  4. DB_NAME=
  5. DB_USER=
  6. DB_PASS=
  7.  
  8. psql "sslmode=verify-ca sslrootcert=server-ca.pem sslcert=client-cert.pem sslkey=client-key.pem hostaddr=$DB_HOST port=5432 user=postgres" << EOF
  9. CREATE DATABASE $DB_NAME ;
  10. CREATE USER $DB_USER WITH ENCRYPTED PASSWORD '$DB_PASS' ;
  11. GRANT ALL PRIVILEGES ON DATABASE $DB_NAME TO $DB_USER ;
  12. EOF
  13.  
  14. echo "LIST DATABASES..."
  15. psql "sslmode=verify-ca sslrootcert=server-ca.pem sslcert=client-cert.pem sslkey=client-key.pem hostaddr=$DB_HOST port=5432 user=postgres" --list
  16.  
  17. echo "USAGE: "
  18. echo psql \"sslmode=verify-ca sslrootcert=server-ca.pem sslcert=client-cert.pem sslkey=client-key.pem hostaddr=$DB_HOST port=5432 user=$DB_USER dbname=$DB_NAME\"
  19.  
  20. : '
  21. ## HELP ##
  22. show database = \l
  23. show users = \du
  24. drop database $DB_NAME;
  25. drop user $DB_USER ;
  26. '
Add Comment
Please, Sign In to add comment