Magic words:
psql -U postgresSome interesting flags (to see all, use -h or --help depending on your psql version):
-E: will describe the underlaying queries of the \ commands (cool for learning!)-l: psql will list all databases and then exit (useful if the user you connect with doesn't has a default database, like at AWS RDS)
| . | |
| ├── bacula | |
| │ ├── client.sls | |
| │ └── server.sls | |
| ├── bprobe | |
| │ └── init.sls | |
| ├── cpall.sls | |
| ├── dirty-users | |
| │ ├── exports | |
| │ ├── group -> /etc/group |
| ''' | |
| Manages Icinga Passive Check delivery | |
| ''' | |
| import logging | |
| import logging.handlers | |
| import os | |
| import signal | |
| LOG_LEVELS = (logging.WARNING, logging.INFO, logging.DEBUG) |
| base: | |
| # For each directory that can have pillar files | |
| {% for root in opts['pillar_roots']['base'] -%} | |
| # Set a variable to the path to check | |
| {% set mygrain_sls = '{0}/{1}.sls'.format(root, grains['mygrain']) -%} | |
| # Check to see if the file exists, if so, include that pillar file. | |
| {% if salt['file.file_exists'](mygrain_sls) %} | |
| 'service_group:{{ grains["mygrain"] }}': | |
| - match: grain | |
| - {{ grains['mygrain'] }} |
| {% if salt['file.file_exists']('/scr') %} | |
| /scr: | |
| file.directory: | |
| - user: root | |
| - group: psgvb | |
| - mode: 2775 | |
| {% endif %} |
| univeralkey: universalvalue | |
| {% if opts.id == 'server01' %} | |
| github_key: | | |
| lkjasdlkfjsalkjsadflkjsalfkjasfdl kjasdfdl jsfd | |
| lkjaslfkjaslfkjslkfjlaskfjfslkfjslakfjflsakfjlkj | |
| lkjkaslkfjsalfkjsdlfkjsaldfkjsdfdlkjsafdlkjsadlfkj | |
| {% elif opts.id == 'server02' %} | |
| github_key: | | |
| xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx |
Have you ever wanted to have a Vagrant workspace with more than one Virtual Machine, and managed by Salt Stack? I did, but the documentation is not all there yet.
I managed to make it work with the following, hope it will be useful.
See the Complete salty-vagrant setup, but use the current Vagrantfile to have two machines.
| #!/bin/bash | |
| # | |
| # Run command in all running containers | |
| # Usage: $ ./lxc-exec-all.sh apt update && apt upgrade | |
| # | |
| for container in $(lxc list volatile.last_state.power=RUNNING -c n --format csv); do | |
| lxc exec "$container" "$@" | |
| done |
| # How to sign your custom RPM package with GPG key | |
| # Step: 1 | |
| # Generate gpg key pair (public key and private key) | |
| # | |
| # You will be prompted with a series of questions about encryption. | |
| # Simply select the default values presented. You will also be asked | |
| # to create a Real Name, Email Address and Comment (comment optional). | |
| # | |
| # If you get the following response: |
| salt '*' --out=txt cmd.run template=jinja "printf '{{ grains.id }}:\n host: {{ grains.fqdn }}\n user: yourname\n priv: /path/to/id_rsa\n sudo: false'" | awk -F':' '{ st = index($0,":")+1;print substr($0,st+1)}' |