[Pdns-users] Reloading metadata with bind-backend & sqlite

[Peter van Dijk]

On Mon, 2022-12-19 at 14:29 +0100, Thib D via Pdns-users wrote:
> Hi,
> 
> Apologies for the misunderstanding,
> 
> I was mentioning this warning from the pdns docs, but I'm not sure this
> also applies to bind-backend + sqlite setups: 
> > It is not possible to replace the sqlite3 database file while
> > PowerDNS is running. Specifically, using rsync to distribute sqlite3
> > databases does not work without stopping PowerDNS first and
> > restarting it after the change.

It does also apply. It generally applies to almost all applications that
use SQLite.

> My goal here is to be able to modify/add either cryptokeys or metadata
> for a zone without having to restart PowerDNS. 
> However, the sqlite database I am using on top of the bind backend is
> read-only and provided from elsewhere (a distant server). 

You'll have to update the local database file in a way that doesn't break
sqlite's active handle on it. (I don't have any tricks ready for that,
sorry.)


Kind regards,
-- 
Peter van Dijk
PowerDNS.COM BV - https://www.powerdns.com/