<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body>
Not sure if this one got through due to attachments, so I am
re-sending without them.<br>
<br>
--<br>
Mario.<br>
<div class="moz-signature"><br>
<br>
</div>
<div class="moz-cite-prefix">On 12/17/20 5:46 PM, Mario Pranjic
wrote:<br>
</div>
<blockquote type="cite"
cite="mid:100bdffe-0b02-9c7e-fdc7-2ed743c6eb4a@pranjic.no">
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
OK, very quick comparrison:<br>
<br>
9.6.7 -> 26 tables<br>
11.0 -> 32 tables<br>
<br>
One can see by owner new/changed tables in v11 (postgres dbuser
was used when running dbupgrade script):<br>
<br>
On version 9.6.7:<br>
<font face="monospace">bacula=# \dt<br>
List of relations<br>
Schema | Name | Type | Owner <br>
--------+----------------+-------+--------<br>
public | basefiles | table | bacula<br>
public | cdimages | table | bacula<br>
public | client | table | bacula<br>
public | counters | table | bacula<br>
public | device | table | bacula<br>
public | file | table | bacula<br>
<b>public | filename | table | bacula</b><br>
public | fileset | table | bacula<br>
public | job | table | bacula<br>
public | jobhisto | table | bacula<br>
public | jobmedia | table | bacula<br>
public | location | table | bacula<br>
public | locationlog | table | bacula<br>
public | log | table | bacula<br>
public | media | table | bacula<br>
public | mediatype | table | bacula<br>
public | path | table | bacula<br>
public | pathhierarchy | table | bacula<br>
public | pathvisibility | table | bacula<br>
public | pool | table | bacula<br>
public | restoreobject | table | bacula<br>
public | snapshot | table | bacula<br>
public | status | table | bacula<br>
public | storage | table | bacula<br>
public | unsavedfiles | table | bacula<br>
public | version | table | bacula<br>
(26 rows)</font><br>
<br>
On version 11.0:<br>
<font face="monospace">baculatest=# \dt<br>
List of relations<br>
Schema | Name | Type | Owner <br>
--------+----------------+-------+----------<br>
public | basefiles | table | bacula<br>
public | cdimages | table | bacula<br>
public | client | table | bacula<br>
public | counters | table | bacula<br>
public | device | table | bacula<br>
<b> public | events | table | postgres</b><b><br>
</b><b> public | file | table | postgres</b><b><br>
</b><b> public | filemedia | table | postgres</b><br>
public | fileset | table | bacula<br>
public | job | table | bacula<br>
public | jobhisto | table | bacula<br>
public | jobmedia | table | bacula<br>
public | location | table | bacula<br>
public | locationlog | table | bacula<br>
public | log | table | bacula<br>
public | media | table | bacula<br>
public | mediatype | table | bacula<br>
<b> public | object | table | postgres</b><br>
public | path | table | bacula<br>
public | pathhierarchy | table | bacula<br>
public | pathvisibility | table | bacula<br>
public | pool | table | bacula<br>
public | restoreobject | table | bacula<br>
public | snapshot | table | bacula<br>
public | status | table | bacula<br>
public | storage | table | bacula<br>
<b> public | tagclient | table | postgres</b><b><br>
</b><b> public | tagjob | table | postgres</b><b><br>
</b><b> public | tagmedia | table | postgres</b><b><br>
</b><b> public | tagobject | table | postgres</b><br>
public | unsavedfiles | table | bacula<br>
public | version | table | bacula<br>
(32 rows)</font><br>
<br>
<br>
Now...<br>
<br>
Table "file" was changed, but it looks like only one index was
dropped and another changed, since table filename in 9.67 is not
in 11.0.<br>
<p>On 9.6.7<br>
<font face="monospace"> Table
"public.file"<br>
Column | Type | Collation | Nullable |
Default <br>
------------+----------+-----------+----------+--------------------------------------<br>
fileid | bigint | | not null |
nextval('file_fileid_seq'::regclass)<br>
fileindex | integer | | not null | 0<br>
jobid | integer | | not null | <br>
pathid | integer | | not null | <br>
filenameid | integer | | not null | <br>
deltaseq | smallint | | not null | 0<br>
markid | integer | | not null | 0<br>
lstat | text | | not null | <br>
md5 | text | | not null | <br>
Indexes:<br>
"file_pkey" PRIMARY KEY, btree (fileid)<br>
<b> "file_jobid_idx" btree (jobid)</b><br>
<b> "file_jpfid_idx" btree (jobid, pathid, filenameid)</b></font><br>
<br>
On 11.0:<br>
<font face="monospace"> Table
"public.file"<br>
Column | Type | Collation | Nullable |
Default <br>
-----------+----------+-----------+----------+--------------------------------------<br>
fileid | bigint | | not null |
nextval('file_fileid_seq'::regclass)<br>
fileindex | integer | | not null | 0<br>
jobid | integer | | not null | <br>
pathid | integer | | not null | <br>
filename | text | | not null | ''::text<br>
deltaseq | smallint | | not null | 0<br>
markid | integer | | not null | 0<br>
lstat | text | | not null | <br>
md5 | text | | not null | <br>
Indexes:<br>
"file_pkey" PRIMARY KEY, btree (fileid)<br>
<b> "file_jpfid_idx" btree (jobid, pathid, filename
text_pattern_ops)</b><br>
</font><br>
</p>
It would be useful to see ER diagram and compare it to get full
understanding.<br>
<br>
<br>
I am attaching schema dumps for 9.6.7 and 11 (after upgrade) for
the reference.<br>
<br>
Best regards,<br>
<br>
--<br>
Mario.<br>
<br>
</blockquote>
</body>
</html>