|
39 | 39 | binary_upgrade=> {
|
40 | 40 | dump_cmd=> [
|
41 | 41 | 'pg_dump',
|
| 42 | +'--no-sync', |
42 | 43 | '--format=custom',
|
43 | 44 | "--file=$tempdir/binary_upgrade.dump",
|
44 | 45 | '-w',
|
|
55 | 56 | clean=> {
|
56 | 57 | dump_cmd=> [
|
57 | 58 | 'pg_dump',
|
| 59 | +'--no-sync', |
58 | 60 | "--file=$tempdir/clean.sql",
|
59 | 61 | '--include-subscriptions',
|
60 | 62 | '-c',
|
|
63 | 65 | clean_if_exists=> {
|
64 | 66 | dump_cmd=> [
|
65 | 67 | 'pg_dump',
|
| 68 | +'--no-sync', |
66 | 69 | "--file=$tempdir/clean_if_exists.sql",
|
67 | 70 | '--include-subscriptions',
|
68 | 71 | '-c',
|
|
71 | 74 | 'postgres', ], },
|
72 | 75 | column_inserts=> {
|
73 | 76 | dump_cmd=> [
|
74 |
| -'pg_dump',"--file=$tempdir/column_inserts.sql", |
75 |
| -'-a','--column-inserts', |
| 77 | +'pg_dump', |
| 78 | +'--no-sync', |
| 79 | +"--file=$tempdir/column_inserts.sql", |
| 80 | +'-a', |
| 81 | +'--column-inserts', |
76 | 82 | 'postgres', ], },
|
77 | 83 | createdb=> {
|
78 | 84 | dump_cmd=> [
|
79 | 85 | 'pg_dump',
|
| 86 | +'--no-sync', |
80 | 87 | "--file=$tempdir/createdb.sql",
|
81 | 88 | '--include-subscriptions',
|
82 | 89 | '-C',
|
|
86 | 93 | data_only=> {
|
87 | 94 | dump_cmd=> [
|
88 | 95 | 'pg_dump',
|
| 96 | +'--no-sync', |
89 | 97 | "--file=$tempdir/data_only.sql",
|
90 | 98 | '--include-subscriptions',
|
91 | 99 | '-a',
|
|
94 | 102 | '-v',# no-op, just make sure it works
|
95 | 103 | 'postgres', ], },
|
96 | 104 | defaults=> {
|
97 |
| -dump_cmd=> ['pg_dump','-f',"$tempdir/defaults.sql",'postgres', ], |
98 |
| -}, |
| 105 | +dump_cmd=> [ |
| 106 | +'pg_dump', |
| 107 | +'--no-sync', |
| 108 | +'-f', |
| 109 | +"$tempdir/defaults.sql", |
| 110 | +'postgres', ], }, |
| 111 | +# Do not use --no-sync to give test coverage for data sync. |
99 | 112 | defaults_custom_format=> {
|
100 | 113 | test_key=>'defaults',
|
101 | 114 | dump_cmd=> [
|
|
105 | 118 | 'pg_restore','-Fc',
|
106 | 119 | "--file=$tempdir/defaults_custom_format.sql",
|
107 | 120 | "$tempdir/defaults_custom_format.dump", ], },
|
| 121 | +# Do not use --no-sync to give test coverage for data sync. |
108 | 122 | defaults_dir_format=> {
|
109 | 123 | test_key=>'defaults',
|
110 | 124 | dump_cmd=> [
|
|
114 | 128 | 'pg_restore','-Fd',
|
115 | 129 | "--file=$tempdir/defaults_dir_format.sql",
|
116 | 130 | "$tempdir/defaults_dir_format", ], },
|
| 131 | +# Do not use --no-sync to give test coverage for data sync. |
117 | 132 | defaults_parallel=> {
|
118 | 133 | test_key=>'defaults',
|
119 | 134 | dump_cmd=> [
|
|
123 | 138 | 'pg_restore',
|
124 | 139 | "--file=$tempdir/defaults_parallel.sql",
|
125 | 140 | "$tempdir/defaults_parallel", ], },
|
| 141 | +# Do not use --no-sync to give test coverage for data sync. |
126 | 142 | defaults_tar_format=> {
|
127 | 143 | test_key=>'defaults',
|
128 | 144 | dump_cmd=> [
|
|
135 | 151 | "$tempdir/defaults_tar_format.tar", ], },
|
136 | 152 | exclude_dump_test_schema=> {
|
137 | 153 | dump_cmd=> [
|
138 |
| -'pg_dump',"--file=$tempdir/exclude_dump_test_schema.sql", |
139 |
| -'--exclude-schema=dump_test','postgres', ], }, |
| 154 | +'pg_dump', |
| 155 | +'--no-sync', |
| 156 | +"--file=$tempdir/exclude_dump_test_schema.sql", |
| 157 | +'--exclude-schema=dump_test', |
| 158 | +'postgres', ], }, |
140 | 159 | exclude_test_table=> {
|
141 | 160 | dump_cmd=> [
|
142 | 161 | 'pg_dump',
|
| 162 | +'--no-sync', |
143 | 163 | "--file=$tempdir/exclude_test_table.sql",
|
144 | 164 | '--exclude-table=dump_test.test_table',
|
145 | 165 | 'postgres', ], },
|
146 | 166 | exclude_test_table_data=> {
|
147 | 167 | dump_cmd=> [
|
148 | 168 | 'pg_dump',
|
| 169 | +'--no-sync', |
149 | 170 | "--file=$tempdir/exclude_test_table_data.sql",
|
150 | 171 | '--exclude-table-data=dump_test.test_table',
|
151 | 172 | '--no-unlogged-table-data',
|
152 | 173 | 'postgres', ], },
|
153 | 174 | pg_dumpall_globals=> {
|
154 | 175 | dump_cmd=> [
|
155 | 176 | 'pg_dumpall','-v',
|
156 |
| -"--file=$tempdir/pg_dumpall_globals.sql",'-g', ], }, |
| 177 | +"--file=$tempdir/pg_dumpall_globals.sql",'-g', |
| 178 | +'--no-sync', ], }, |
157 | 179 | pg_dumpall_globals_clean=> {
|
158 | 180 | dump_cmd=> [
|
159 |
| -'pg_dumpall',"--file=$tempdir/pg_dumpall_globals_clean.sql", |
160 |
| -'-g','-c', ], }, |
| 181 | +'pg_dumpall', |
| 182 | +"--file=$tempdir/pg_dumpall_globals_clean.sql", |
| 183 | +'-g', |
| 184 | +'-c', |
| 185 | +'--no-sync', ], }, |
161 | 186 | pg_dumpall_dbprivs=> {
|
162 |
| -dump_cmd=> |
163 |
| - ['pg_dumpall',"--file=$tempdir/pg_dumpall_dbprivs.sql", ], }, |
| 187 | +dump_cmd=> [ |
| 188 | +'pg_dumpall', |
| 189 | +'--no-sync', |
| 190 | +"--file=$tempdir/pg_dumpall_dbprivs.sql", ], }, |
164 | 191 | no_blobs=> {
|
165 |
| -dump_cmd=> |
166 |
| - ['pg_dump',"--file=$tempdir/no_blobs.sql",'-B','postgres', ], }, |
| 192 | +dump_cmd=> [ |
| 193 | +'pg_dump', |
| 194 | +'--no-sync', |
| 195 | +"--file=$tempdir/no_blobs.sql", |
| 196 | +'-B', |
| 197 | +'postgres', ], }, |
167 | 198 | no_privs=> {
|
168 |
| -dump_cmd=> |
169 |
| - ['pg_dump',"--file=$tempdir/no_privs.sql",'-x','postgres', ], }, |
| 199 | +dump_cmd=> [ |
| 200 | +'pg_dump', |
| 201 | +'--no-sync', |
| 202 | +"--file=$tempdir/no_privs.sql", |
| 203 | +'-x', |
| 204 | +'postgres', ], }, |
170 | 205 | no_owner=> {
|
171 |
| -dump_cmd=> |
172 |
| - ['pg_dump',"--file=$tempdir/no_owner.sql",'-O','postgres', ], }, |
| 206 | +dump_cmd=> [ |
| 207 | +'pg_dump', |
| 208 | +'--no-sync', |
| 209 | +"--file=$tempdir/no_owner.sql", |
| 210 | +'-O', |
| 211 | +'postgres', ], }, |
173 | 212 | only_dump_test_schema=> {
|
174 | 213 | dump_cmd=> [
|
175 |
| -'pg_dump',"--file=$tempdir/only_dump_test_schema.sql", |
176 |
| -'--schema=dump_test','postgres', ], }, |
| 214 | +'pg_dump', |
| 215 | +'--no-sync', |
| 216 | +"--file=$tempdir/only_dump_test_schema.sql", |
| 217 | +'--schema=dump_test', |
| 218 | +'postgres', ], }, |
177 | 219 | only_dump_test_table=> {
|
178 | 220 | dump_cmd=> [
|
179 | 221 | 'pg_dump',
|
| 222 | +'--no-sync', |
180 | 223 | "--file=$tempdir/only_dump_test_table.sql",
|
181 | 224 | '--table=dump_test.test_table',
|
182 | 225 | '--lock-wait-timeout=1000000',
|
183 | 226 | 'postgres', ], },
|
184 | 227 | role=> {
|
185 | 228 | dump_cmd=> [
|
186 | 229 | 'pg_dump',
|
| 230 | +'--no-sync', |
187 | 231 | "--file=$tempdir/role.sql",
|
188 | 232 | '--role=regress_dump_test_role',
|
189 | 233 | '--schema=dump_test_second_schema',
|
|
192 | 236 | test_key=>'role',
|
193 | 237 | dump_cmd=> [
|
194 | 238 | 'pg_dump',
|
| 239 | +'--no-sync', |
195 | 240 | '--format=directory',
|
196 | 241 | '--jobs=2',
|
197 | 242 | "--file=$tempdir/role_parallel",
|
|
204 | 249 | schema_only=> {
|
205 | 250 | dump_cmd=> [
|
206 | 251 | 'pg_dump','--format=plain',"--file=$tempdir/schema_only.sql",
|
207 |
| -'-s','postgres', ], }, |
| 252 | +'--no-sync','-s','postgres', ], }, |
208 | 253 | section_pre_data=> {
|
209 | 254 | dump_cmd=> [
|
210 | 255 | 'pg_dump',"--file=$tempdir/section_pre_data.sql",
|
211 | 256 | '--include-subscriptions',
|
212 |
| -'--section=pre-data','postgres', ], }, |
| 257 | +'--section=pre-data','--no-sync','postgres', ], }, |
213 | 258 | section_data=> {
|
214 | 259 | dump_cmd=> [
|
215 | 260 | 'pg_dump',"--file=$tempdir/section_data.sql",
|
216 |
| -'--section=data','postgres', ], }, |
| 261 | +'--section=data','--no-sync','postgres', ], }, |
217 | 262 | section_post_data=> {
|
218 | 263 | dump_cmd=> [
|
219 | 264 | 'pg_dump',"--file=$tempdir/section_post_data.sql",
|
220 |
| -'--section=post-data','postgres', ], }, |
| 265 | +'--section=post-data','--no-sync','postgres', ], }, |
221 | 266 | test_schema_plus_blobs=> {
|
222 | 267 | dump_cmd=> [
|
223 | 268 | 'pg_dump',"--file=$tempdir/test_schema_plus_blobs.sql",
|
224 |
| -'--schema=dump_test','-b','-B','postgres', ], }, |
| 269 | + |
| 270 | +'--schema=dump_test','-b','-B','--no-sync','postgres', ], }, |
225 | 271 | with_oids=> {
|
226 | 272 | dump_cmd=> [
|
227 | 273 | 'pg_dump','--oids',
|
228 |
| -'--include-subscriptions', |
| 274 | +'--include-subscriptions','--no-sync', |
229 | 275 | "--file=$tempdir/with_oids.sql",'postgres', ], },);
|
230 | 276 |
|
231 | 277 | ###############################################################
|
|