508 KB
/srv/reproducible-results/rbuild-debian/r-b-build.qY7l4lkL/b1/postgis_3.5.2+dfsg-1_amd64.changes vs.
/srv/reproducible-results/rbuild-debian/r-b-build.qY7l4lkL/b2/postgis_3.5.2+dfsg-1_amd64.changes
943 B
Files
    
Offset 1, 9 lines modifiedOffset 1, 9 lines modified
  
1 ·498aa6928ef65212d5c834604b3c9148·550772·debug·optional·postgis-dbgsym_3.5.2+dfsg-1_amd64.deb1 ·498aa6928ef65212d5c834604b3c9148·550772·debug·optional·postgis-dbgsym_3.5.2+dfsg-1_amd64.deb
2 ·7f9155ce6b089ff240e14d566489e93a·3079136·doc·optional·postgis-doc_3.5.2+dfsg-1_all.deb2 ·7f9155ce6b089ff240e14d566489e93a·3079136·doc·optional·postgis-doc_3.5.2+dfsg-1_all.deb
3 ·39a9f98839a253a462f96d7cc9fc5a3b·153608·misc·optional·postgis_3.5.2+dfsg-1_amd64.deb3 ·39a9f98839a253a462f96d7cc9fc5a3b·153608·misc·optional·postgis_3.5.2+dfsg-1_amd64.deb
4 ·3324a79a9eded8a075bcc2c003dc56f4·4349748·debug·optional·postgresql-17-postgis-3-dbgsym_3.5.2+dfsg-1_amd64.deb4 ·3324a79a9eded8a075bcc2c003dc56f4·4349748·debug·optional·postgresql-17-postgis-3-dbgsym_3.5.2+dfsg-1_amd64.deb
5 ·7a4268239d9e9ae84fef597f482a77e1·1278276·misc·optional·postgresql-17-postgis-3-scripts_3.5.2+dfsg-1_all.deb5 ·9d44ebba049f09f646037e99a69d4e6f·1275708·misc·optional·postgresql-17-postgis-3-scripts_3.5.2+dfsg-1_all.deb
6 ·81f6fbfc84655d4dba9f1339e179316e·3599160·misc·optional·postgresql-17-postgis-3_3.5.2+dfsg-1_amd64.deb6 ·81f6fbfc84655d4dba9f1339e179316e·3599160·misc·optional·postgresql-17-postgis-3_3.5.2+dfsg-1_amd64.deb
7 ·b9dabb5fad3251994de7a0d489ddbe76·20968·misc·optional·postgresql-postgis-scripts_3.5.2+dfsg-1_all.deb7 ·b9dabb5fad3251994de7a0d489ddbe76·20968·misc·optional·postgresql-postgis-scripts_3.5.2+dfsg-1_all.deb
8 ·e189dabef517e781fabb883f7d9ee0ed·20944·metapackages·optional·postgresql-postgis_3.5.2+dfsg-1_amd64.deb8 ·e189dabef517e781fabb883f7d9ee0ed·20944·metapackages·optional·postgresql-postgis_3.5.2+dfsg-1_amd64.deb
507 KB
postgresql-17-postgis-3-scripts_3.5.2+dfsg-1_all.deb
452 B
file list
    
Offset 1, 3 lines modifiedOffset 1, 3 lines modified
1 -rw-r--r--···0········0········0········4·2025-01-19·06:35:59.000000·debian-binary1 -rw-r--r--···0········0········0········4·2025-01-19·06:35:59.000000·debian-binary
2 -rw-r--r--···0········0········0·····2720·2025-01-19·06:35:59.000000·control.tar.xz2 -rw-r--r--···0········0········0·····2724·2025-01-19·06:35:59.000000·control.tar.xz
3 -rw-r--r--···0········0········0··1275364·2025-01-19·06:35:59.000000·data.tar.xz3 -rw-r--r--···0········0········0··1272792·2025-01-19·06:35:59.000000·data.tar.xz
595 B
control.tar.xz
567 B
control.tar
497 B
./control
    
Offset 1, 13 lines modifiedOffset 1, 13 lines modified
1 Package:·postgresql-17-postgis-3-scripts1 Package:·postgresql-17-postgis-3-scripts
2 Source:·postgis2 Source:·postgis
3 Version:·3.5.2+dfsg-13 Version:·3.5.2+dfsg-1
4 Architecture:·all4 Architecture:·all
5 Maintainer:·Debian·GIS·Project·<pkg-grass-devel@lists.alioth.debian.org>5 Maintainer:·Debian·GIS·Project·<pkg-grass-devel@lists.alioth.debian.org>
6 Installed-Size:·385566 Installed-Size:·38064
7 Recommends:·postgresql-17-postgis-37 Recommends:·postgresql-17-postgis-3
8 Provides:·postgresql-17-postgis-scripts8 Provides:·postgresql-17-postgis-scripts
9 Section:·misc9 Section:·misc
10 Priority:·optional10 Priority:·optional
11 Multi-Arch:·foreign11 Multi-Arch:·foreign
12 Homepage:·https://postgis.net/12 Homepage:·https://postgis.net/
13 Description:·Geographic·objects·support·for·PostgreSQL·17·--·SQL·scripts13 Description:·Geographic·objects·support·for·PostgreSQL·17·--·SQL·scripts
48.0 B
./md5sums
30.0 B
./md5sums
Files differ
506 KB
data.tar.xz
506 KB
data.tar
2.53 KB
file list
    
Offset 40, 15 lines modifiedOffset 40, 15 lines modified
40 -rw-r--r--···0·root·········(0)·root·········(0)·····2027·2025-01-19·06:35:59.000000·./usr/share/postgresql/17/extension/address_standardizer--3.5.2.sql40 -rw-r--r--···0·root·········(0)·root·········(0)·····2027·2025-01-19·06:35:59.000000·./usr/share/postgresql/17/extension/address_standardizer--3.5.2.sql
41 -rw-r--r--···0·root·········(0)·root·········(0)·····1511·2025-01-19·06:35:59.000000·./usr/share/postgresql/17/extension/address_standardizer--ANY--3.5.2.sql41 -rw-r--r--···0·root·········(0)·root·········(0)·····1511·2025-01-19·06:35:59.000000·./usr/share/postgresql/17/extension/address_standardizer--ANY--3.5.2.sql
42 -rw-r--r--···0·root·········(0)·root·········(0)······135·2025-01-19·06:35:59.000000·./usr/share/postgresql/17/extension/address_standardizer--TEMPLATED--TO--ANY.sql42 -rw-r--r--···0·root·········(0)·root·········(0)······135·2025-01-19·06:35:59.000000·./usr/share/postgresql/17/extension/address_standardizer--TEMPLATED--TO--ANY.sql
43 -rw-r--r--···0·root·········(0)·root·········(0)······206·2025-01-19·06:35:59.000000·./usr/share/postgresql/17/extension/address_standardizer-3.control43 -rw-r--r--···0·root·········(0)·root·········(0)······206·2025-01-19·06:35:59.000000·./usr/share/postgresql/17/extension/address_standardizer-3.control
44 -rw-r--r--···0·root·········(0)·root·········(0)···505113·2025-01-19·06:35:59.000000·./usr/share/postgresql/17/extension/address_standardizer_data_us--3.5.2--3.5.2next.sql44 -rw-r--r--···0·root·········(0)·root·········(0)···505113·2025-01-19·06:35:59.000000·./usr/share/postgresql/17/extension/address_standardizer_data_us--3.5.2--3.5.2next.sql
45 -rw-r--r--···0·root·········(0)·root·········(0)···505113·2025-01-19·06:35:59.000000·./usr/share/postgresql/17/extension/address_standardizer_data_us--3.5.2.sql45 -rw-r--r--···0·root·········(0)·root·········(0)···505113·2025-01-19·06:35:59.000000·./usr/share/postgresql/17/extension/address_standardizer_data_us--3.5.2.sql
46 -rw-r--r--···0·root·········(0)·root·········(0)···505113·2025-01-19·06:35:59.000000·./usr/share/postgresql/17/extension/address_standardizer_data_us--3.5.2next--3.5.2.sql46 -rw-r--r--···0·root·········(0)·root·········(0)···505113·2025-01-19·06:35:59.000000·./usr/share/postgresql/17/extension/address_standardizer_data_us--3.5.2next--3.5.2.sql
47 -rw-r--r--···0·root·········(0)·root·········(0)···505113·2025-01-19·06:35:59.000000·./usr/share/postgresql/17/extension/address_standardizer_data_us--ANY--3.5.2.sql47 -rw-r--r--···0·root·········(0)·root·········(0)·····1511·2025-01-19·06:35:59.000000·./usr/share/postgresql/17/extension/address_standardizer_data_us--ANY--3.5.2.sql
48 -rw-r--r--···0·root·········(0)·root·········(0)······151·2025-01-19·06:35:59.000000·./usr/share/postgresql/17/extension/address_standardizer_data_us--TEMPLATED--TO--ANY.sql48 -rw-r--r--···0·root·········(0)·root·········(0)······151·2025-01-19·06:35:59.000000·./usr/share/postgresql/17/extension/address_standardizer_data_us--TEMPLATED--TO--ANY.sql
49 -rw-r--r--···0·root·········(0)·root·········(0)······131·2025-01-19·06:35:59.000000·./usr/share/postgresql/17/extension/address_standardizer_data_us-3.control49 -rw-r--r--···0·root·········(0)·root·········(0)······131·2025-01-19·06:35:59.000000·./usr/share/postgresql/17/extension/address_standardizer_data_us-3.control
50 -rw-r--r--···0·root·········(0)·root·········(0)··7477406·2025-01-19·06:35:59.000000·./usr/share/postgresql/17/extension/postgis--3.5.2.sql50 -rw-r--r--···0·root·········(0)·root·········(0)··7477406·2025-01-19·06:35:59.000000·./usr/share/postgresql/17/extension/postgis--3.5.2.sql
51 -rw-r--r--···0·root·········(0)·root·········(0)··7848564·2025-01-19·06:35:59.000000·./usr/share/postgresql/17/extension/postgis--ANY--3.5.2.sql51 -rw-r--r--···0·root·········(0)·root·········(0)··7848564·2025-01-19·06:35:59.000000·./usr/share/postgresql/17/extension/postgis--ANY--3.5.2.sql
52 -rw-r--r--···0·root·········(0)·root·········(0)······109·2025-01-19·06:35:59.000000·./usr/share/postgresql/17/extension/postgis--TEMPLATED--TO--ANY.sql52 -rw-r--r--···0·root·········(0)·root·········(0)······109·2025-01-19·06:35:59.000000·./usr/share/postgresql/17/extension/postgis--TEMPLATED--TO--ANY.sql
53 -rw-r--r--···0·root·········(0)·root·········(0)··7928826·2025-01-19·06:35:59.000000·./usr/share/postgresql/17/extension/postgis--unpackaged--3.5.2.sql53 -rw-r--r--···0·root·········(0)·root·········(0)··7928826·2025-01-19·06:35:59.000000·./usr/share/postgresql/17/extension/postgis--unpackaged--3.5.2.sql
54 -rw-r--r--···0·root·········(0)·root·········(0)·······22·2025-01-19·06:35:59.000000·./usr/share/postgresql/17/extension/postgis--unpackaged.sql54 -rw-r--r--···0·root·········(0)·root·········(0)·······22·2025-01-19·06:35:59.000000·./usr/share/postgresql/17/extension/postgis--unpackaged.sql
503 KB
./usr/share/postgresql/17/extension/address_standardizer_data_us--ANY--3.5.2.sql
    
Offset 1, 8438 lines modifiedOffset 1, 60 lines modified
1 CREATE·TABLE·IF·NOT·EXISTS·us_lex·( 
2 »       id·serial, 
3 ····seq·integer, 
4 ····word·text, 
5 ····stdword·text, 
6 ····token·integer,·is_custom·boolean·NOT·NULL·DEFAULT·true,·CONSTRAINT·pk_us_lex·PRIMARY·KEY(id) 
7 ); 
  
8 --·this·will·be·needed·for·upgrading·to·prevent·purging·of·custom·entries 
9 DELETE·FROM·us_lex·WHERE·is_custom·=·false; 
  
10 --·needed·so·entries·we·add·will·default·to·not·custom 
11 ALTER·TABLE·us_lex·ALTER·COLUMN·is_custom·SET·DEFAULT·false; 
  
12 INSERT·INTO·us_lex·(seq,·word,·stdword,·token) 
13 WITH·t(seq,word,stdword,token)·AS·(·VALUES·(1,·'#',·'#',·16), 
14 (2,·'#',·'#',·7), 
15 (1,·'&',·'AND',·13), 
16 (2,·'&',·'AND',·1), 
17 (3,·'&',·'AND',·7), 
18 (1,·'-',·'-',·9), 
19 (1,·'1·/·2',·'1/2',·25), 
20 (1,·'1·/·2·MILE',·'1/2·MI',·1), 
21 (1,·'1·/·3',·'1/3',·25), 
22 (1,·'1·/·4',·'1/4',·25), 
23 (1,·'1·MI',·'ONE·MILE',·1), 
24 (1,·'1·MILE',·'ONE·MILE',·1), 
25 (1,·'1/2',·'1/2',·25), 
26 (1,·'1/2·MILE',·'1/2·MI',·1), 
27 (1,·'1/3',·'1/3',·25), 
28 (1,·'1/4',·'1/4',·25), 
29 (1,·'10·MI',·'TEN·MILE',·1), 
30 (1,·'10·MILE',·'TEN·MILE',·1), 
31 (1,·'10MI',·'TEN·MILE',·1), 
32 (1,·'100·MILE',·'ONE·HUNDRED·MILE',·1), 
33 (1,·'11·MI',·'ELEVEN·MILE',·1), 
34 (1,·'11·MILE',·'ELEVEN·MILE',·1), 
35 (1,·'11MI',·'ELEVEN·MILE',·1), 
36 (1,·'12·MI',·'TWELVE·MILE',·1), 
37 (1,·'12·MILE',·'TWELVE·MILE',·1), 
38 (1,·'12MI',·'TWELVE·MILE',·1), 
39 (1,·'13·MI',·'THIRTEEN·MILE',·1), 
40 (1,·'13·MILE',·'THIRTEEN·MILE',·1), 
41 (1,·'13MI',·'THIRTEEN·MILE',·1), 
42 (1,·'14·MI',·'FOURTEEN·MILE',·1), 
43 (1,·'14·MILE',·'FOURTEEN·MILE',·1), 
44 (1,·'14MI',·'FOURTEEN·MILE',·1), 
45 (1,·'15·MI',·'FIFTEEN·MI',·1), 
46 (1,·'15·MILE',·'FIFTEEN·MI',·1), 
47 (1,·'15MI',·'FIFTEEN·MI',·1), 
48 (1,·'16·MI',·'SIXTEEN·MILE',·1), 
49 (1,·'16·MILE',·'SIXTEEN·MILE',·1), 
50 (1,·'16MI',·'SIXTEEN·MILE',·1), 
51 (1,·'17·MI',·'SEVENTEEN·MILE',·1), 
52 (1,·'17·MILE',·'SEVENTEEN·MILE',·1), 
53 (1,·'17MI',·'SEVENTEEN·MILE',·1), 
54 (1,·'18·MI',·'EIGHTEEEN·MILE',·1), 
55 (1,·'18·MILE',·'EIGHTEEEN·MILE',·1), 
56 (1,·'18MI',·'EIGHTEEEN·MILE',·1), 
57 (1,·'19·MI',·'NINETEEN·MILE',·1), 
58 (1,·'19·MILE',·'NINETEEN·MILE',·1), 
59 (1,·'19MI',·'NINETEEN·MILE',·1), 
60 (1,·'1ER',·'PREMIERE',·1), 
61 (1,·'1ER',·'1',·15), 
62 (1,·'1MI',·'ONE·MILE',·1), 
63 (1,·'1RE',·'PREMIERE',·1), 
64 (1,·'1RE',·'1',·15), 
65 (1,·'1ST',·'1',·1), 
66 (2,·'1ST',·'1',·15), 
67 (1,·'2·MI',·'TWO·MILE',·1), 
68 (1,·'2·MILE',·'TWO·MILE',·1), 
69 (1,·'20·MI',·'TWENTY·MILE',·1), 
70 (1,·'20·MILE',·'TWENTY·MILE',·1), 
71 (1,·'20MI',·'TWENTY·MILE',·1), 
72 (1,·'21ST',·'21',·1), 
73 (2,·'21ST',·'21',·15), 
74 (1,·'22ND',·'22',·1), 
75 (2,·'22ND',·'22',·15), 
76 (1,·'23·MI',·'TWENTY·THREE·MILE',·1), 
77 (1,·'23·MILE',·'TWENTY·THREE·MILE',·1), 
78 (1,·'23MI',·'TWENTY·THREE·MILE',·1), 
79 (1,·'23RD',·'23',·1), 
80 (2,·'23RD',·'23',·15), 
81 (1,·'2MI',·'TWO·MILE',·1), 
82 (1,·'3·/·4',·'3/4',·25), 
83 (1,·'3·/·8',·'3/8',·25), 
84 (1,·'3·MI',·'THREE·MILE',·1), 
85 (1,·'3·MILE',·'THREE·MILE',·1), 
86 (1,·'3/4',·'3/4',·25), 
87 (1,·'3/8',·'3/8',·25), 
88 (1,·'31ST',·'31',·1), 
89 (2,·'31ST',·'31',·15), 
90 (1,·'33RD',·'33',·1), 
91 (2,·'33RD',·'33',·15), 
92 (1,·'3MI',·'THREE·MILE',·1), 
93 (1,·'3RD',·'3',·1), 
94 (2,·'3RD',·'3',·15), 
95 (1,·'4·CORNERS',·'FOUR·CORNERS',·1), 
96 (1,·'4·FG',·'FOUR·FLAGS',·1), 
97 (1,·'4·FLAGS',·'FOUR·FLAGS',·1), 
98 (1,·'4·MI',·'FOUR·MILE',·1), 
99 (1,·'4·MILE',·'FOUR·MILE',·1), 
100 (1,·'4·SEASONS',·'FOUR·SEASONS',·1), 
101 (1,·'4·SN',·'FOUR·SEASONS',·1), 
102 (1,·'41ST',·'41',·1), 
103 (2,·'41ST',·'41',·15), 
104 (1,·'43RD',·'43',·1), 
105 (2,·'43RD',·'43',·15), 
106 (1,·'4MI',·'FOUR·MILE',·1), 
107 (1,·'4WD',·'FOUR·WHEEL·DRIVE·TRAIL',·2), 
108 (1,·'4WD·TRAIL',·'FOUR·WHEEL·DRIVE·TRAIL',·2), 
109 (1,·'4WD·TRL',·'FOUR·WHEEL·DRIVE·TRAIL',·2), 
110 (1,·'5·CEDARS',·'FIVE·CEDARS',·1), 
111 (1,·'5·CORNERS',·'FIVE·CORNERS',·1), 
112 (1,·'5·MI',·'FIVE·MILE',·1), 
113 (1,·'5·MILE',·'FIVE·MILE',·1), 
114 (1,·'5·POINTS',·'FIVE·POINTS',·1), 
115 (1,·'5·PT',·'FIVE·POINTS',·1), 
116 (1,·'5·TO',·'FIVE·TOWN',·1), 
117 (1,·'51ST',·'51',·1), 
118 (2,·'51ST',·'51',·15), 
119 (1,·'53RD',·'53',·1), 
120 (2,·'53RD',·'53',·15), 
121 (1,·'5MI',·'FIVE·MILE',·1), 
122 (1,·'6·FG',·'SIX·FLAGS',·1), 
123 (1,·'6·FLAGS',·'SIX·FLAGS',·1), 
124 (1,·'6·MI',·'SIX·MILE',·1), 
Max diff block lines reached; 423199/515118 bytes (82.16%) of diff not shown.