Scripts to Bulk Build Database From Files

[Iced]

I manage a few piholes (2 at home, 1 on a personal VPN, and 1 for relatives). In older versions it was easy to manage and sync these pi's via a simple script that just downloaded a few files (adlists.list, regex.list, whitelist.txt) and replaced whatever was there and poof they were on the most curated list.

With the database, its a bit more complex. I cant seem to figure out how to keep everything in sync, and it looks like a lot of the effort is GUI based. Can you create a script that does the build process (similar to when you first upgrade to V5+) that people like me could use? It wouldn't have to be something that was exposed via GUI, but just a tool for us that want to use the backend / command lines to keep things up to date.

I understand you lose the per client rules and all that jazz, but efficiency of use to bulk update would be a life saver.

[mmotti]

In most cases you can simply setup one pihole and copy the gravity.db file to sync your adlist config etc. Some people use the teleporter function.

If you want to sync the gravity db, it's also probably best to clear the gravity table and vacuum before syncing as it keeps the file size down, then run a gravity update to repopulate.

I have also made a script that allows you to extract certain things, edit and reupload them in the old fashion - It just doesn't accommodate for the tweaking of the new DB fields (i.e group management etc)

There are ways to achieve what you are looking for, but not automatically unless you are handy with scripting

[yubiuser]

Gravity Sync, an easy way to keep multiple Pi-hole In-sync

What is better than a Pi-hole blocking ads via DNS on your network? That's right, Two Pi-hole! But if you have more than one Pi-hole (PH) in your network you'll want a simple way to keep the list configurations identical between the two. I've recently been toiling away at a script to do exactly this, and what started as a few lines lines of bash was shared with some friends, and has grown into what I now call Gravity Sync -- which I'd now like to share with you all for your feedback. https://gi…

Primary Pi-hole syncs lists to unlimited Secondary Pi-holes

I run six Pi-holes on three different networks at three different physical locations. I wanted all six Pi-holes to share the same blocklists, blacklists, whitelists, and regex files, but it was time-consuming to manually synchronize all of them. I wanted to use Pi-hole's built-in web UI to manage only one set of lists on one Pi-hole -- and then securely synchronize an unlimited number of additional Pi-holes. I couldn't find an existing script that did exactly what I wanted... so I wrote one…

[vmstan]

Fyi: Gravity Sync will preserve per-client and local DNS rules.