Just checking:

bacula=# select count(*) from file;
count
------------
1172853837
(1 row)

bacula=#

That's 1,172,853,837

I'm convinced that is my largest table.

#bacula #postgresql

SSD death ☠️💀

I am busy rebuilding the data from an SSD which died all of a sudden from one moment to the next without giving any warnings in any manner in any way.

I always monitor SMART output of SSD drives & mechanical spinners (HDD)

I've not seen any smart output indicating imminante dead

This drive has acted like your girlfriend when she's just not in a good mood and without explanation says nothing to you in the morning, for hours.

This hard crash, means that the S.M.A.R.T. monitoring hardware didn't have proper Communications with the integrated circuits on the SSD.

The drive was always powered many times a month, never left without power for more than a week or so, thus that has not been a contributing factor to the SSD catastrophic failure

The drive itself is fairly small.

The data on this dead SSD I've backed up on remote drives connected in JBOD format to machines which I have running remotely.

No ZFS on my backup machines

• I want to run ZFS native
• that means running a BSD OS on those machines
• that also means I will need to backup / restore all data on those drives meaning
• I will need 200% of the used HDD / SSD space on those machines
• I need patience for that backup
• I need expensive extra HDD's for that project
• I won't pay USD 300 for a USD 120 HDD

NO ZFS under these global SSD / HDD market prices

Sources:

• Moi
• man ls(1)
• man lsd(1)
• man cp(1)
• man smartctl(8)
• man zfs(8)

#HDD #SSD #crash #no #warning #on #TV #filesystems #remote #backup #network #JBOD #SMART #programming #bacula

I've said this before. Good software is software you forget you're running.
Today, a #ZFS zpool is up to 87% capacity. What?
Oh yes, my full backups ran yesterday (first Sunday of the month).
This issue is partly why I'm moving-to-bigger zpools, perhaps done this week.

#Bacula

Search in Database (Catalog) of #Bacula Enterprise for files and Path backed up from a client

#sql #bash #postgresql

https://gist.github.com/Flasche-Chris/4c91a3bde14ba33c10c165f238ea33ad

Huh! TIL that Bacula still exists, and actively being maintained at that?

https://friedcheese.us/notice/Azun76CVCCxB9l6Xlw

<bookmarks for near-future-use>

#Bacula #macOS

I may have to adjust my snapshot policy for this dataset. I ran some more backups - each monthly set is about 1TB.

https://gist.github.com/dlangille/227e59ab18bf64e4f3d66dc82b60b90b

#FreeBSD #ZFS #bacula

And the Fortune said;

RAID is not a backup
The cloud ☁️ is also not a backup!

Tar is a backup Bacula and ZFS with proper hardware configuration also.

Even just `tar -cvfz` would be great with the tar dumped on HDD off site.

WTF Korea now the millions of vital records are gone :(

The damage of this is incalculable

#Cloud #backup #bacula #ZFS #RAID #tar

https://koreajoongangdaily.joins.com/news/2025-10-01/national/socialAffairs/NIRS-fire-destroys-governments-cloud-storage-system-no-backups-available/2412936

If you use #Bacula in Bookworm, be aware that the upgrade to Trixie will initiate a major overhaul of the database, which will need a lot of disk space and time.

https://www.debian.org/releases/trixie/release-notes/issues.en.html#bacula-director-database-schema-update-needs-large-amounts-of-disk-space-and-time

Meine Home-Infrastruktur wird so langsam.
Ziehe gerade um von Thin-Clients (Raspberry Pi war mir alles zu schwach) auf nen Mini-PC mit entsprechend RAM und CPU.
Auf einem der Thin-Clients lief vorher schon #Bacula für Backup in nem LXC-Container. Der soll jetzt #ProxmoxBackupServer werden.

Wie würdet ihr das machen? Auf dem #ProxmoxBackupServer direkt #Bacula installieren für die physischen Sachen und Server im Internet oder würdet ihr aufm #Proxmox Server eine VM/Container für #bacula machen? Oder Container oder VM auf dem Backup-Server?

Tendiere zur Direktinstallation wegen des Overheads und was will ich mit den Backup-Sachen aufm Proxmox-Server und so habe ich eine Kiste, auf der alle Backups drauf sind.