Checklist for major postgresql database upgrade: shutdown standby servers on each standby perform pg_upgrade shutdown master perform pg_upgrade if pg_upgrade fails on postgres database with encoding mismatch, re-init database with initdb start master verify master is ok check if recovery.conf present in slave datadir start slaves one-by-one check if slaves are live and recovering if […]
This post describes all the things you will have to do, after (or before) installing and configuring your mail server, because that is where it all starts. Without it, you might have problems sending mail, because remote domains might think your server sends spam or is not delegated to send emails for your domain…
As always with Oracle its pretty ‘easy‘ and ‘straightforward‘ – you have to convert the high_value to XML and then extract it using XPATH (omg!). Let me guess, it would cost a fortune to provide native function/view that could do that…
Some time ago I’ve tried to solve a ‘funny’ issue with PowerDNS. It refused to start on one of my backup VPS. After apt-get dist-upgrade, it first stopped to work with very meaningful ‘Failed at step ADDRESS_FAMILIES‘ error. Well, I’ve managed to solve it somehow, but then another ‘funny’ problem popped out…
Some hopefully useful tips on speeding up data import via SOLR DataImportHandler.
In PostgreSQL it’s quite easy to restrict access for user to some tables: create restrictive view grant usage on view schema grant select on view to restricted user done Really easy. And it’s not working when the restrictive view, is selecting from another view that is using function(s)!
I encountered this problem again, so let’s write it down to avoid googling it. Problem: PowerDNS fails to start with pdns.service: Failed at step ADDRESS_FAMILIES spawning /usr/sbin/pdns_server: Invalid argument Solution: edit /lib/systemd/system/pdns.service comment out RestrictAddressFamilies comment out ProtectSystem=full possibly kill systemd-resolved systemctl daemon-reload ask yourself again, why are you using debian with systemd on server […]
I’ve hacked together and up-to-date version of Asuswrt Merlin firmware for oldie but goldie Asus RT-N16 router. Beware, this firmware is only intended for use by advanced users.
tinc is a great mesh Virtual Private Network daemon, with just one little glitch (and also some little crypto problems ;-). I find its configuration really tedious and complicated compared to OpenVPN and its possibility to centrally assign IP addresses and push options to clients. I know, that’s the tax for being mesh, but wouldn’t […]
Here is my solution for making Amlogic S812 based Beelink MXIII Plus Android TV Box work with Logitech Harmony universal remote. It’s based on solution described on this forum post, but modified to make it easier to use (if your Harmony remote is able to learn new IR commands).