| Mikhail Ivanov | cd2359a | 2018-04-18 17:49:01 +0400 | [diff] [blame] | 1 | classes: |
| 2 | - system.postgresql.client |
| 3 | parameters: |
| 4 | _param: |
| 5 | secmonkey_db_host: ${_param:haproxy_postgresql_bind_host} |
| 6 | secmonkey_db_user: secmonkey |
| Mikhail Ivanov | cd2359a | 2018-04-18 17:49:01 +0400 | [diff] [blame] | 7 | postgresql: |
| 8 | client: |
| 9 | server: |
| 10 | server01: |
| 11 | database: |
| 12 | pushkin: |
| 13 | init: |
| 14 | maintenance_db: pushkin |
| 15 | force: true |
| 16 | queries: |
| 17 | - INSERT INTO login VALUES (${_param:secmonkey_login_id}, ${_param:secmonkey_application_id}) ON CONFLICT (id) DO UPDATE SET id = excluded.id; |
| 18 | - INSERT INTO device VALUES (${_param:secmonkey_application_id}, ${_param:secmonkey_login_id}, 42, 'security_audit_service', NULL, 1, NULL) ON CONFLICT (id) DO UPDATE SET id = excluded.id; |