News for hackers. Stuff that matters.
Re:Postgres Incremental Backup by aembleton on Friday January 12, 2024 @04:02AM (#38965734)
What other media should you store backups in? Tape? Paper print out?
Re:Postgres Incremental Backup by scoot on Friday January 12, 2024 @04:19AM (#38965866)
Historically tape, but in practice these days it means "not on the same storage as your production data". For example in addition to a snapshot on your production system (rapid point in time recovery if the data is hosed), a local copy on deduplicated storage (recovery if the production volume is hosed), and an offsite copy derived from replicated deltas (disaster recovery if your site is hosed).

The same principle can be applied to cloud hosted workloads.

Re:Postgres Incremental Backup by tetha on Friday January 12, 2024 @05:33AM (#38966377)
As an example, for postgres, we have:

Backups on a pgbackrest node directly next to the postgres cluster. This way, if the an application figures a good migration would include TRUNCATE and DROP TABLE or terrible UPDATEs, a restore can be done in some 30 - 60 minutes for the larger systems.

This dataset is pushed to an archive server at the same hoster. This way, if e.g. all our VMs die because someone made a bad change in terraform, we can relatively quickly restore the pgbackrest dataset from the morning of that day, usually in an hour or two .

And this archive server is mirrored by and is mirroring some archive servers at different hosters entirely, also geographically far apart. This way, even if a hoster cuts a contract right now without warning we'd lose at most 24 hours of archives, which can be up to 48 hours of data (excluding things like offsite replication for important data sets).

Re:Postgres Incremental Backup by shiroiuma on Friday January 12, 2024 @04:06AM (#38965768)
Either papyrus or clay tablets if you want it to last.

More seriously, perhaps the "2 different media" means don't use, for instance, the same brand and/or model of hard drive for your multiple backups.

Re:Postgres Incremental Backup by fatihpense on Friday January 12, 2024 @05:46AM (#38966472)
Papyrus doesn't last :) You want clay tablets, buried in the ground. Looking at Sumerian tablets that would give you 5000 years.
Re:Postgres Incremental Backup by shiroiuma on Friday January 12, 2024 @06:22AM (#38966755)
I thought papyrus lasted a really long time, as long as you sealed it in huge stone tombs in the desert.

I think we should build a big library in a lava tube on the Moon to store all the most important data humanity has generated (important works of art and literature, Wikipedia, etc.). That's probably our best hope of really preserving so much knowledge.

Re:Postgres Incremental Backup by tim333 on Friday January 12, 2024 @05:44PM (#38975200)
Some lasted at least 3000 years https://www.britannica.com/topic/Ebers-papyrus
Re:Postgres Incremental Backup by wongarsu on Friday January 12, 2024 @09:51AM (#38968648)
In the original version that means tape, yes. It's the point most startups skip, but it has some merit. A hacker or smart ransomware might infect all your backup infrastructure, but most attackers can't touch the tapes sitting on a shelf somewhere. Well, unless they just wait until you overwrite them with a newer backup.
Re:Postgres Incremental Backup by EvanAnderson on Friday January 12, 2024 @11:34AM (#38970164)
Don't forget to test the tapes, ideally in an air-gapped tape drive. One attack scenario I posed in tabletop exercise was to silently alter the encryption keys on the tape backups, wait for a few weeks/months, then zero the encryption keys at the same time the production data was ransomed. If the tape testing is being done on the same servers where the backups are being taken you might never notice your keys have been altered.

(The particular Customer I was working with went so far as to send their tapes out to a third-party who restored them in and verified the output of reports to match production. It was part of a DR contract and was very expensive but, boy, the piece of mind was nice.)

Re:Postgres Incremental Backup by EvanAnderson on Friday January 12, 2024 @11:38AM (#38970227)
Depending on the size of your data corpus a few USB disks w/ full disk encryption could be a cheap insurance policy. Use a rotating pool of disks and make sure only one set is connected at once.

Force the attacker to restore to kinetic means to completely wipe out your data.