This is useful when migrating servers and you want to reduce the DNS time to live for all domains.
Change the TTL on all domains to 5 mins (300 seconds) in the psa database.
# mysql -uadmin -p`cat /etc/psa/.psa.shadow` psa
mysql> UPDATE `dns_zone` SET `ttl` = '300', `ttl_unit` = '60' WHERE `id` >1;
mysql> quitThen update the zone files via:
# mysql -Ns -uadmin -p`cat /etc/psa/.psa.shadow` -D psa -e 'select name from domains' | awk '{print "/usr/local/psa/admin/sbin/dnsmng update " $1 }' | shVerify with:
$ dig @nameserver domain.tld soa