Differences

This shows you the differences between two versions of the page.

--- deployment:network:powerdns:install-postgres [2026/02/27 17:49] – [Buat Database & User PostgreSQL] ilyasa
+++ deployment:network:powerdns:install-postgres [2026/02/27 20:04] (current) – [Konfigurasi PowerDNS Database Conection] ilyasa
@@ Line 35: / Line 35: @@
 === Grant Permission to user pdns: ===
 <code sql>
-sudo -u postgres psql powerdns <<EOF
+sudo -u postgres psql -d powerdns -c "ALTER SCHEMA public OWNER TO pdns;"
-GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA public TO pdns;
+sudo -u postgres psql -d powerdns -c "GRANT CREATE ON SCHEMA public TO pdns;"
-GRANT ALL PRIVILEGES ON ALL SEQUENCES IN SCHEMA public TO pdns;
-GRANT ALL PRIVILEGES ON SCHEMA public TO pdns;
-ALTER DEFAULT PRIVILEGES IN SCHEMA public GRANT ALL PRIVILEGES ON TABLES TO pdns;
-ALTER DEFAULT PRIVILEGES IN SCHEMA public GRANT ALL PRIVILEGES ON SEQUENCES TO pdns;
-EOF
 </code>
@@ Line 91: / Line 86: @@
 gpgsql-dbname=powerdns
 gpgsql-user=pdns
-gpgsql-password=passwordku
+gpgsql-password=PasswordYangKuat
 </code>
 === Restart Service ===
@@ Line 101: / Line 96: @@
-{{indexmenu_n>001}}
-====== PowerDNS : Installasi dengan posgresSQL Backend (Debian 12/13) ======
-==== Install Paket ====
-=== Update repository: ===
-<code bash>
-apt update
-</code>
-=== Install PowerDNS Authoritative + PostgreSQL: ===
-<code bash>
-apt install pdns-server pdns-backend-pgsql postgresql
-</code>
-=== Pastikan service PostgreSQL berjalan: ===
-<code bash>
-systemctl status postgresql
-</code>
-==== Buat Database & User PostgreSQL ====
-=== Buat database dan user: ===
-<code sql>
-sudo -u postgres psql <<EOF
-CREATE DATABASE powerdns;
-CREATE USER pdns WITH PASSWORD 'passwordku';
-ALTER DATABASE powerdns OWNER TO pdns;
-GRANT ALL PRIVILEGES ON DATABASE powerdns TO pdns;
-EOF
-</code>
-=== Import schema bawaan PowerDNS: ===
-<code bash>
-sudo -u postgres psql powerdns < /usr/share/pdns-backend-pgsql/schema/schema.pgsql.sql
-</code>
-=== Grant Permission to user pdns: ===
-<code sql>
-sudo -u postgres psql powerdns <<EOF
-GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA public TO pdns;
-GRANT ALL PRIVILEGES ON ALL SEQUENCES IN SCHEMA public TO pdns;
-GRANT ALL PRIVILEGES ON SCHEMA public TO pdns;
-ALTER DEFAULT PRIVILEGES IN SCHEMA public GRANT ALL PRIVILEGES ON TABLES TO pdns;
-ALTER DEFAULT PRIVILEGES IN SCHEMA public GRANT ALL PRIVILEGES ON SEQUENCES TO pdns;
-EOF
-</code>
-=== Cek tabel sudah dibuat: ===
-<code bash>
-sudo -u postgres psql powerdns -c "\dt"
-</code>
-==== Konfigurasi PowerDNS conflict port dengan ''systemd-resolved'' ====
-Sometimes server linux terutama cloud images, menggunakan ''systemd-resolved'' yang menggunakan port 53 secara default. Kita ingin mendisable hal berikut untuk dapat digunakan PowerDNS Nanti.
-=== Disable systemd-resolved ===
-<code>
-sudo systemctl disable systemd-resolved --now
-</code>
-hapus stub resolv.conf:
-<code>
-sudo rm /etc/resolv.conf
-</code>
-buat manual resolv.conf:
-<code>
-sudo nano /etc/resolv.conf
-</code>
-Sesuaikan dengan dns server kalian:
-Contoh:
-<code bash>
-nameserver 8.8.8.8
-nameserver 1.1.1.1
-</code>
-==== Konfigurasi PowerDNS Database Conection ====
-=== Hapus bind.conf dikarenakan kita menggunakan psql sebagai our backend ===
-<code bash>
-rm /etc/powerdns/pdns.d/bind.conf
-</code>
-=== Buat konfigurasi powerdns database connetion sesuai dengan database kita ===
-<code bash>
-nano /etc/powerdns/pdns.d/gpgsql.conf
-</code>
-<code bash>
-launch=gpgsql
-gpgsql-host=127.0.0.1
-gpgsql-port=5432
-gpgsql-dbname=powerdns
-gpgsql-user=pdns
-gpgsql-password=passwordku
-</code>
-=== Restart Service ===
-<code bash>
-systemctl restart pdns
-systemctl enable pdns
-systemctl status pdns
-</code>
 ==== Testing dengan pembuatan domain ====