- Notifications
You must be signed in to change notification settings - Fork5
Commit9b8aff8
committed
Add REPLICATION privilege for ROLEs
This privilege is required to do Streaming Replication, instead ofsuperuser, making it possible to set up a SR slave that doesn'thave write permissions on the master.Superuser privileges do NOT override this check, so in order touse the default superuser account for replication it must beexplicitly granted the REPLICATION permissions. This is backwardsincompatible change, in the interest of higher default security.1 parentf2ba1e9 commit9b8aff8
File tree
19 files changed
+189
-32
lines changed- doc/src/sgml
- ref
- src
- backend
- access/transam
- catalog
- commands
- parser
- utils/init
- bin
- pg_dump
- psql
- include
- catalog
- parser
- test/regress/expected
19 files changed
+189
-32
lines changedLines changed: 11 additions & 0 deletions
Original file line number | Diff line number | Diff line change | |
---|---|---|---|
| |||
1235 | 1235 |
| |
1236 | 1236 |
| |
1237 | 1237 |
| |
| 1238 | + | |
| 1239 | + | |
| 1240 | + | |
| 1241 | + | |
| 1242 | + | |
| 1243 | + | |
| 1244 | + | |
| 1245 | + | |
| 1246 | + | |
| 1247 | + | |
| 1248 | + | |
1238 | 1249 |
| |
1239 | 1250 |
| |
1240 | 1251 |
| |
|
Lines changed: 2 additions & 2 deletions
Original file line number | Diff line number | Diff line change | |
---|---|---|---|
| |||
13969 | 13969 |
| |
13970 | 13970 |
| |
13971 | 13971 |
| |
13972 |
| - | |
| 13972 | + | |
13973 | 13973 |
| |
13974 | 13974 |
| |
13975 | 13975 |
| |
13976 | 13976 |
| |
13977 | 13977 |
| |
13978 | 13978 |
| |
13979 |
| - | |
| 13979 | + | |
13980 | 13980 |
| |
13981 | 13981 |
| |
13982 | 13982 |
| |
|
Lines changed: 20 additions & 7 deletions
Original file line number | Diff line number | Diff line change | |
---|---|---|---|
| |||
636 | 636 |
| |
637 | 637 |
| |
638 | 638 |
| |
639 |
| - | |
640 |
| - | |
| 639 | + | |
| 640 | + | |
641 | 641 |
| |
642 | 642 |
| |
643 | 643 |
| |
| |||
796 | 796 |
| |
797 | 797 |
| |
798 | 798 |
| |
799 |
| - | |
800 |
| - | |
801 |
| - | |
| 799 | + | |
| 800 | + | |
| 801 | + | |
| 802 | + | |
802 | 803 |
| |
| 804 | + | |
| 805 | + | |
| 806 | + | |
| 807 | + | |
| 808 | + | |
| 809 | + | |
| 810 | + | |
| 811 | + | |
| 812 | + | |
| 813 | + | |
| 814 | + | |
| 815 | + | |
803 | 816 |
| |
804 | 817 |
| |
805 | 818 |
| |
806 | 819 |
| |
807 |
| - | |
| 820 | + | |
808 | 821 |
| |
809 | 822 |
| |
810 | 823 |
| |
| |||
823 | 836 |
| |
824 | 837 |
| |
825 | 838 |
| |
826 |
| - | |
| 839 | + | |
827 | 840 |
| |
828 | 841 |
| |
829 | 842 |
| |
|
Lines changed: 4 additions & 1 deletion
Original file line number | Diff line number | Diff line change | |
---|---|---|---|
| |||
31 | 31 |
| |
32 | 32 |
| |
33 | 33 |
| |
| 34 | + | |
34 | 35 |
| |
35 | 36 |
| |
36 | 37 |
| |
| |||
63 | 64 |
| |
64 | 65 |
| |
65 | 66 |
| |
66 |
| - | |
| 67 | + | |
67 | 68 |
| |
68 | 69 |
| |
69 | 70 |
| |
| |||
127 | 128 |
| |
128 | 129 |
| |
129 | 130 |
| |
| 131 | + | |
| 132 | + | |
130 | 133 |
| |
131 | 134 |
| |
132 | 135 |
| |
|
Lines changed: 1 addition & 0 deletions
Original file line number | Diff line number | Diff line change | |
---|---|---|---|
| |||
31 | 31 |
| |
32 | 32 |
| |
33 | 33 |
| |
| 34 | + | |
34 | 35 |
| |
35 | 36 |
| |
36 | 37 |
| |
|
Lines changed: 16 additions & 0 deletions
Original file line number | Diff line number | Diff line change | |
---|---|---|---|
| |||
31 | 31 |
| |
32 | 32 |
| |
33 | 33 |
| |
| 34 | + | |
34 | 35 |
| |
35 | 36 |
| |
36 | 37 |
| |
| |||
174 | 175 |
| |
175 | 176 |
| |
176 | 177 |
| |
| 178 | + | |
| 179 | + | |
| 180 | + | |
| 181 | + | |
| 182 | + | |
| 183 | + | |
| 184 | + | |
| 185 | + | |
| 186 | + | |
| 187 | + | |
| 188 | + | |
| 189 | + | |
| 190 | + | |
| 191 | + | |
| 192 | + | |
177 | 193 |
| |
178 | 194 |
| |
179 | 195 |
| |
|
Lines changed: 1 addition & 0 deletions
Original file line number | Diff line number | Diff line change | |
---|---|---|---|
| |||
31 | 31 |
| |
32 | 32 |
| |
33 | 33 |
| |
| 34 | + | |
34 | 35 |
| |
35 | 36 |
| |
36 | 37 |
| |
|
Lines changed: 4 additions & 4 deletions
Original file line number | Diff line number | Diff line change | |
---|---|---|---|
| |||
8301 | 8301 |
| |
8302 | 8302 |
| |
8303 | 8303 |
| |
8304 |
| - | |
| 8304 | + | |
8305 | 8305 |
| |
8306 | 8306 |
| |
8307 |
| - | |
| 8307 | + | |
8308 | 8308 |
| |
8309 | 8309 |
| |
8310 | 8310 |
| |
| |||
8493 | 8493 |
| |
8494 | 8494 |
| |
8495 | 8495 |
| |
8496 |
| - | |
| 8496 | + | |
8497 | 8497 |
| |
8498 | 8498 |
| |
8499 |
| - | |
| 8499 | + | |
8500 | 8500 |
| |
8501 | 8501 |
| |
8502 | 8502 |
| |
|
Lines changed: 3 additions & 0 deletions
Original file line number | Diff line number | Diff line change | |
---|---|---|---|
| |||
15 | 15 |
| |
16 | 16 |
| |
17 | 17 |
| |
| 18 | + | |
18 | 19 |
| |
19 | 20 |
| |
20 | 21 |
| |
| |||
30 | 31 |
| |
31 | 32 |
| |
32 | 33 |
| |
| 34 | + | |
33 | 35 |
| |
34 | 36 |
| |
35 | 37 |
| |
| |||
54 | 56 |
| |
55 | 57 |
| |
56 | 58 |
| |
| 59 | + | |
57 | 60 |
| |
58 | 61 |
| |
59 | 62 |
| |
|
Lines changed: 46 additions & 0 deletions
Original file line number | Diff line number | Diff line change | |
---|---|---|---|
| |||
94 | 94 |
| |
95 | 95 |
| |
96 | 96 |
| |
| 97 | + | |
97 | 98 |
| |
98 | 99 |
| |
99 | 100 |
| |
| |||
107 | 108 |
| |
108 | 109 |
| |
109 | 110 |
| |
| 111 | + | |
110 | 112 |
| |
111 | 113 |
| |
112 | 114 |
| |
| |||
190 | 192 |
| |
191 | 193 |
| |
192 | 194 |
| |
| 195 | + | |
| 196 | + | |
| 197 | + | |
| 198 | + | |
| 199 | + | |
| 200 | + | |
| 201 | + | |
| 202 | + | |
193 | 203 |
| |
194 | 204 |
| |
195 | 205 |
| |
| |||
247 | 257 |
| |
248 | 258 |
| |
249 | 259 |
| |
| 260 | + | |
| 261 | + | |
250 | 262 |
| |
251 | 263 |
| |
252 | 264 |
| |
| |||
272 | 284 |
| |
273 | 285 |
| |
274 | 286 |
| |
| 287 | + | |
| 288 | + | |
| 289 | + | |
| 290 | + | |
| 291 | + | |
| 292 | + | |
| 293 | + | |
275 | 294 |
| |
276 | 295 |
| |
277 | 296 |
| |
| |||
341 | 360 |
| |
342 | 361 |
| |
343 | 362 |
| |
| 363 | + | |
344 | 364 |
| |
345 | 365 |
| |
346 | 366 |
| |
| |||
439 | 459 |
| |
440 | 460 |
| |
441 | 461 |
| |
| 462 | + | |
442 | 463 |
| |
443 | 464 |
| |
444 | 465 |
| |
| |||
450 | 471 |
| |
451 | 472 |
| |
452 | 473 |
| |
| 474 | + | |
453 | 475 |
| |
454 | 476 |
| |
455 | 477 |
| |
| |||
514 | 536 |
| |
515 | 537 |
| |
516 | 538 |
| |
| 539 | + | |
| 540 | + | |
| 541 | + | |
| 542 | + | |
| 543 | + | |
| 544 | + | |
| 545 | + | |
| 546 | + | |
517 | 547 |
| |
518 | 548 |
| |
519 | 549 |
| |
| |||
556 | 586 |
| |
557 | 587 |
| |
558 | 588 |
| |
| 589 | + | |
| 590 | + | |
559 | 591 |
| |
560 | 592 |
| |
561 | 593 |
| |
| |||
594 | 626 |
| |
595 | 627 |
| |
596 | 628 |
| |
| 629 | + | |
| 630 | + | |
| 631 | + | |
| 632 | + | |
| 633 | + | |
| 634 | + | |
| 635 | + | |
597 | 636 |
| |
598 | 637 |
| |
599 | 638 |
| |
600 | 639 |
| |
601 | 640 |
| |
602 | 641 |
| |
| 642 | + | |
603 | 643 |
| |
604 | 644 |
| |
605 | 645 |
| |
| |||
685 | 725 |
| |
686 | 726 |
| |
687 | 727 |
| |
| 728 | + | |
| 729 | + | |
| 730 | + | |
| 731 | + | |
| 732 | + | |
| 733 | + | |
688 | 734 |
| |
689 | 735 |
| |
690 | 736 |
| |
|
0 commit comments
Comments
(0)