Skip to content

Commit 34469d4

Browse files
committed
[PGPRO-5673] tests.checkdb.CheckdbTest.test_checkdb_with_least_privileges: remove grant for nonexistent (in 9.5) pg_catalog.pg_control_system()
1 parent 0f550d4 commit 34469d4

File tree

2 files changed

+20
-19
lines changed

2 files changed

+20
-19
lines changed

.travis.yml

Lines changed: 20 additions & 18 deletions
Original file line numberDiff line numberDiff line change
@@ -33,13 +33,14 @@ env:
3333
# - PG_VERSION=10 PG_BRANCH=REL_10_STABLE
3434
# - PG_VERSION=9.6 PG_BRANCH=REL9_6_STABLE
3535
# - PG_VERSION=9.5 PG_BRANCH=REL9_5_STABLE
36-
- PG_VERSION=14 PG_BRANCH=REL_14_STABLE MODE=auth_test
37-
- PG_VERSION=13 PG_BRANCH=REL_13_STABLE MODE=auth_test
38-
- PG_VERSION=12 PG_BRANCH=REL_12_STABLE MODE=auth_test
39-
- PG_VERSION=11 PG_BRANCH=REL_11_STABLE MODE=auth_test
40-
- PG_VERSION=10 PG_BRANCH=REL_10_STABLE MODE=auth_test
41-
- PG_VERSION=9.6 PG_BRANCH=REL9_6_STABLE MODE=auth_test
42-
- PG_VERSION=9.5 PG_BRANCH=REL9_5_STABLE MODE=auth_test
36+
37+
# - PG_VERSION=14 PG_BRANCH=REL_14_STABLE MODE=auth_test
38+
# - PG_VERSION=13 PG_BRANCH=REL_13_STABLE MODE=auth_test
39+
# - PG_VERSION=12 PG_BRANCH=REL_12_STABLE MODE=auth_test
40+
# - PG_VERSION=11 PG_BRANCH=REL_11_STABLE MODE=auth_test
41+
# - PG_VERSION=10 PG_BRANCH=REL_10_STABLE MODE=auth_test
42+
# - PG_VERSION=9.6 PG_BRANCH=REL9_6_STABLE MODE=auth_test
43+
# - PG_VERSION=9.5 PG_BRANCH=REL9_5_STABLE MODE=auth_test
4344
- PG_VERSION=14 PG_BRANCH=REL_14_STABLE MODE=backup
4445
- PG_VERSION=13 PG_BRANCH=REL_13_STABLE MODE=backup
4546
- PG_VERSION=12 PG_BRANCH=REL_12_STABLE MODE=backup
@@ -54,17 +55,18 @@ env:
5455
- PG_VERSION=10 PG_BRANCH=REL_10_STABLE MODE=checkdb
5556
- PG_VERSION=9.6 PG_BRANCH=REL9_6_STABLE MODE=checkdb
5657
- PG_VERSION=9.5 PG_BRANCH=REL9_5_STABLE MODE=checkdb
57-
- PG_VERSION=14 PG_BRANCH=REL_14_STABLE MODE=restore
58-
- PG_VERSION=13 PG_BRANCH=REL_13_STABLE MODE=restore
59-
- PG_VERSION=12 PG_BRANCH=REL_12_STABLE MODE=restore
60-
- PG_VERSION=11 PG_BRANCH=REL_11_STABLE MODE=restore
61-
- PG_VERSION=10 PG_BRANCH=REL_10_STABLE MODE=restore
62-
- PG_VERSION=9.6 PG_BRANCH=REL9_6_STABLE MODE=restore
63-
- PG_VERSION=9.5 PG_BRANCH=REL9_5_STABLE MODE=restore
64-
- PG_VERSION=14 PG_BRANCH=REL_14_STABLE MODE=ptrack
65-
- PG_VERSION=13 PG_BRANCH=REL_13_STABLE MODE=ptrack
66-
- PG_VERSION=12 PG_BRANCH=REL_12_STABLE MODE=ptrack
67-
- PG_VERSION=11 PG_BRANCH=REL_11_STABLE MODE=ptrack
58+
# - PG_VERSION=14 PG_BRANCH=REL_14_STABLE MODE=restore
59+
# - PG_VERSION=13 PG_BRANCH=REL_13_STABLE MODE=restore
60+
# - PG_VERSION=12 PG_BRANCH=REL_12_STABLE MODE=restore
61+
# - PG_VERSION=11 PG_BRANCH=REL_11_STABLE MODE=restore
62+
# - PG_VERSION=10 PG_BRANCH=REL_10_STABLE MODE=restore
63+
# - PG_VERSION=9.6 PG_BRANCH=REL9_6_STABLE MODE=restore
64+
# - PG_VERSION=9.5 PG_BRANCH=REL9_5_STABLE MODE=restore
65+
# - PG_VERSION=14 PG_BRANCH=REL_14_STABLE MODE=ptrack
66+
# - PG_VERSION=13 PG_BRANCH=REL_13_STABLE MODE=ptrack
67+
# - PG_VERSION=12 PG_BRANCH=REL_12_STABLE MODE=ptrack
68+
# - PG_VERSION=11 PG_BRANCH=REL_11_STABLE MODE=ptrack
69+
6870
# - PG_VERSION=12 PG_BRANCH=REL_12_STABLE MODE=archive
6971
# - PG_VERSION=12 PG_BRANCH=REL_12_STABLE MODE=backup
7072
# - PG_VERSION=12 PG_BRANCH=REL_12_STABLE MODE=compression

tests/checkdb.py

Lines changed: 0 additions & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -568,7 +568,6 @@ def test_checkdb_with_least_privileges(self):
568568
'GRANT EXECUTE ON FUNCTION pg_catalog.oideq(oid, oid) TO backup; '
569569
'GRANT EXECUTE ON FUNCTION pg_catalog.charne("char", "char") TO backup; '
570570
'GRANT EXECUTE ON FUNCTION pg_catalog.pg_is_in_recovery() TO backup; '
571-
'GRANT EXECUTE ON FUNCTION pg_catalog.pg_control_system() TO backup; '
572571
'GRANT EXECUTE ON FUNCTION bt_index_check(regclass) TO backup; '
573572
'GRANT EXECUTE ON FUNCTION bt_index_check(regclass, bool) TO backup; '
574573
'GRANT EXECUTE ON FUNCTION pg_catalog.set_config(text, text, boolean) TO backup;'

0 commit comments

Comments
 (0)