ads' corner

Long timeouts in restic and resticprofile when using restic-server

At home I have a restic-server running, which serves as one of the backup destinations for backups (among several other destinations). Over time I found that there is a small problem in this setup: when I am traveling, the backup kicks off - and needs a long time to finish when the repository is not available. The backup process runs into long timeouts, and on top of that, restic keeps the laptop from going to sleep.

Chemnitzer Linux-Tage 2025 - Rückblick

Die Chemnitzer Linux-Tage 2025 sind vorbei, Zeit für einen Rückblick.

PostgreSQL Berlin October 2024 Meetup

On October 9th, 2024, we had the PostgreSQL October Meetup in Berlin. Amazon hosted it. Josef Machytka spoke about JSON, Aychin Gasimov spoke about new features in PostgreSQL 17.

Clear Docker build cache

Docker keeps all built images in a cache, which grows over time. Removing the build layers is not obvious, there is no specific Docker 'cache' command.

Remove files from a restic backup (using resticprofile)

Sometimes files end up in a backup where they don't belong. It happens. While I'm a big advocate of having backups, sometimes entries need to be removed from a backup. This is easy to do in Restic, using resticprofile.

QNAP: exclude files and directories from rsync

I'm moving files from one QNAP system to another, and I'm using rsync for this. But excluding filed doesn't work!

PGSQL Phriday #002 Summary: PostgreSQL Backup and Restore

Last week for 'PGSQL Phriday': Describe how you do backups for your PostgreSQL databases.

PGSQL Phriday #002: PostgreSQL Backup and Restore

Thanks to Ryan Booz we now have the #PGSQLPhriday blogging series. The second edition is about backups. And of course also about restore.

PGSQL Phriday #001: Two truths and a lie

This month's #PGSQLPhriday topic: pick your three favorite or most important best pratices for #PostgreSQL. Tell them in a form that two are true, one is a lie. See if you can spot which one is true and which one is false. The resolution is at the end of this blog posting.

Changes to the public schema in PostgreSQL 15 and how to handle upgrades

In September 2021, a patch for the upcoming PostgreSQL version 15 was committed which introduces a visible change for users: the 'CREATE' privilege for the 'public' schema is no longer set by default.