Use something like pgAdmin, DBeaver or the pg cli to connect to your postgres instance. Then run the command from the changelog as a SQL query.
Use something like pgAdmin, DBeaver or the pg cli to connect to your postgres instance. Then run the command from the changelog as a SQL query.
Das einzig schlechte daran ist der Titel, da hätte ich von der Zeit mehr erwartet.
Beschissene Titel sind eine Spezialität der ZEIT. Ich weiß, ich weiß, Klicks und so. Trotzdem, die Meisten lesen doch nur die Überschrift.
You can get a quick overview via DSM, I think in the Disk Manager. For more details you could jump into a terminal and use smartctl.
Have you checked the SMART values of your drives? Do they give you a reason for your concerns?
Anyhow, you should never be in a position where you need to worry about drive failure. If the data is important, back it up separatly. If it isn’t, well, don’t sweat it then.
Why would you buy something new if your current solution works and your requirements don’t change? Just keep it.
Wasabi S3 is nice and cheap. You’ll only pay what you use, so probably just a few cents in your case.
Oops, nevermind:
If you store less than 1 TB of active storage in your account, you will still be charged for 1 TB of storage based on the pricing associated with the storage region you are using.
I recently upgraded three of my proxmox hosts with SSDs to make use of ceph. While researching I faced the same question - everyone said you need an enterprise SSD, or ceph would eat it alive. The feature that apparently matters the most in my case is Power Loss Protection (PLP). It’s not even primarily needed to protect from an possible outage, but it forces sync writes instead of relying on a cache for performance.
There are some SSDs marketed for usage in data centers, these are generally enterprisey. Often they are classified for “Mixed Use” (read and write) or “Read Intensive”. Other interesting metrics are the Drive Writes Per Day (DWPD) and obviously TBW and IOPS.
At the end I went with used Samsung PM883.
But before you fall into this rabbit hole, you might check if you really need an enterprise SSD. If all you’re doing is running a few vms in a homelab, I would expect consumer SSDs to work just fine.
Quelle: ADAC. Kannste dir nicht ausdenken.
What’s wrong with Portainer?
this has been the hottest summer ever
I hope you enjoyed it, it might have been the coolest summer for the rest of our lives!
No, the registrar just registers the domain for you (duh). You can then change the DNS recods for this domain and these records will propagate to other DNS servers all around the world. Your clients will use some of these DNS servers to lookup the IP address of your server and then connect to this IP.
The traffic between your clients and server has nothing to do with your domain registrar.
Ich versuche locker zu bleiben. Eine weitere Eskalation bringt mir nichts, im Gegenteil:
Nichts davon peppt mich besonders an, inbesondere wegen Punkt 1. Warum der zusätzliche Stress, wenn es absolut nichts bringt.
Ich muss dazu sagen, dass ich hier von einem aggressiven Autofahrer ausgehe. Wenn es sich stattdessen um jemanden handelt, der einfach nur scheiße gefahren ist, ohne dabei böswillig zu wirken, versuche ich es ab und an mit einer kleinen Bemerkung. Hab’ z.B. mal jemanden, der mich unnötig eng auf einer Fahrradstraße überholte, an der nächsten Kreuzung durchs geöffnetes Fenster “Cooler Move, hier auf der Fahrradstraße!” zugerufen. Seine Beifahrerin lachte wissend und er fuhr peinlich berührt weiter - da hat’s vielleicht sogar was gebracht.
You could look into mainboards with IPMI. They give you a web based interface to fully control your server, including power management, shell, sensor readings, etc.
Endlich, das war lange überfällig.
I love Jellyfin but I would absolutely not make it accessible over the public internet. A VPN is the way to go.
Fixed, thanks.
Yeah, tail
would be the more obvious choice instead of negating head.
Fuck, I need coffee. @klay@lemmy.world is right (again).
You’re right, I edited my comment. Thanks!
This line seems to list all dumps and then deletes all but the two most recent ones.
In detail:
ls -1 /backup/*.dump
lists all files ending with .dump alphabetically inside the /backup directoryhead -n -2
returns all filenames except the two most recent ones from the end of the listxargs rm -f
passes the filenames to rm -f
to delete themTake a look at explainshell.com.
Der AfD Posten zugestehen, um ihr zu schaden. Aha.