Christian Lehnert — Linux, Hacking & Faith

tag: #tip-of-the-week

5 posts
3 weeks ago PostgreSQL PITR - Point-in-Time Recovery With WAL Archiving

A nightly pg_dump at 4am means that when prod dies at 3pm you lose eleven hours of data, and there is nothing you can do about it. Postgres already writes down every change as it happens in the WAL. Archive that continuously on top of a base backup and you can recover to any second, including the moment right before someone ran the bad command. That is PITR, and it is the difference between an outage and a catastrophe. With the two numbers, RPO and RTO, that should drive the whole decision.

#postgres #tip-of-the-week #databases #devops
4 months ago adduser vs useradd - The Debian Trap

On Debian and Ubuntu, two commands look like they do the same thing. They do not. adduser is a Perl wrapper from the adduser package. useradd is the raw binary from upstream shadow-utils. The difference catches operators who write portable scripts and expect either name to work the same way on RHEL or Alpine.

#linux #debian #ubuntu #tip-of-the-week