IT Solutions Technology Blog

Pi-hole – MAXDBDAYS controls how many days of query data is stored in the long term database setting it to 0 disables logging effectively removing all query data. The default value is 365 days meaning queries older than a year are automatically removed

root@rpi-iot-jsho-pihole:~#

root@rpi-iot-jsho-pihole:~# service pihole-FTL stop
root@rpi-iot-jsho-pihole:~# rm /etc/pihole/pihole-FTL.db
root@rpi-iot-jsho-pihole:~# service pihole-FTL start

root@rpi-iot-jsho-pihole:~# pihole -up
[✓] Supported OS detected
[✓] Update local cache of available packages
[✓] Building dependency package pihole-meta.deb
[✓] Installing Pi-hole dependency package

[i] Checking for updates…
[i] Pi-hole Core: up to date
[i] Web Interface: up to date
[i] FTL: up to date

[✓] Everything is up to date!

root@rpi-iot-jsho-pihole:~#

root@rpi-iot-jsho-pihole:~# vi /etc/pihole/pihole-FTL.conf
MAXDBDAYS=8

root@rpi-iot-jsho-pihole:~# service pihole-FTL restart

root@rpi-iot-jsho-pihole:~#