Skip to content

Installation with PostgreSQL Backend

  • Install PowerDNS packages
    Alpine: pdns, pdns-tools, pdns-backend-pgsql, pdns-doc, postgresql, postgresql-client, pdnsd-doc
  • Create the database, here pdns, remember to grant access to the table and also allow sequences:

GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA public TO pdns; GRANT ALL ON ALL SEQUENCES IN SCHEMA public to pdns;

  • Create a role for accessing the database, here: pdns
  • Regularly create a backup of the DB so a restore is possible
  • Import schema: psql -U pdns -d pdns -a -f /usr/share/doc/pdns/schema.pgsql.sql