forked frompostgres/postgres
- Notifications
You must be signed in to change notification settings - Fork6
Commit1922d7c
committed
Add SQL functions to monitor the directory contents of replication slots
This commit adds a set of functions able to look at the contents ofvarious paths related to replication slots:- pg_ls_logicalsnapdir, for pg_logical/snapshots/- pg_ls_logicalmapdir, for pg_logical/mappings/- pg_ls_replslotdir, for pg_replslot/<slot_name>/These are intended to be used by monitoring tools. Unlike pg_ls_dir(),execution permission can be granted to non-superusers. Roles members ofpg_monitor gain have access to those functions.Bump catalog version.Author: Bharath RupireddyReviewed-by: Nathan Bossart, Justin PryzbyDiscussion:https://postgr.es/m/CALj2ACWsfizZjMN6bzzdxOk1ADQQeSw8HhEjhmVXn_Pu+7VzLw@mail.gmail.com1 parentb55f2b6 commit1922d7c
File tree
9 files changed
+250
-1
lines changed- contrib/test_decoding
- expected
- sql
- doc/src/sgml
- src
- backend
- catalog
- utils/adt
- include/catalog
- test/regress
- expected
- sql
9 files changed
+250
-1
lines changedLines changed: 21 additions & 0 deletions
Original file line number | Diff line number | Diff line change | |
---|---|---|---|
| |||
48 | 48 |
| |
49 | 49 |
| |
50 | 50 |
| |
| 51 | + | |
| 52 | + | |
| 53 | + | |
| 54 | + | |
| 55 | + | |
| 56 | + | |
| 57 | + | |
| 58 | + | |
| 59 | + | |
| 60 | + | |
| 61 | + | |
| 62 | + | |
| 63 | + | |
| 64 | + | |
| 65 | + | |
| 66 | + | |
| 67 | + | |
| 68 | + | |
| 69 | + | |
| 70 | + | |
| 71 | + | |
51 | 72 |
| |
52 | 73 |
| |
53 | 74 |
| |
|
Lines changed: 6 additions & 0 deletions
Original file line number | Diff line number | Diff line change | |
---|---|---|---|
| |||
28 | 28 |
| |
29 | 29 |
| |
30 | 30 |
| |
| 31 | + | |
| 32 | + | |
| 33 | + | |
| 34 | + | |
| 35 | + | |
| 36 | + | |
31 | 37 |
| |
32 | 38 |
| |
33 | 39 |
| |
|
Lines changed: 73 additions & 0 deletions
Original file line number | Diff line number | Diff line change | |
---|---|---|---|
| |||
27417 | 27417 |
| |
27418 | 27418 |
| |
27419 | 27419 |
| |
| 27420 | + | |
| 27421 | + | |
| 27422 | + | |
| 27423 | + | |
| 27424 | + | |
| 27425 | + | |
| 27426 | + | |
| 27427 | + | |
| 27428 | + | |
| 27429 | + | |
| 27430 | + | |
| 27431 | + | |
| 27432 | + | |
| 27433 | + | |
| 27434 | + | |
| 27435 | + | |
| 27436 | + | |
| 27437 | + | |
| 27438 | + | |
| 27439 | + | |
| 27440 | + | |
| 27441 | + | |
| 27442 | + | |
| 27443 | + | |
| 27444 | + | |
| 27445 | + | |
| 27446 | + | |
| 27447 | + | |
| 27448 | + | |
| 27449 | + | |
| 27450 | + | |
| 27451 | + | |
| 27452 | + | |
| 27453 | + | |
| 27454 | + | |
| 27455 | + | |
| 27456 | + | |
| 27457 | + | |
| 27458 | + | |
| 27459 | + | |
| 27460 | + | |
| 27461 | + | |
| 27462 | + | |
| 27463 | + | |
| 27464 | + | |
| 27465 | + | |
| 27466 | + | |
| 27467 | + | |
| 27468 | + | |
| 27469 | + | |
| 27470 | + | |
| 27471 | + | |
| 27472 | + | |
| 27473 | + | |
| 27474 | + | |
| 27475 | + | |
| 27476 | + | |
| 27477 | + | |
| 27478 | + | |
| 27479 | + | |
| 27480 | + | |
| 27481 | + | |
| 27482 | + | |
| 27483 | + | |
| 27484 | + | |
| 27485 | + | |
| 27486 | + | |
| 27487 | + | |
| 27488 | + | |
| 27489 | + | |
| 27490 | + | |
| 27491 | + | |
| 27492 | + | |
27420 | 27493 |
| |
27421 | 27494 |
| |
27422 | 27495 |
| |
|
Lines changed: 12 additions & 0 deletions
Original file line number | Diff line number | Diff line change | |
---|---|---|---|
| |||
701 | 701 |
| |
702 | 702 |
| |
703 | 703 |
| |
| 704 | + | |
| 705 | + | |
| 706 | + | |
| 707 | + | |
| 708 | + | |
| 709 | + | |
704 | 710 |
| |
705 | 711 |
| |
706 | 712 |
| |
| |||
715 | 721 |
| |
716 | 722 |
| |
717 | 723 |
| |
| 724 | + | |
| 725 | + | |
| 726 | + | |
| 727 | + | |
| 728 | + | |
| 729 | + | |
718 | 730 |
| |
719 | 731 |
| |
720 | 732 |
| |
|
Lines changed: 44 additions & 0 deletions
Original file line number | Diff line number | Diff line change | |
---|---|---|---|
| |||
29 | 29 |
| |
30 | 30 |
| |
31 | 31 |
| |
| 32 | + | |
32 | 33 |
| |
33 | 34 |
| |
34 | 35 |
| |
| |||
720 | 721 |
| |
721 | 722 |
| |
722 | 723 |
| |
| 724 | + | |
| 725 | + | |
| 726 | + | |
| 727 | + | |
| 728 | + | |
| 729 | + | |
| 730 | + | |
| 731 | + | |
| 732 | + | |
| 733 | + | |
| 734 | + | |
| 735 | + | |
| 736 | + | |
| 737 | + | |
| 738 | + | |
| 739 | + | |
| 740 | + | |
| 741 | + | |
| 742 | + | |
| 743 | + | |
| 744 | + | |
| 745 | + | |
| 746 | + | |
| 747 | + | |
| 748 | + | |
| 749 | + | |
| 750 | + | |
| 751 | + | |
| 752 | + | |
| 753 | + | |
| 754 | + | |
| 755 | + | |
| 756 | + | |
| 757 | + | |
| 758 | + | |
| 759 | + | |
| 760 | + | |
| 761 | + | |
| 762 | + | |
| 763 | + | |
| 764 | + | |
| 765 | + | |
| 766 | + |
Lines changed: 1 addition & 1 deletion
Original file line number | Diff line number | Diff line change | |
---|---|---|---|
| |||
53 | 53 |
| |
54 | 54 |
| |
55 | 55 |
| |
56 |
| - | |
| 56 | + | |
57 | 57 |
| |
58 | 58 |
|
Lines changed: 22 additions & 0 deletions
Original file line number | Diff line number | Diff line change | |
---|---|---|---|
| |||
11623 | 11623 |
| |
11624 | 11624 |
| |
11625 | 11625 |
| |
| 11626 | + | |
| 11627 | + | |
| 11628 | + | |
| 11629 | + | |
| 11630 | + | |
| 11631 | + | |
| 11632 | + | |
| 11633 | + | |
| 11634 | + | |
| 11635 | + | |
| 11636 | + | |
| 11637 | + | |
| 11638 | + | |
| 11639 | + | |
| 11640 | + | |
| 11641 | + | |
| 11642 | + | |
| 11643 | + | |
| 11644 | + | |
| 11645 | + | |
| 11646 | + | |
| 11647 | + | |
11626 | 11648 |
| |
11627 | 11649 |
| |
11628 | 11650 |
| |
|
Lines changed: 50 additions & 0 deletions
Original file line number | Diff line number | Diff line change | |
---|---|---|---|
| |||
243 | 243 |
| |
244 | 244 |
| |
245 | 245 |
| |
| 246 | + | |
| 247 | + | |
| 248 | + | |
| 249 | + | |
| 250 | + | |
| 251 | + | |
| 252 | + | |
| 253 | + | |
| 254 | + | |
| 255 | + | |
| 256 | + | |
| 257 | + | |
| 258 | + | |
| 259 | + | |
| 260 | + | |
| 261 | + | |
| 262 | + | |
| 263 | + | |
| 264 | + | |
| 265 | + | |
| 266 | + | |
| 267 | + | |
| 268 | + | |
| 269 | + | |
| 270 | + | |
| 271 | + | |
| 272 | + | |
| 273 | + | |
| 274 | + | |
| 275 | + | |
| 276 | + | |
| 277 | + | |
| 278 | + | |
| 279 | + | |
| 280 | + | |
| 281 | + | |
| 282 | + | |
| 283 | + | |
| 284 | + | |
| 285 | + | |
| 286 | + | |
| 287 | + | |
| 288 | + | |
| 289 | + | |
| 290 | + | |
| 291 | + | |
| 292 | + | |
| 293 | + | |
| 294 | + | |
| 295 | + | |
246 | 296 |
| |
247 | 297 |
| |
248 | 298 |
| |
|
Lines changed: 21 additions & 0 deletions
Original file line number | Diff line number | Diff line change | |
---|---|---|---|
| |||
91 | 91 |
| |
92 | 92 |
| |
93 | 93 |
| |
| 94 | + | |
| 95 | + | |
| 96 | + | |
| 97 | + | |
| 98 | + | |
| 99 | + | |
| 100 | + | |
| 101 | + | |
| 102 | + | |
| 103 | + | |
| 104 | + | |
| 105 | + | |
| 106 | + | |
| 107 | + | |
| 108 | + | |
| 109 | + | |
| 110 | + | |
| 111 | + | |
| 112 | + | |
| 113 | + | |
| 114 | + | |
94 | 115 |
| |
95 | 116 |
| |
96 | 117 |
| |
|
0 commit comments
Comments
(0)