1515
1616class PtrackTest (ProbackupTest ,unittest .TestCase ):
1717
18+ # @unittest.skip("skip")
19+ def test_ptrack_stop_pg (self ):
20+ """
21+ create node, take full backup,
22+ restart node, check that ptrack backup
23+ can be taken
24+ """
25+ fname = self .id ().split ('.' )[3 ]
26+ backup_dir = os .path .join (self .tmp_path ,module_name ,fname ,'backup' )
27+ node = self .make_simple_node (
28+ base_dir = os .path .join (module_name ,fname ,'node' ),
29+ set_replication = True ,
30+ ptrack_enable = True ,
31+ initdb_params = ['--data-checksums' ])
32+
33+ self .init_pb (backup_dir )
34+ self .add_instance (backup_dir ,'node' ,node )
35+ node .slow_start ()
36+
37+ if node .major_version >= 11 :
38+ node .safe_psql (
39+ "postgres" ,
40+ "CREATE EXTENSION ptrack" )
41+
42+ node .pgbench_init (scale = 1 )
43+
44+ # FULL backup
45+ self .backup_node (backup_dir ,'node' ,node ,options = ['--stream' ])
46+
47+ node .stop ()
48+ node .slow_start ()
49+
50+ self .backup_node (
51+ backup_dir ,'node' ,node ,
52+ backup_type = 'ptrack' ,options = ['--stream' ])
53+
54+ # Clean after yourself
55+ self .del_test_dir (module_name ,fname )
56+
1857# @unittest.skip("skip")
1958def test_ptrack_eat_my_data (self ):
2059"""
@@ -33,7 +72,7 @@ def test_ptrack_eat_my_data(self):
3372self .set_archiving (backup_dir ,'node' ,node )
3473node .slow_start ()
3574
36- if node .major_version >= 12 :
75+ if node .major_version >= 11 :
3776node .safe_psql (
3877"postgres" ,
3978"CREATE EXTENSION ptrack" )
@@ -113,7 +152,7 @@ def test_ptrack_simple(self):
113152self .add_instance (backup_dir ,'node' ,node )
114153node .slow_start ()
115154
116- if node .major_version >= 12 :
155+ if node .major_version >= 11 :
117156node .safe_psql (
118157"postgres" ,
119158"CREATE EXTENSION ptrack" )
@@ -357,7 +396,7 @@ def test_ptrack_enable(self):
357396self .add_instance (backup_dir ,'node' ,node )
358397node .slow_start ()
359398
360- if node .major_version >= 12 :
399+ if node .major_version >= 11 :
361400node .safe_psql (
362401"postgres" ,
363402"CREATE EXTENSION ptrack" )
@@ -408,7 +447,7 @@ def test_ptrack_disable(self):
408447self .add_instance (backup_dir ,'node' ,node )
409448node .slow_start ()
410449
411- if node .major_version >= 12 :
450+ if node .major_version >= 11 :
412451node .safe_psql (
413452"postgres" ,
414453"CREATE EXTENSION ptrack" )
@@ -417,15 +456,15 @@ def test_ptrack_disable(self):
417456self .backup_node (backup_dir ,'node' ,node ,options = ['--stream' ])
418457
419458# DISABLE PTRACK
420- if node .major_version >= 12 :
459+ if node .major_version >= 11 :
421460node .safe_psql ('postgres' ,"alter system set ptrack.map_size to 0" )
422461else :
423462node .safe_psql ('postgres' ,"alter system set ptrack_enable to off" )
424463node .stop ()
425464node .slow_start ()
426465
427466# ENABLE PTRACK
428- if node .major_version >= 12 :
467+ if node .major_version >= 11 :
429468node .safe_psql ('postgres' ,"alter system set ptrack.map_size to '128'" )
430469node .safe_psql ('postgres' ,"alter system set shared_preload_libraries to 'ptrack'" )
431470else :
@@ -478,7 +517,7 @@ def test_ptrack_uncommitted_xact(self):
478517self .add_instance (backup_dir ,'node' ,node )
479518node .slow_start ()
480519
481- if node .major_version >= 12 :
520+ if node .major_version >= 11 :
482521node .safe_psql (
483522"postgres" ,
484523"CREATE EXTENSION ptrack" )
@@ -539,7 +578,7 @@ def test_ptrack_vacuum_full(self):
539578
540579self .create_tblspace_in_node (node ,'somedata' )
541580
542- if node .major_version >= 12 :
581+ if node .major_version >= 11 :
543582node .safe_psql (
544583"postgres" ,
545584"CREATE EXTENSION ptrack" )
@@ -629,7 +668,7 @@ def test_ptrack_vacuum_truncate(self):
629668
630669self .create_tblspace_in_node (node ,'somedata' )
631670
632- if node .major_version >= 12 :
671+ if node .major_version >= 11 :
633672node .safe_psql (
634673"postgres" ,
635674"CREATE EXTENSION ptrack" )
@@ -710,7 +749,7 @@ def test_ptrack_get_block(self):
710749self .add_instance (backup_dir ,'node' ,node )
711750node .slow_start ()
712751
713- if node .major_version >= 12 :
752+ if node .major_version >= 11 :
714753self .skipTest ("skip --- we do not need ptrack_get_block for ptrack 2.*" )
715754node .safe_psql (
716755"postgres" ,
@@ -786,7 +825,7 @@ def test_ptrack_stream(self):
786825self .add_instance (backup_dir ,'node' ,node )
787826node .slow_start ()
788827
789- if node .major_version >= 12 :
828+ if node .major_version >= 11 :
790829node .safe_psql (
791830"postgres" ,
792831"CREATE EXTENSION ptrack" )
@@ -879,7 +918,7 @@ def test_ptrack_archive(self):
879918self .set_archiving (backup_dir ,'node' ,node )
880919node .slow_start ()
881920
882- if node .major_version >= 12 :
921+ if node .major_version >= 11 :
883922node .safe_psql (
884923"postgres" ,
885924"CREATE EXTENSION ptrack" )
@@ -1215,7 +1254,7 @@ def test_create_db(self):
12151254self .add_instance (backup_dir ,'node' ,node )
12161255node .slow_start ()
12171256
1218- if node .major_version >= 12 :
1257+ if node .major_version >= 11 :
12191258node .safe_psql (
12201259"postgres" ,
12211260"CREATE EXTENSION ptrack" )
@@ -1335,7 +1374,7 @@ def test_create_db_on_replica(self):
13351374self .add_instance (backup_dir ,'node' ,node )
13361375node .slow_start ()
13371376
1338- if node .major_version >= 12 :
1377+ if node .major_version >= 11 :
13391378node .safe_psql (
13401379"postgres" ,
13411380"CREATE EXTENSION ptrack" )
@@ -1435,7 +1474,7 @@ def test_alter_table_set_tablespace_ptrack(self):
14351474self .add_instance (backup_dir ,'node' ,node )
14361475node .slow_start ()
14371476
1438- if node .major_version >= 12 :
1477+ if node .major_version >= 11 :
14391478node .safe_psql (
14401479"postgres" ,
14411480"CREATE EXTENSION ptrack" )
@@ -1529,7 +1568,7 @@ def test_alter_database_set_tablespace_ptrack(self):
15291568self .add_instance (backup_dir ,'node' ,node )
15301569node .slow_start ()
15311570
1532- if node .major_version >= 12 :
1571+ if node .major_version >= 11 :
15331572node .safe_psql (
15341573"postgres" ,
15351574"CREATE EXTENSION ptrack" )
@@ -1601,7 +1640,7 @@ def test_drop_tablespace(self):
16011640self .add_instance (backup_dir ,'node' ,node )
16021641node .slow_start ()
16031642
1604- if node .major_version >= 12 :
1643+ if node .major_version >= 11 :
16051644node .safe_psql (
16061645"postgres" ,
16071646"CREATE EXTENSION ptrack" )
@@ -1698,7 +1737,7 @@ def test_ptrack_alter_tablespace(self):
16981737self .add_instance (backup_dir ,'node' ,node )
16991738node .slow_start ()
17001739
1701- if node .major_version >= 12 :
1740+ if node .major_version >= 11 :
17021741node .safe_psql (
17031742"postgres" ,
17041743"CREATE EXTENSION ptrack" )
@@ -1816,7 +1855,7 @@ def test_ptrack_multiple_segments(self):
18161855self .add_instance (backup_dir ,'node' ,node )
18171856node .slow_start ()
18181857
1819- if node .major_version >= 12 :
1858+ if node .major_version >= 11 :
18201859node .safe_psql (
18211860"postgres" ,
18221861"CREATE EXTENSION ptrack" )
@@ -2233,7 +2272,7 @@ def test_ptrack_cluster_on_btree(self):
22332272self .add_instance (backup_dir ,'node' ,node )
22342273node .slow_start ()
22352274
2236- if node .major_version >= 12 :
2275+ if node .major_version >= 11 :
22372276node .safe_psql (
22382277"postgres" ,
22392278"CREATE EXTENSION ptrack" )
@@ -2298,7 +2337,7 @@ def test_ptrack_cluster_on_gist(self):
22982337self .add_instance (backup_dir ,'node' ,node )
22992338node .slow_start ()
23002339
2301- if node .major_version >= 12 :
2340+ if node .major_version >= 11 :
23022341node .safe_psql (
23032342"postgres" ,
23042343"CREATE EXTENSION ptrack" )
@@ -2546,7 +2585,7 @@ def test_ptrack_empty(self):
25462585self .add_instance (backup_dir ,'node' ,node )
25472586node .slow_start ()
25482587
2549- if node .major_version >= 12 :
2588+ if node .major_version >= 11 :
25502589node .safe_psql (
25512590"postgres" ,
25522591"CREATE EXTENSION ptrack" )
@@ -2722,7 +2761,7 @@ def test_ptrack_truncate(self):
27222761self .add_instance (backup_dir ,'node' ,node )
27232762node .slow_start ()
27242763
2725- if node .major_version >= 12 :
2764+ if node .major_version >= 11 :
27262765node .safe_psql (
27272766"postgres" ,
27282767"CREATE EXTENSION ptrack" )
@@ -2916,7 +2955,7 @@ def test_ptrack_vacuum(self):
29162955self .add_instance (backup_dir ,'node' ,node )
29172956node .slow_start ()
29182957
2919- if node .major_version >= 12 :
2958+ if node .major_version >= 11 :
29202959node .safe_psql (
29212960"postgres" ,
29222961"CREATE EXTENSION ptrack" )
@@ -3112,7 +3151,7 @@ def test_ptrack_vacuum_bits_frozen(self):
31123151self .add_instance (backup_dir ,'node' ,node )
31133152node .slow_start ()
31143153
3115- if node .major_version >= 12 :
3154+ if node .major_version >= 11 :
31163155node .safe_psql (
31173156"postgres" ,
31183157"CREATE EXTENSION ptrack" )
@@ -3291,7 +3330,7 @@ def test_ptrack_vacuum_bits_visibility(self):
32913330self .add_instance (backup_dir ,'node' ,node )
32923331node .slow_start ()
32933332
3294- if node .major_version >= 12 :
3333+ if node .major_version >= 11 :
32953334node .safe_psql (
32963335"postgres" ,
32973336"CREATE EXTENSION ptrack" )
@@ -3370,7 +3409,7 @@ def test_ptrack_vacuum_full(self):
33703409self .add_instance (backup_dir ,'node' ,node )
33713410node .slow_start ()
33723411
3373- if node .major_version >= 12 :
3412+ if node .major_version >= 11 :
33743413node .safe_psql (
33753414"postgres" ,
33763415"CREATE EXTENSION ptrack" )
@@ -3553,7 +3592,7 @@ def test_ptrack_vacuum_truncate(self):
35533592self .add_instance (backup_dir ,'node' ,node )
35543593node .slow_start ()
35553594
3556- if node .major_version >= 12 :
3595+ if node .major_version >= 11 :
35573596node .safe_psql (
35583597"postgres" ,
35593598"CREATE EXTENSION ptrack" )
@@ -3891,7 +3930,7 @@ def test_ptrack_zero_changes(self):
38913930self .add_instance (backup_dir ,'node' ,node )
38923931node .slow_start ()
38933932
3894- if node .major_version >= 12 :
3933+ if node .major_version >= 11 :
38953934node .safe_psql (
38963935"postgres" ,
38973936"CREATE EXTENSION ptrack" )
@@ -3941,7 +3980,7 @@ def test_ptrack_pg_resetxlog(self):
39413980self .add_instance (backup_dir ,'node' ,node )
39423981node .slow_start ()
39433982
3944- if node .major_version >= 12 :
3983+ if node .major_version >= 11 :
39453984node .safe_psql (
39463985"postgres" ,
39473986"CREATE EXTENSION ptrack" )
@@ -4067,7 +4106,7 @@ def test_corrupt_ptrack_map(self):
40674106self .add_instance (backup_dir ,'node' ,node )
40684107node .slow_start ()
40694108
4070- if node .major_version >= 12 :
4109+ if node .major_version >= 11 :
40714110node .safe_psql (
40724111"postgres" ,
40734112"CREATE EXTENSION ptrack" )