Skip to content

Instantly share code, notes, and snippets.

@max2320

max2320/dsn.sh

Created December 13, 2017 12:14
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save max2320/059617c263f75e2a7d8b92207f819f58 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save max2320/059617c263f75e2a7d8b92207f819f58 to your computer and use it in GitHub Desktop.
Download ZIP

Revisions

  1. max2320 created this gist Dec 13, 2017.
    19 changes: 19 additions & 0 deletions dsn.sh
    View file
    Original file line number Diff line number Diff line change
    @@ -0,0 +1,19 @@
    #usage: $ create_dsn 'username' 'password' 'host'
    create_dsn(){

    USER_NAME=$1
    PASSWORD=$2
    HOST=$3

    echo "CREATE DATABASE $USER_NAME;" >> "$USER_NAME.dsn"
    echo "CREATE ROLE $USER_NAME LOGIN PASSWORD '$PASSWORD';" >> "$USER_NAME.dsn"
    echo "ALTER DATABASE $USER_NAME OWNER TO $USER_NAME;" >> "$USER_NAME.dsn"

    echo "HOST: $HOST" >> "$USER_NAME.dsn"
    echo "USER: $USER_NAME" >> "$USER_NAME.dsn"
    echo "DATABASE: $USER_NAME" >> "$USER_NAME.dsn"
    echo "PASSWORD: $PASSWORD" >> "$USER_NAME.dsn"
    echo "DSN: postgres://$USER_NAME:$PASSWORD@$HOST:5432/$USER_NAME" >> "$USER_NAME.dsn"

    echo "$ PGPASSWORD='$PASSWORD' psql -U $USER_NAME -h $HOST $USER_NAME" >> "$USER_NAME.dsn"
    }