annotate tests/data/extract-new-config.yml @ 769:4a4d1323b282 default tip

Doc what AWS partition is
author Franz Glasner <f.glasner@feldmann-mg.com>
date Mon, 19 Feb 2024 16:11:48 +0100
parents 1514e7d2f691
children
Ignore whitespace changes - Everywhere: Within whitespace: At end of lines:
rev   line source
760
1514e7d2f691 FIX: add forgotten test configuration data file
Franz Glasner <fzglas.hg@dom66.de>
parents:
diff changeset
1 # -*- coding: utf-8; mode: yaml; indent-tabs-mode: nil; -*-
1514e7d2f691 FIX: add forgotten test configuration data file
Franz Glasner <fzglas.hg@dom66.de>
parents:
diff changeset
2 #
1514e7d2f691 FIX: add forgotten test configuration data file
Franz Glasner <fzglas.hg@dom66.de>
parents:
diff changeset
3 %YAML 1.1
1514e7d2f691 FIX: add forgotten test configuration data file
Franz Glasner <fzglas.hg@dom66.de>
parents:
diff changeset
4 ---
1514e7d2f691 FIX: add forgotten test configuration data file
Franz Glasner <fzglas.hg@dom66.de>
parents:
diff changeset
5
1514e7d2f691 FIX: add forgotten test configuration data file
Franz Glasner <fzglas.hg@dom66.de>
parents:
diff changeset
6 globals:
1514e7d2f691 FIX: add forgotten test configuration data file
Franz Glasner <fzglas.hg@dom66.de>
parents:
diff changeset
7 var1: value1
1514e7d2f691 FIX: add forgotten test configuration data file
Franz Glasner <fzglas.hg@dom66.de>
parents:
diff changeset
8 var2: value2
1514e7d2f691 FIX: add forgotten test configuration data file
Franz Glasner <fzglas.hg@dom66.de>
parents:
diff changeset
9 datadir1: &datadir 'E:\home\fag\p\work5\pgdbmgr\_data'
1514e7d2f691 FIX: add forgotten test configuration data file
Franz Glasner <fzglas.hg@dom66.de>
parents:
diff changeset
10 PGBINDIR: 'E:\APPS64\PostgreSQL-9.4\all\bin'
1514e7d2f691 FIX: add forgotten test configuration data file
Franz Glasner <fzglas.hg@dom66.de>
parents:
diff changeset
11
1514e7d2f691 FIX: add forgotten test configuration data file
Franz Glasner <fzglas.hg@dom66.de>
parents:
diff changeset
12 PATH: '{{PGBINDIR}}'
1514e7d2f691 FIX: add forgotten test configuration data file
Franz Glasner <fzglas.hg@dom66.de>
parents:
diff changeset
13
1514e7d2f691 FIX: add forgotten test configuration data file
Franz Glasner <fzglas.hg@dom66.de>
parents:
diff changeset
14 user1:
1514e7d2f691 FIX: add forgotten test configuration data file
Franz Glasner <fzglas.hg@dom66.de>
parents:
diff changeset
15 name: &rootname 'My Username'
1514e7d2f691 FIX: add forgotten test configuration data file
Franz Glasner <fzglas.hg@dom66.de>
parents:
diff changeset
16 pwd: &rootpwd 'My Password'
1514e7d2f691 FIX: add forgotten test configuration data file
Franz Glasner <fzglas.hg@dom66.de>
parents:
diff changeset
17
1514e7d2f691 FIX: add forgotten test configuration data file
Franz Glasner <fzglas.hg@dom66.de>
parents:
diff changeset
18 user2:
1514e7d2f691 FIX: add forgotten test configuration data file
Franz Glasner <fzglas.hg@dom66.de>
parents:
diff changeset
19 name: 'myquizowner'
1514e7d2f691 FIX: add forgotten test configuration data file
Franz Glasner <fzglas.hg@dom66.de>
parents:
diff changeset
20 pwd: 'abcQQQ123456'
1514e7d2f691 FIX: add forgotten test configuration data file
Franz Glasner <fzglas.hg@dom66.de>
parents:
diff changeset
21
1514e7d2f691 FIX: add forgotten test configuration data file
Franz Glasner <fzglas.hg@dom66.de>
parents:
diff changeset
22 database: myquiz
1514e7d2f691 FIX: add forgotten test configuration data file
Franz Glasner <fzglas.hg@dom66.de>
parents:
diff changeset
23
1514e7d2f691 FIX: add forgotten test configuration data file
Franz Glasner <fzglas.hg@dom66.de>
parents:
diff changeset
24 dbhost: localhost
1514e7d2f691 FIX: add forgotten test configuration data file
Franz Glasner <fzglas.hg@dom66.de>
parents:
diff changeset
25 dbport: 5432
1514e7d2f691 FIX: add forgotten test configuration data file
Franz Glasner <fzglas.hg@dom66.de>
parents:
diff changeset
26
1514e7d2f691 FIX: add forgotten test configuration data file
Franz Glasner <fzglas.hg@dom66.de>
parents:
diff changeset
27 engine0:
1514e7d2f691 FIX: add forgotten test configuration data file
Franz Glasner <fzglas.hg@dom66.de>
parents:
diff changeset
28 url: 'postgresql+psycopg2://{{user1.name|urlquote}}:{{user1.pwd|urlquote}}@{{dbhost}}:{{dbport}}/postgres'
1514e7d2f691 FIX: add forgotten test configuration data file
Franz Glasner <fzglas.hg@dom66.de>
parents:
diff changeset
29 echo: false
1514e7d2f691 FIX: add forgotten test configuration data file
Franz Glasner <fzglas.hg@dom66.de>
parents:
diff changeset
30 echo_pool: false
1514e7d2f691 FIX: add forgotten test configuration data file
Franz Glasner <fzglas.hg@dom66.de>
parents:
diff changeset
31 encoding: utf-8
1514e7d2f691 FIX: add forgotten test configuration data file
Franz Glasner <fzglas.hg@dom66.de>
parents:
diff changeset
32 isolation_level: 'SERIALIZABLE'
1514e7d2f691 FIX: add forgotten test configuration data file
Franz Glasner <fzglas.hg@dom66.de>
parents:
diff changeset
33
1514e7d2f691 FIX: add forgotten test configuration data file
Franz Glasner <fzglas.hg@dom66.de>
parents:
diff changeset
34 engine1:
1514e7d2f691 FIX: add forgotten test configuration data file
Franz Glasner <fzglas.hg@dom66.de>
parents:
diff changeset
35 url: 'postgresql+psycopg2://{{user2.name|urlquote}}:{{user2.pwd|urlquote}}@{{dbhost}}:{{dbport}}/{{database}}'
1514e7d2f691 FIX: add forgotten test configuration data file
Franz Glasner <fzglas.hg@dom66.de>
parents:
diff changeset
36 echo: false
1514e7d2f691 FIX: add forgotten test configuration data file
Franz Glasner <fzglas.hg@dom66.de>
parents:
diff changeset
37 echo_pool: false
1514e7d2f691 FIX: add forgotten test configuration data file
Franz Glasner <fzglas.hg@dom66.de>
parents:
diff changeset
38 encoding: utf-8
1514e7d2f691 FIX: add forgotten test configuration data file
Franz Glasner <fzglas.hg@dom66.de>
parents:
diff changeset
39 isolation_level: 'SERIALIZABLE'
1514e7d2f691 FIX: add forgotten test configuration data file
Franz Glasner <fzglas.hg@dom66.de>
parents:
diff changeset
40
1514e7d2f691 FIX: add forgotten test configuration data file
Franz Glasner <fzglas.hg@dom66.de>
parents:
diff changeset
41 section: This is the Root Section
1514e7d2f691 FIX: add forgotten test configuration data file
Franz Glasner <fzglas.hg@dom66.de>
parents:
diff changeset
42 parts:
1514e7d2f691 FIX: add forgotten test configuration data file
Franz Glasner <fzglas.hg@dom66.de>
parents:
diff changeset
43 - section: This is Section 1
1514e7d2f691 FIX: add forgotten test configuration data file
Franz Glasner <fzglas.hg@dom66.de>
parents:
diff changeset
44 parts:
1514e7d2f691 FIX: add forgotten test configuration data file
Franz Glasner <fzglas.hg@dom66.de>
parents:
diff changeset
45 - section: This is Section 2, a subsection of Section 1
1514e7d2f691 FIX: add forgotten test configuration data file
Franz Glasner <fzglas.hg@dom66.de>
parents:
diff changeset
46 op: initcluster
1514e7d2f691 FIX: add forgotten test configuration data file
Franz Glasner <fzglas.hg@dom66.de>
parents:
diff changeset
47 params:
1514e7d2f691 FIX: add forgotten test configuration data file
Franz Glasner <fzglas.hg@dom66.de>
parents:
diff changeset
48 superuser: '{{user1.name}}'
1514e7d2f691 FIX: add forgotten test configuration data file
Franz Glasner <fzglas.hg@dom66.de>
parents:
diff changeset
49 superpassword: '{{user1.pwd}}'
1514e7d2f691 FIX: add forgotten test configuration data file
Franz Glasner <fzglas.hg@dom66.de>
parents:
diff changeset
50 # or here also: rootuser: *rootname
1514e7d2f691 FIX: add forgotten test configuration data file
Franz Glasner <fzglas.hg@dom66.de>
parents:
diff changeset
51 locale: C
1514e7d2f691 FIX: add forgotten test configuration data file
Franz Glasner <fzglas.hg@dom66.de>
parents:
diff changeset
52 encoding: UTF8
1514e7d2f691 FIX: add forgotten test configuration data file
Franz Glasner <fzglas.hg@dom66.de>
parents:
diff changeset
53 datadir: *datadir
1514e7d2f691 FIX: add forgotten test configuration data file
Franz Glasner <fzglas.hg@dom66.de>
parents:
diff changeset
54 # or here also: datadir: '{{datadir1}}'
1514e7d2f691 FIX: add forgotten test configuration data file
Franz Glasner <fzglas.hg@dom66.de>
parents:
diff changeset
55
1514e7d2f691 FIX: add forgotten test configuration data file
Franz Glasner <fzglas.hg@dom66.de>
parents:
diff changeset
56 - section: Create a User (DB Owner)
1514e7d2f691 FIX: add forgotten test configuration data file
Franz Glasner <fzglas.hg@dom66.de>
parents:
diff changeset
57 op: createuser
1514e7d2f691 FIX: add forgotten test configuration data file
Franz Glasner <fzglas.hg@dom66.de>
parents:
diff changeset
58 params:
1514e7d2f691 FIX: add forgotten test configuration data file
Franz Glasner <fzglas.hg@dom66.de>
parents:
diff changeset
59 name: '{{user2.name}}'
1514e7d2f691 FIX: add forgotten test configuration data file
Franz Glasner <fzglas.hg@dom66.de>
parents:
diff changeset
60 password: '{{user2.pwd}}'
1514e7d2f691 FIX: add forgotten test configuration data file
Franz Glasner <fzglas.hg@dom66.de>
parents:
diff changeset
61 login: true
1514e7d2f691 FIX: add forgotten test configuration data file
Franz Glasner <fzglas.hg@dom66.de>
parents:
diff changeset
62 options:
1514e7d2f691 FIX: add forgotten test configuration data file
Franz Glasner <fzglas.hg@dom66.de>
parents:
diff changeset
63 connstr: engine0
1514e7d2f691 FIX: add forgotten test configuration data file
Franz Glasner <fzglas.hg@dom66.de>
parents:
diff changeset
64
1514e7d2f691 FIX: add forgotten test configuration data file
Franz Glasner <fzglas.hg@dom66.de>
parents:
diff changeset
65 - section: Install
1514e7d2f691 FIX: add forgotten test configuration data file
Franz Glasner <fzglas.hg@dom66.de>
parents:
diff changeset
66 op: createdb
1514e7d2f691 FIX: add forgotten test configuration data file
Franz Glasner <fzglas.hg@dom66.de>
parents:
diff changeset
67 params:
1514e7d2f691 FIX: add forgotten test configuration data file
Franz Glasner <fzglas.hg@dom66.de>
parents:
diff changeset
68 name: '{{database}}'
1514e7d2f691 FIX: add forgotten test configuration data file
Franz Glasner <fzglas.hg@dom66.de>
parents:
diff changeset
69 owner: '{{user2.name}}'
1514e7d2f691 FIX: add forgotten test configuration data file
Franz Glasner <fzglas.hg@dom66.de>
parents:
diff changeset
70 connection_limit: 30
1514e7d2f691 FIX: add forgotten test configuration data file
Franz Glasner <fzglas.hg@dom66.de>
parents:
diff changeset
71 options:
1514e7d2f691 FIX: add forgotten test configuration data file
Franz Glasner <fzglas.hg@dom66.de>
parents:
diff changeset
72 connstr: engine0
1514e7d2f691 FIX: add forgotten test configuration data file
Franz Glasner <fzglas.hg@dom66.de>
parents:
diff changeset
73
1514e7d2f691 FIX: add forgotten test configuration data file
Franz Glasner <fzglas.hg@dom66.de>
parents:
diff changeset
74
1514e7d2f691 FIX: add forgotten test configuration data file
Franz Glasner <fzglas.hg@dom66.de>
parents:
diff changeset
75 - section: This is another section
1514e7d2f691 FIX: add forgotten test configuration data file
Franz Glasner <fzglas.hg@dom66.de>
parents:
diff changeset
76 depends: This is Section 1
1514e7d2f691 FIX: add forgotten test configuration data file
Franz Glasner <fzglas.hg@dom66.de>
parents:
diff changeset
77 # OR - if more than one dependency
1514e7d2f691 FIX: add forgotten test configuration data file
Franz Glasner <fzglas.hg@dom66.de>
parents:
diff changeset
78 # depends:
1514e7d2f691 FIX: add forgotten test configuration data file
Franz Glasner <fzglas.hg@dom66.de>
parents:
diff changeset
79 # - This is Section 1
1514e7d2f691 FIX: add forgotten test configuration data file
Franz Glasner <fzglas.hg@dom66.de>
parents:
diff changeset
80 # - Maybe another Section on which this section depends
1514e7d2f691 FIX: add forgotten test configuration data file
Franz Glasner <fzglas.hg@dom66.de>
parents:
diff changeset
81 op: the_new_operation
1514e7d2f691 FIX: add forgotten test configuration data file
Franz Glasner <fzglas.hg@dom66.de>
parents:
diff changeset
82 with:
1514e7d2f691 FIX: add forgotten test configuration data file
Franz Glasner <fzglas.hg@dom66.de>
parents:
diff changeset
83 vars:
1514e7d2f691 FIX: add forgotten test configuration data file
Franz Glasner <fzglas.hg@dom66.de>
parents:
diff changeset
84 a: '{{var1}}'
1514e7d2f691 FIX: add forgotten test configuration data file
Franz Glasner <fzglas.hg@dom66.de>
parents:
diff changeset
85 b: 'file://{{user1.name|urlquote}}:{{user1.pwd | urlquote}}@localhost/'
1514e7d2f691 FIX: add forgotten test configuration data file
Franz Glasner <fzglas.hg@dom66.de>
parents:
diff changeset
86 # cwd: 'E:\what{{a}}'
1514e7d2f691 FIX: add forgotten test configuration data file
Franz Glasner <fzglas.hg@dom66.de>
parents:
diff changeset
87
1514e7d2f691 FIX: add forgotten test configuration data file
Franz Glasner <fzglas.hg@dom66.de>
parents:
diff changeset
88
1514e7d2f691 FIX: add forgotten test configuration data file
Franz Glasner <fzglas.hg@dom66.de>
parents:
diff changeset
89 pool:
1514e7d2f691 FIX: add forgotten test configuration data file
Franz Glasner <fzglas.hg@dom66.de>
parents:
diff changeset
90 - section: Start Cluster
1514e7d2f691 FIX: add forgotten test configuration data file
Franz Glasner <fzglas.hg@dom66.de>
parents:
diff changeset
91 op: startcluster
1514e7d2f691 FIX: add forgotten test configuration data file
Franz Glasner <fzglas.hg@dom66.de>
parents:
diff changeset
92 params:
1514e7d2f691 FIX: add forgotten test configuration data file
Franz Glasner <fzglas.hg@dom66.de>
parents:
diff changeset
93 datadir: '{{datadir1}}'
1514e7d2f691 FIX: add forgotten test configuration data file
Franz Glasner <fzglas.hg@dom66.de>
parents:
diff changeset
94 logfile: '{{datadir1}}/_log.log'
1514e7d2f691 FIX: add forgotten test configuration data file
Franz Glasner <fzglas.hg@dom66.de>
parents:
diff changeset
95
1514e7d2f691 FIX: add forgotten test configuration data file
Franz Glasner <fzglas.hg@dom66.de>
parents:
diff changeset
96 - section: Stop Cluster
1514e7d2f691 FIX: add forgotten test configuration data file
Franz Glasner <fzglas.hg@dom66.de>
parents:
diff changeset
97 op: stopcluster
1514e7d2f691 FIX: add forgotten test configuration data file
Franz Glasner <fzglas.hg@dom66.de>
parents:
diff changeset
98 params:
1514e7d2f691 FIX: add forgotten test configuration data file
Franz Glasner <fzglas.hg@dom66.de>
parents:
diff changeset
99 datadir: '{{datadir1}}'
1514e7d2f691 FIX: add forgotten test configuration data file
Franz Glasner <fzglas.hg@dom66.de>
parents:
diff changeset
100
1514e7d2f691 FIX: add forgotten test configuration data file
Franz Glasner <fzglas.hg@dom66.de>
parents:
diff changeset
101 - section: Configure
1514e7d2f691 FIX: add forgotten test configuration data file
Franz Glasner <fzglas.hg@dom66.de>
parents:
diff changeset
102 op: amendconfig
1514e7d2f691 FIX: add forgotten test configuration data file
Franz Glasner <fzglas.hg@dom66.de>
parents:
diff changeset
103 args:
1514e7d2f691 FIX: add forgotten test configuration data file
Franz Glasner <fzglas.hg@dom66.de>
parents:
diff changeset
104 - "log_connections = on"
1514e7d2f691 FIX: add forgotten test configuration data file
Franz Glasner <fzglas.hg@dom66.de>
parents:
diff changeset
105 - "log_disconnections = on"
1514e7d2f691 FIX: add forgotten test configuration data file
Franz Glasner <fzglas.hg@dom66.de>
parents:
diff changeset
106 - "log_line_prefix = '%m %u@%d %p %r '"
1514e7d2f691 FIX: add forgotten test configuration data file
Franz Glasner <fzglas.hg@dom66.de>
parents:
diff changeset
107 params:
1514e7d2f691 FIX: add forgotten test configuration data file
Franz Glasner <fzglas.hg@dom66.de>
parents:
diff changeset
108 datadir: '{{datadir1}}'
1514e7d2f691 FIX: add forgotten test configuration data file
Franz Glasner <fzglas.hg@dom66.de>
parents:
diff changeset
109
1514e7d2f691 FIX: add forgotten test configuration data file
Franz Glasner <fzglas.hg@dom66.de>
parents:
diff changeset
110 - section: Exit
1514e7d2f691 FIX: add forgotten test configuration data file
Franz Glasner <fzglas.hg@dom66.de>
parents:
diff changeset
111 op: exit
1514e7d2f691 FIX: add forgotten test configuration data file
Franz Glasner <fzglas.hg@dom66.de>
parents:
diff changeset
112 params:
1514e7d2f691 FIX: add forgotten test configuration data file
Franz Glasner <fzglas.hg@dom66.de>
parents:
diff changeset
113 exitcode: 0
1514e7d2f691 FIX: add forgotten test configuration data file
Franz Glasner <fzglas.hg@dom66.de>
parents:
diff changeset
114
1514e7d2f691 FIX: add forgotten test configuration data file
Franz Glasner <fzglas.hg@dom66.de>
parents:
diff changeset
115 - section: Uninstall
1514e7d2f691 FIX: add forgotten test configuration data file
Franz Glasner <fzglas.hg@dom66.de>
parents:
diff changeset
116 op: deletedb
1514e7d2f691 FIX: add forgotten test configuration data file
Franz Glasner <fzglas.hg@dom66.de>
parents:
diff changeset
117 params:
1514e7d2f691 FIX: add forgotten test configuration data file
Franz Glasner <fzglas.hg@dom66.de>
parents:
diff changeset
118 name: '{{database}}'
1514e7d2f691 FIX: add forgotten test configuration data file
Franz Glasner <fzglas.hg@dom66.de>
parents:
diff changeset
119 options:
1514e7d2f691 FIX: add forgotten test configuration data file
Franz Glasner <fzglas.hg@dom66.de>
parents:
diff changeset
120 connstr: engine0