This is an old revision of the document!
PowerDNS : Installasi dengan posgresSQL Backend (Debian 12/13)
Install Paket
Update repository:
apt update
Install PowerDNS Authoritative + PostgreSQL:
apt install pdns-server pdns-backend-pgsql postgresql
Pastikan service PostgreSQL berjalan:
systemctl status postgresql
Buat Database & User PostgreSQL
Masuk sebagai user postgres:
sudo -u postgres psql
Buat database dan user:
CREATE DATABASE powerdns; CREATE USER pdns WITH PASSWORD 'passwordku'; ALTER DATABASE powerdns OWNER TO pdns; GRANT ALL PRIVILEGES ON DATABASE powerdns TO pdns; \q
Import schema bawaan PowerDNS:
sudo -u postgres psql powerdns < /usr/share/pdns-backend-pgsql/schema/schema.pgsql.sql
Cek tabel sudah dibuat:
sudo -u postgres psql powerdns -c "\dt"