Instructions on setting up PostgreSQL as a backend for PowerDNS --------------------------------------------------------------- PowerDNS uses dbconfig-common. The database backends offer you to automatically create and maintain the databases for you. If you choose yes, you're fine, no more action needed. Should you decide to create your databases yourself, for example, if you decide to use a non-standard schema, please find the database schema recommended by Upstream for PostgreSQL in /usr/share/dbconfig-common/data/pdns-backend-pgsql/install/pgsql Just create a database using 'createdb' (for example named pdns) and then feed these SQL commands to PostgreSQL to get some defaults to start with: psql -h -U -f /usr/share/dbconfig-common/data/pdns-backend-pgsql/install/pgsql Then add your data to the database. *** SSL WARNING *** Please note that SSL connections to a PostgreSQL database currently do not work when PowerDNS is run chrooted because PowerDNS cannot access the libssl library from within the chroot. *** SSL WARNING ***