Site's logo digitalkOmiX
  • Blog
    Articles Add Shot article
  • Docs
    Chi siamo / About
  • Login
    Login Sign Up

A database accident

Two crumpled grocery lists on a wooden surface
Two crumpled grocery lists on a wooden surface

04 Feb 2026

While cleaning up my web host account I accidentally destroyed the database of this website, so navigating to digitalkOmiX.com threw a 500 error. Fortunately my web host makes automatic backups, so I just emailed the support team and I received a response within minutes. The *.dump file was uploaded to my account, ready to be restored. A brief explanation of "how to fix" was provided, all by email.

First I had to recreate the database with the same name of the deleted one, along with it's user. Upon creation a new password was issued, so I had to copy/paste it. Accessing my account via SSH in the same directory where the *.dump file was uploaded, I restored the Postgres database with the following command:

pg-restore -U <database user> -d <database name> file.dump

I was prompted for the new password and the process worked seamlessly. Next I had to update the same password in the configuration file of the application that managed the database. I restarted the server and the website was back online!

Huge thanks to the (((Opalstack staff! 

My StudioLab

A small desktop, a tiny one, a switch and a net extender
A small desktop, a tiny one, a switch and a net extender

30 Jan 2026

I already have a homelab, but it sits in my studio, so I'll call it StudioLab. It's made from a small HP we had at work, RAM 16 GB, two SSD respectively 512 and 256 GB. It's too big and noisy to stay at home, but suitable for a work environment. It has Proxmox installed, here I learned to use VMs and Linux containers. Actually there is a LXC for a name server (BIND) and a VM with an Immich instance, other stuff is just shut down. The machine is remote controlled via a Tailscale VPN.

Let's build a HomeLab

Lenovo ThinkCentre M710q Tiny
Lenovo ThinkCentre M710q Tiny
On the left the SATA SSD
On the left the SATA SSD

29 Jan 2026

I'm building a homelab! First you need a machine: I bought this refurbished Lenovo ThinkCentre M710q Tiny, 16 GB of RAM and a 512 GB SSD. It's a very cute computer, small and quiet. Just one screw and you can access all the internals, on the bottom there is also place for another drive, a NVMe SSD (maybe I'll buy it and install the OS there to speed it up). It comes with Windows 10 Pro installed, but I'll swap it with Ubuntu 24.04. Of course they messed up with the shipment (the SATA SSD is half the size), and I'm waiting for the replacement.

In memoria di Francesco Guerra

Un mio disegno dei primi anni '80 con una caricatura di mio padre
Un mio disegno dei primi anni '80 con una caricatura di mio padre

26 Jun 2025

La settimana scorsa è venuto a mancare mio padre. Era un fisico teorico, per il suo contributo alla ricerca potete cercare qui:

https://en.wikipedia.org/wiki/Francesco_Guerra

Papà era molto giovane quando io ed i miei fratelli siamo nati. Abbiamo avuto il privilegio di condividere con lui tante esperienze di prima mano: i primi viaggi all'estero, le prime puntate di Star Trek... Aveva una capacità di concentrazione straordinaria, riempiva fogli e fogli di formule mentre noi nella stanza a fianco distruggevamo i soprammobili a pallonate.

Io ed i miei fratelli siamo nati sotto due Soli, uno molto caldo, quello di mia madre, uno un po' più freddo ma molto luminoso, quello di mio padre. Si sono spenti entrambi, ma ne sentiamo ancora il tepore e ne siamo illuminati.

Decollato

Disegno di un soldato che espone la propria testa decollata
Disegno di un soldato che espone la propria testa decollata

25 Apr 2025

Una trincea in Ucraina

Danse macabre

Soldati scappano all'arrivo di un drone FPV
Soldati scappano all'arrivo di un drone FPV

23 Apr 2025

Ispirato alla guerra ucraina

digitalkOmiX - 2026 Mastodon