Hello!
On a new Bareos server (ct-bareos02) that is 1 month old, the size of the
Bareos database (vl-bareos02) is growing. On another server (vl-bareos01),
which is more than 2 years old, with the same settings and more VMs and
backup files, this does not happen.
What does it depend on and what steps should be taken?
[root@CT-BAREOS01 pgsql]# du -h --max-depth=1
926M ./data
4.0K ./backups
926M .
bareos=# SELECT relname AS table_name,
pg_size_pretty(pg_total_relation_size(relid)) AS total_size
FROM pg_catalog.pg_statio_user_tables
ORDER BY pg_total_relation_size(relid) DESC
LIMIT 10;
table_name | total_size
----------------+------------
file | 503 MB
restoreobject | 113 MB
pathvisibility | 77 MB
log | 57 MB
path | 40 MB
pathhierarchy | 10040 kB
jobmedia | 5880 kB
job | 2128 kB
jobhisto | 944 kB
media | 936 kB
(10 rows)
========================================
[root@VL-BAREOS02 pgsql]# du -h --max-depth=1
8.7G ./data
4.0K ./backups
8.7G .
bareos=# SELECT relname AS table_name,
pg_size_pretty(pg_total_relation_size(relid)) AS total_size
FROM pg_catalog.pg_statio_user_tables
ORDER BY pg_total_relation_size(relid) DESC
LIMIT 10;
table_name | total_size
----------------+------------
file | 8312 MB
path | 15 MB
pathvisibility | 2712 kB
log | 2648 kB
pathhierarchy | 2144 kB
media | 456 kB
jobmedia | 352 kB
job | 208 kB
pool | 80 kB
fileset | 80 kB
(10 rows)
--
You received this message because you are subscribed to the Google Groups
"bareos-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion visit
https://groups.google.com/d/msgid/bareos-users/7fd9e6bd-1ce1-4f0c-8bc7-8431687d716bn%40googlegroups.com.
