Hi,
my bareos psql directory is 1.1TB in disk space. How do i find out the
number of total files in the catalog?
Best,
Kai
On 21.04.2020 16:42, Brock Palen wrote:
I would expect this. I have used Bareos about 2 years and bacula 10 before
that. The catalog size is heavily dependent on number of files.
My current psql directory is ~7GB for 19M files. Given you have 70M I think
you are about right for ratio.
The most important thing you can do to control database size is file retention
time, as that table is by far the largest.
Things to be careful for with reducing that to much is incremental backups
including always incremental.
If you have the job entries still you can still restore from an older backup,
you just cannot select the files, as bareos only knows where the job starts on
the media and where it ends.
Personally I just use a cheap SSD pair to store my database on, it’s low cost
enough I would not worry up to ~200GB or so.
Your backup media (Tape or disk) will cost much more than the space your DB
takes up if that is a concern.
Brock Palen
1 (989) 277-6075
[email protected]
www.mlds-networks.com
Websites, Linux, Hosting, Joomla, Consulting
On Apr 21, 2020, at 10:32 AM, Valentin Dzhorov <[email protected]> wrote:
So I am running an experimental Bareos setup backing up few real clients. So
far I've fleshed out the issues I've had and only one remains. I am running the
Bareos director on a PostgreSQL 12 and the catalog database is growing too big
for the few clients I am backing up. For example, currently I have 5.2TB of
backup space used and 70399391 of files listed in the catalog. The catalog
however uses 21GB of disk space! That is about 320 bytes used per file. Isn't
this quite large? Any tips on where this large disk usage for my catalog is
coming from?
--
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 on the web visit
https://groups.google.com/d/msgid/bareos-users/6edb197d-69d7-47e9-9209-9d9ea1899aa8%40googlegroups.com.
--
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 on the web visit
https://groups.google.com/d/msgid/bareos-users/97ea3340-3933-9d7a-a6ba-2bf9c4cf4aeb%40bbaw.de.
