• 1 Post
  • 120 Comments
Joined 2 years ago
cake
Cake day: June 4th, 2023

help-circle



  • That’s the thing I don’t like about Postgres either. The performance is significantly better than with MariaDB but Postgres is such a pain for non-enterprise use.

    Same with crash recovery, Postgres just can’t recover if the WAL is corrupted. MariaDB will happily fix itself but Postgres will just sit there and wait until somebody babysits it.

    So you better spin up a second Postgres container, run pg_resetwal, restart the database and terminate any open transactions manually with a 2 page query you hopefully wrote down. Might reindex all tables as well to be sure.

    I have a separate “postgres unfuck” script by now.





  • IPv6 is pretty much identical to IPv4 in terms of functionality.

    The biggest difference is that there is no more need for NAT with IPv6 because of the sheer amount of IPv6 addresses available. Every device in an IPv6 network gets their own public IP.

    For example: I get 1 public IPv4 address from my ISP but 4,722,366,482,869,645,213,696 IPv6 addresses. That’s a number I can’t even pronounce and it’s just for me.

    There are a few advantages that this brings:

    • Any client in the network can get a fresh IP every day to reduce tracking
    • It is pretty much impossible to run a full network scan on this amount of IP addresses
    • Every device can expose their own service on their own IP (For example: You can run multiple web servers on the same port without a reverse proxy or multiple people can host their own game server on the same port)

    There are some more smaller changes that improve performance compared to IPv4, but it’s minimal.








  • Is that actually an UPS or just a backup battery? Can it passthrough the line power directly or does the inverter need to run 24/7?

    In the latter case you might want to check how much power the inverter eats just by itself. For example, my Bluetti with 2 kWh needs a whopping 50W in idle just to keep the AC ports powered. Of course your unit looks much smaller so it should be way less but still worth measuring.





  • Top to bottom:

    • Unifi US-16-XG
    • OPNsense DEC740
    • Unifi Switch 24
    • Unifi Switch 16 PoE
    • DIY server with an AsrockRack X470D4U mainboard
    • DIY DAS in an old server case with 18 3.5" bays

    Not in picture: My UPSes, RIPE Atlas probe and an Odroid N2+ running my Home Assistant instance

    The server runs Proxmox with a bunch of LXC containers running a Docker Swarm cluster.

    There’s too many services running so I’m not listing them all. Let’s just say my phone is not going to be thrilled if it goes down. Also, this post was posted through said server.