Retrieve Pillar data by doing a postgres query
New in version 2017.7.0.
new
psycopg2
all
postgres:
user: 'salt'
pass: 'super_secret_password'
db: 'salt_db'
ext_pillar:
- postgres:
fromdb:
query: 'SELECT col1,col2,col3,col4,col5,col6,col7
FROM some_random_table
WHERE minion_pattern LIKE %s'
depth: 5
as_list: True
with_lists: [1,3]
salt.pillar.postgres.
POSTGRESExtPillar
¶This class receives and processes the database rows from POSTGRES.
extract_queries
(args, kwargs)¶This function normalizes the config block into a set of queries we can use. The return is a list of consistently laid out dicts.
salt.pillar.postgres.
ext_pillar
(minion_id, pillar, *args, **kwargs)¶Execute queries against POSTGRES, merge and return as a dict