Re: [Pdns-users] Modify Records Table-Time of Day records
Martin Chandler wrote: > > > Is it possible to modify the structure of the records table, > > > to add new fields? > > > > You can add as many columns as you need; that will not interfere with > > PowerDNS Auth operation. (You can also rename existing columns, but > > you'd need to redefine the queries PowerDNS uses, so I don't > > recommend you doing that.) > > > > Even if you rename columns, etc it is also possible to then create a > view for PowerDNS that matches the recommended schema. > That way you don't have to redefine the queries... Yes, and no. Don't be surprised if things don't work anymore, depending on your setup. PDNS needs to write into the database/records table for several applications, and a view is not neccesarily writeable, depending on how it is created. Notably here would be Superslave operation; or probably any slave operation mode where replication is done by AXFR and not database means, as the transferred RRs need to be inserted into the DB at the slave. So, despite having a view representing the original database layout, you still may have to redefine some queries. On a side note: Dear staff, I am lacking to find the empty-non-terminal-queries at https://doc.powerdns.com/md/authoritative/backend-generic-mypgsql/ - did they become obsolete in recent revisions? Sebastian ___ Pdns-users mailing list Pdns-users@mailman.powerdns.com http://mailman.powerdns.com/mailman/listinfo/pdns-users
Re: [Pdns-users] Modify Records Table-Time of Day records
On 2015/02/11 22:35, Jan-Piet Mens wrote: Is it possible to modify the structure of the records table, to add new fields? You can add as many columns as you need; that will not interfere with PowerDNS Auth operation. (You can also rename existing columns, but you'd need to redefine the queries PowerDNS uses, so I don't recommend you doing that.) Even if you rename columns, etc it is also possible to then create a view for PowerDNS that matches the recommended schema. That way you don't have to redefine the queries... Regards, Martin -- Cellular phone : 090-7849-6808 e-mail:mchand...@aventer.net URL :http://www.aventer.net/ ___ Pdns-users mailing list Pdns-users@mailman.powerdns.com http://mailman.powerdns.com/mailman/listinfo/pdns-users
Re: [Pdns-users] Modify Records Table-Time of Day records
> Is it possible to modify the structure of the records table, to add new > fields? You can add as many columns as you need; that will not interfere with PowerDNS Auth operation. (You can also rename existing columns, but you'd need to redefine the queries PowerDNS uses, so I don't recommend you doing that.) -JP ___ Pdns-users mailing list Pdns-users@mailman.powerdns.com http://mailman.powerdns.com/mailman/listinfo/pdns-users
[Pdns-users] Modify Records Table-Time of Day records
Hi Guys, I have implemented an ENUM server using powerdns and its working well. I store data of course in the powerdns database, and in particular the records table. Is it possible to modify the structure of the records table, to add new fields? Also has anyone implemented Time of day routing with ENUM and powerdns previously? Any help would be great. Many thanks Jon ___ Pdns-users mailing list Pdns-users@mailman.powerdns.com http://mailman.powerdns.com/mailman/listinfo/pdns-users