[Pdns-users] SOA serial number editing on re-signing of a zone / RRSIG changes

James Cloos cloos at jhcloos.com
Mon Mar 28 21:23:50 UTC 2011

>>>>> "bh" == bert hubert <bert.hubert at netherlabs.nl> writes:

bh> You can set SOA-EDIT to either 'INCEPTION', ... INCEPTION-WEEK, ...
bh> [and] I'm pondering 'SERIAL-INCREMENT'

an option to set the serial to the time_t of the most recent update would
be nice as well.

A column in records which looks like:

 changed | integer | default ((((now())::timestamp - '1970-01-01 00:00:00'::timestamp))::reltime)::integer

along with a query which grabs the largest value for the column with
the desired domain_id would make for an easy implementation.

(With the column default adjusted, of course, for non-postgres.)

James Cloos <cloos at jhcloos.com>         OpenPGP: 1024D/ED7DAEA6

More information about the Pdns-users mailing list