Friday, August 7, 2015

tip: easily run Postgres administration commands

TIP: on Linux it helps to be the Postgres user to do administration stuff with the database.  Either do some configuration twiddling, or run commands as the postgres user:

sudo su -c 'dropdb mydb' postgres

In Ansible, this is:

 - name: database -- zap database
      command: dropdb mydb 
      sudo: yes
      sudo_user: postgres

No comments:

Post a Comment