deployment:network:powerdns:install-postgres

Differences

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

Link to this comparison view

Both sides previous revision Previous revision
Next revision		 Previous revision
deployment:network:powerdns:install-postgres [2026/02/27 01:28] – [Konfigurasi PowerDNS Database Conection] ilyasadeployment:network:powerdns:install-postgres [2026/02/27 20:04] (current) – [Konfigurasi PowerDNS Database Conection] ilyasa
Line 23: Line 23:
 === Buat database dan user: === === Buat database dan user: ===
 <code sql> <code sql>
-sudo -u postgres psql <<EOF +sudo -u postgres psql -c "CREATE USER pdns WITH PASSWORD 'PasswordYangKuat';" 
-CREATE DATABASE powerdns; +sudo -u postgres psql -c "CREATE DATABASE powerdns OWNER pdns;"
-CREATE USER pdns WITH PASSWORD 'passwordku'; +
-ALTER DATABASE powerdns OWNER TO pdns; +
-GRANT ALL PRIVILEGES ON DATABASE powerdns TO pdns; +
-EOF+
 </code> </code>
  
 === Import schema bawaan PowerDNS: === === Import schema bawaan PowerDNS: ===
 <code bash> <code bash>
-sudo -u postgres psql powerdns < /usr/share/pdns-backend-pgsql/schema/schema.pgsql.sql+sudo -u postgres psql -d powerdns -c "SET ROLE pdns;" -f /usr/share/pdns-backend-pgsql/schema/schema.pgsql.sql
 </code> </code>
  
Line 39: Line 35:
 === Grant Permission to user pdns: === === Grant Permission to user pdns: ===
 <code sql> <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> </code>
  
Line 95: Line 86:
 gpgsql-dbname=powerdns gpgsql-dbname=powerdns
 gpgsql-user=pdns gpgsql-user=pdns
-gpgsql-password=passwordku+gpgsql-password=PasswordYangKuat
 </code> </code>
 === Restart Service === === Restart Service ===
Line 105: 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 ==== ==== Testing dengan pembuatan domain ====
  • deployment/network/powerdns/install-postgres.1772130531.txt.gz
  • Last modified: 2026/02/27 01:28
  • by ilyasa