Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- #!/usr/bin/env bash
- DB_HOST=
- DB_NAME=
- DB_USER=
- DB_PASS=
- psql "sslmode=verify-ca sslrootcert=server-ca.pem sslcert=client-cert.pem sslkey=client-key.pem hostaddr=$DB_HOST port=5432 user=postgres" << EOF
- CREATE DATABASE $DB_NAME ;
- CREATE USER $DB_USER WITH ENCRYPTED PASSWORD '$DB_PASS' ;
- GRANT ALL PRIVILEGES ON DATABASE $DB_NAME TO $DB_USER ;
- EOF
- echo "LIST DATABASES..."
- psql "sslmode=verify-ca sslrootcert=server-ca.pem sslcert=client-cert.pem sslkey=client-key.pem hostaddr=$DB_HOST port=5432 user=postgres" --list
- echo "USAGE: "
- 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\"
- : '
- ## HELP ##
- show database = \l
- show users = \du
- drop database $DB_NAME;
- drop user $DB_USER ;
- '
Add Comment
Please, Sign In to add comment