[Pdns-users] Re: Export pdns database to records file

[Stephane Bortzmeyer]

On Fri, Jan 19, 2007 at 10:39:00AM +0100,
 Arjan Schrijver <arjan at anymore.nl> wrote 
 a message of 18 lines which said:

> For backup and fallback purposes, I have to be able to export the
> PowerDNS database to a plain records file.

This is a very sensible rule. What format is "plain records"? RFC 1034
(the so-called, and underspecified, BIND format)? Or SQL INSERT/COPY
requests?

For the first case, "dig @192.0.2.1 AXFR foobar.example" where
192.0.2.1 is your name server and foobar.example your domain, is a
good solution.

For the second case, it depends on your DBMS. For PostgreSQL, "pg_dump
registry" where registry is your database, is sufficient. pg_dump has
many options, see the man page.