1·
2 years agoI run opnsense, which has a long a storied history with pfsense and in my opinion is better, on a VM in proxmox.
I have a cluster of three servers and I can live migrate the VMs around to do maintenance. It gets backed up to proxmox backup server so restoring from a bad upgrade, which I’ve never had happen, or severe experimentation, which happens frequently, is simple.
It’s also one less device to power on, and pay for. My cluster is running regardless and every watt less helps keep my wife happy.
I’ve never had any issues that I could attribute to it being run in a VM. It does my 1gbe fiber and a dozen vlans with no issues.
The lemmy user in the database needs superuser privilages. Add superuser to the lemmy account, drop the database, and then recreate it.
sudo -iu postgres psql -c "ALTER USER lemmy WITH SUPERUSER;" sudo -iu postgres psql -c "DROP DATABASE lemmy;" sudo -iu postgres psql -c "CREATE DATABASE lemmy WITH OWNER lemmy;"Edit: they may have fixed this but I’m not sure what version it’s in. Let me know if that doesn’t work. https://github.com/LemmyNet/lemmy/pull/3002