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.
Posted by ads' corner on Wednesday, October 21, 2026
Die Chemnitzer Linux-Tage 2025 sind vorbei, Zeit für einen Rückblick.
Posted by ads' corner on Wednesday, April 9, 2025
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.
Posted by ads' corner on Friday, October 11, 2024
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.
Posted by ads' corner on Friday, August 30, 2024
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.
Posted by ads' corner on Thursday, August 15, 2024
I'm moving files from one QNAP system to another, and I'm using rsync for this. But excluding filed doesn't work!
Posted by ads' corner on Tuesday, March 14, 2023
Last week for 'PGSQL Phriday': Describe how you do backups for your PostgreSQL databases.
Posted by ads' corner on Tuesday, November 8, 2022
Thanks to Ryan Booz we now have the #PGSQLPhriday blogging series. The second edition is about backups. And of course also about restore.
Posted by ads' corner on Monday, October 31, 2022
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.
Posted by ads' corner on Friday, October 7, 2022
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.
Posted by ads' corner on Tuesday, August 30, 2022