• 5 Posts
  • 198 Comments
Joined 1 year ago
cake
Cake day: June 9th, 2023

help-circle




  • I have an atomic variant of fedora 40 (Aurora) and it just works on an Intel CPU with integrated graphics. I have a USB c dongle with HDMI out and it just works when I plug it in.

    I also tried it on my steam deck dock the other day and it worked without issue.






  • I tried to find this on DDG but also had trouble so I dug it out of my docker compose

    Use this docker container:

    prodrigestivill/postgres-backup-local

    (I have one of these for every docker compose stack/app)

    It connects to your postgres and uses the pg_dump command on a schedule that you set with retention (choose how many to save)

    The output then goes to whatever folder you want.

    So have a main folder called docker data, this folder is backed up by borgmatic

    Inside I have a folder per app, like authentik

    In that I have folders like data, database, db-bak etc

    Postgres data would be in Database and the output of the above dump would be in the db-bak folder.

    So if I need to recover something, first step is to just copy the whole all folder and see if that works, if not I can grab a database dump and restore it into the database and see if that works. If not I can pull a db dump from any of my previous backups until I find one that works.

    I don’t shutdown or stop the app container to backup the database.

    In addition to hourly Borg backups for 24 hrs, I have zfs snapshots every 5 mins for an hour and the pgdump happens every hour as well. For a homelab this is probably more than sufficient


  • Fair enough, I primarily use NFS for Linux to Linux sever communication and high file access.

    Smb is mostly for moving files around occasionally

    Not sure if trying to run a database over smb is a good idea but I do it on NFS all the time

    Regardless it doesn’t have to be exclusive. OP can change it up depending on the application