byrd/pkg/pg.yaml

tasks:
  createuser:
    desc: Add postgres user
    sudo: postgres
    run: |
      if ! psql -c "SELECT usename FROM pg_user" | grep {pg_user} &> /dev/null
      then createuser {pg_user} -d
      fi
  createdb:
    desc: Create a new db for default user
    multi:
      - task: createdb-with-owner
    env:
      db_owner: "{ssh_user}"
  alter-passwd:
    desc: Alter user password
    sudo: postgres
    run: psql -c "ALTER USER {pg_user} WITH PASSWORD '{pg_password}'"
  createdb-with-owner:
    desc: Create a new db with a specific owner
    run: |
      if ! psql -l | grep {db_name} &> /dev/null
      then createdb -O {db_owner} {db_name}
      fi