Busk at 01:14, 18 November 2020

2020-11-18T01:14:48Z

Busk at 00:30, 18 November 2020

2020-11-18T00:30:08Z

imported>Busk at 17:08, 13 June 2019

2019-06-13T17:08:44Z

New page

# Installing PowerDNS

```
systemctl stop systemd-resolved
systemctl disable systemd-resolved
apt install postgresql postgresql-common pdns-server pdns-backend-pgsql
```

# PowerAdmin for Web UI

```
apt install libapache2-mod-php php-pgsql apache2
https://github.com/poweradmin/poweradmin
copy files to /var/www/html and modify inc/config-me.inc.php

You can always try this editor as well
https://github.com/ngoduykhanh/PowerDNS-Admin
```

# Set values

vim /etc/powerdns/pdns.d/pdns.local.gpgsql.conf
```
systemctl restart pdns
```
# Database

# Read-only clients

pg_hba.conf
```
host all replicator 10.50.4.31/32 trust
host all replicator 10.50.4.32/32 trust

```

```
Get schema from master after creating needed users/roles

createdb -O powerdns pdns
psql -U powerdns pdns < pdns.schema
```

PDNS Schema for Client
```
--
-- PostgreSQL database dump
--

-- Dumped from database version 10.8 (Ubuntu 10.8-0ubuntu0.18.04.1)
-- Dumped by pg_dump version 10.8 (Ubuntu 10.8-0ubuntu0.18.04.1)

SET statement_timeout = 0;
SET lock_timeout = 0;
SET idle_in_transaction_session_timeout = 0;
SET client_encoding = 'UTF8';
SET standard_conforming_strings = on;
SELECT pg_catalog.set_config('search_path', '', false);
SET check_function_bodies = false;
SET xmloption = content;
SET client_min_messages = warning;
SET row_security = off;

--
-- Name: plpgsql; Type: EXTENSION; Schema: -; Owner:
--

CREATE EXTENSION IF NOT EXISTS plpgsql WITH SCHEMA pg_catalog;

--
-- Name: EXTENSION plpgsql; Type: COMMENT; Schema: -; Owner:
--

COMMENT ON EXTENSION plpgsql IS 'PL/pgSQL procedural language';

SET default_tablespace = '';

SET default_with_oids = false;

--
-- Name: comments; Type: TABLE; Schema: public; Owner: powerdns
--

CREATE TABLE public.comments (
id integer NOT NULL,
domain_id integer NOT NULL,
name character varying(255) NOT NULL,
type character varying(10) NOT NULL,
modified_at integer NOT NULL,
account character varying(40) DEFAULT NULL::character varying,
comment character varying(65535) NOT NULL,
CONSTRAINT c_lowercase_name CHECK (((name)::text = lower((name)::text)))
);

ALTER TABLE public.comments OWNER TO powerdns;

--
-- Name: comments_id_seq; Type: SEQUENCE; Schema: public; Owner: powerdns
--

CREATE SEQUENCE public.comments_id_seq
AS integer
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;

ALTER TABLE public.comments_id_seq OWNER TO powerdns;

--
-- Name: comments_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: powerdns
--

ALTER SEQUENCE public.comments_id_seq OWNED BY public.comments.id;

--
-- Name: cryptokeys; Type: TABLE; Schema: public; Owner: powerdns
--

CREATE TABLE public.cryptokeys (
id integer NOT NULL,
domain_id integer,
flags integer NOT NULL,
active boolean,
content text
);

ALTER TABLE public.cryptokeys OWNER TO powerdns;

--
-- Name: cryptokeys_id_seq; Type: SEQUENCE; Schema: public; Owner: powerdns
--

CREATE SEQUENCE public.cryptokeys_id_seq
AS integer
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;

ALTER TABLE public.cryptokeys_id_seq OWNER TO powerdns;

--
-- Name: cryptokeys_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: powerdns
--

ALTER SEQUENCE public.cryptokeys_id_seq OWNED BY public.cryptokeys.id;

--
-- Name: domainmetadata; Type: TABLE; Schema: public; Owner: powerdns
--

CREATE TABLE public.domainmetadata (
id integer NOT NULL,
domain_id integer,
kind character varying(32),
content text
);

ALTER TABLE public.domainmetadata OWNER TO powerdns;

--
-- Name: domainmetadata_id_seq; Type: SEQUENCE; Schema: public; Owner: powerdns
--

CREATE SEQUENCE public.domainmetadata_id_seq
AS integer
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;

ALTER TABLE public.domainmetadata_id_seq OWNER TO powerdns;

--
-- Name: domainmetadata_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: powerdns
--

ALTER SEQUENCE public.domainmetadata_id_seq OWNED BY public.domainmetadata.id;

--
-- Name: domains; Type: TABLE; Schema: public; Owner: powerdns
--

CREATE TABLE public.domains (
id integer NOT NULL,
name character varying(255) NOT NULL,
master character varying(128) DEFAULT NULL::character varying,
last_check integer,
type character varying(6) NOT NULL,
notified_serial integer,
account character varying(40) DEFAULT NULL::character varying,
CONSTRAINT c_lowercase_name CHECK (((name)::text = lower((name)::text)))
);

ALTER TABLE public.domains OWNER TO powerdns;

--
-- Name: domains_id_seq; Type: SEQUENCE; Schema: public; Owner: powerdns
--

CREATE SEQUENCE public.domains_id_seq
AS integer
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;

ALTER TABLE public.domains_id_seq OWNER TO powerdns;

--
-- Name: domains_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: powerdns
--

ALTER SEQUENCE public.domains_id_seq OWNED BY public.domains.id;

--
-- Name: migrations; Type: TABLE; Schema: public; Owner: powerdns
--

CREATE TABLE public.migrations (
domain_id character varying(255),
record_id integer
);

ALTER TABLE public.migrations OWNER TO powerdns;

--
-- Name: perm_items; Type: TABLE; Schema: public; Owner: powerdns
--

CREATE TABLE public.perm_items (
id integer NOT NULL,
name character varying(64),
descr character varying(1024)
);

ALTER TABLE public.perm_items OWNER TO powerdns;

--
-- Name: perm_items_id_seq; Type: SEQUENCE; Schema: public; Owner: powerdns
--

CREATE SEQUENCE public.perm_items_id_seq
AS integer
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;

ALTER TABLE public.perm_items_id_seq OWNER TO powerdns;

--
-- Name: perm_items_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: powerdns
--

ALTER SEQUENCE public.perm_items_id_seq OWNED BY public.perm_items.id;

--
-- Name: perm_templ; Type: TABLE; Schema: public; Owner: powerdns
--

CREATE TABLE public.perm_templ (
id integer NOT NULL,
name character varying(128),
descr character varying(1024)
);

ALTER TABLE public.perm_templ OWNER TO powerdns;

--
-- Name: perm_templ_id_seq; Type: SEQUENCE; Schema: public; Owner: powerdns
--

CREATE SEQUENCE public.perm_templ_id_seq
AS integer
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;

ALTER TABLE public.perm_templ_id_seq OWNER TO powerdns;

--
-- Name: perm_templ_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: powerdns
--

ALTER SEQUENCE public.perm_templ_id_seq OWNED BY public.perm_templ.id;

--
-- Name: perm_templ_items; Type: TABLE; Schema: public; Owner: powerdns
--

CREATE TABLE public.perm_templ_items (
id integer NOT NULL,
templ_id integer,
perm_id integer
);

ALTER TABLE public.perm_templ_items OWNER TO powerdns;

--
-- Name: perm_templ_items_id_seq; Type: SEQUENCE; Schema: public; Owner: powerdns
--

CREATE SEQUENCE public.perm_templ_items_id_seq
AS integer
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;

ALTER TABLE public.perm_templ_items_id_seq OWNER TO powerdns;

--
-- Name: perm_templ_items_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: powerdns
--

ALTER SEQUENCE public.perm_templ_items_id_seq OWNED BY public.perm_templ_items.id;

--
-- Name: records; Type: TABLE; Schema: public; Owner: powerdns
--

CREATE TABLE public.records (
id bigint NOT NULL,
domain_id integer,
name character varying(255) DEFAULT NULL::character varying,
type character varying(10) DEFAULT NULL::character varying,
content character varying(65535) DEFAULT NULL::character varying,
ttl integer,
prio integer,
change_date integer,
disabled boolean DEFAULT false,
ordername character varying(255),
auth boolean DEFAULT true,
CONSTRAINT c_lowercase_name CHECK (((name)::text = lower((name)::text)))
);

ALTER TABLE public.records OWNER TO powerdns;

--
-- Name: records_id_seq; Type: SEQUENCE; Schema: public; Owner: powerdns
--

CREATE SEQUENCE public.records_id_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;

ALTER TABLE public.records_id_seq OWNER TO powerdns;

--
-- Name: records_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: powerdns
--

ALTER SEQUENCE public.records_id_seq OWNED BY public.records.id;

--
-- Name: records_zone_templ; Type: TABLE; Schema: public; Owner: powerdns
--

CREATE TABLE public.records_zone_templ (
domain_id integer,
record_id integer,
zone_templ_id integer
);

ALTER TABLE public.records_zone_templ OWNER TO powerdns;

--
-- Name: supermasters; Type: TABLE; Schema: public; Owner: powerdns
--

CREATE TABLE public.supermasters (
ip inet NOT NULL,
nameserver character varying(255) NOT NULL,
account character varying(40) NOT NULL
);

ALTER TABLE public.supermasters OWNER TO powerdns;

--
-- Name: tsigkeys; Type: TABLE; Schema: public; Owner: powerdns
--

CREATE TABLE public.tsigkeys (
id integer NOT NULL,
name character varying(255),
algorithm character varying(50),
secret character varying(255),
CONSTRAINT c_lowercase_name CHECK (((name)::text = lower((name)::text)))
);

ALTER TABLE public.tsigkeys OWNER TO powerdns;

--
-- Name: tsigkeys_id_seq; Type: SEQUENCE; Schema: public; Owner: powerdns
--

CREATE SEQUENCE public.tsigkeys_id_seq
AS integer
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;

ALTER TABLE public.tsigkeys_id_seq OWNER TO powerdns;

--
-- Name: tsigkeys_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: powerdns
--

ALTER SEQUENCE public.tsigkeys_id_seq OWNED BY public.tsigkeys.id;

--
-- Name: users; Type: TABLE; Schema: public; Owner: powerdns
--

CREATE TABLE public.users (
id integer NOT NULL,
username character varying(64),
password character varying(128),
fullname character varying(255),
email character varying(255),
description character varying(1024),
perm_templ integer,
active integer,
use_ldap integer
);

ALTER TABLE public.users OWNER TO powerdns;

--
-- Name: users_id_seq; Type: SEQUENCE; Schema: public; Owner: powerdns
--

CREATE SEQUENCE public.users_id_seq
AS integer
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;

ALTER TABLE public.users_id_seq OWNER TO powerdns;

--
-- Name: users_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: powerdns
--

ALTER SEQUENCE public.users_id_seq OWNED BY public.users.id;

--
-- Name: zone_templ; Type: TABLE; Schema: public; Owner: powerdns
--

CREATE TABLE public.zone_templ (
id integer NOT NULL,
name character varying(128),
descr character varying(1024),
owner integer
);

ALTER TABLE public.zone_templ OWNER TO powerdns;

--
-- Name: zone_templ_id_seq; Type: SEQUENCE; Schema: public; Owner: powerdns
--

CREATE SEQUENCE public.zone_templ_id_seq
AS integer
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;

ALTER TABLE public.zone_templ_id_seq OWNER TO powerdns;

--
-- Name: zone_templ_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: powerdns
--

ALTER SEQUENCE public.zone_templ_id_seq OWNED BY public.zone_templ.id;

--
-- Name: zone_templ_records; Type: TABLE; Schema: public; Owner: powerdns
--

CREATE TABLE public.zone_templ_records (
id integer NOT NULL,
zone_templ_id integer,
name character varying(255),
type character varying(6),
content character varying(255),
ttl integer,
prio integer
);

ALTER TABLE public.zone_templ_records OWNER TO powerdns;

--
-- Name: zone_templ_records_id_seq; Type: SEQUENCE; Schema: public; Owner: powerdns
--

CREATE SEQUENCE public.zone_templ_records_id_seq
AS integer
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;

ALTER TABLE public.zone_templ_records_id_seq OWNER TO powerdns;

--
-- Name: zone_templ_records_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: powerdns
--

ALTER SEQUENCE public.zone_templ_records_id_seq OWNED BY public.zone_templ_records.id;

--
-- Name: zones; Type: TABLE; Schema: public; Owner: powerdns
--

CREATE TABLE public.zones (
id integer NOT NULL,
domain_id integer,
owner integer,
comment character varying(1024),
zone_templ_id integer
);

ALTER TABLE public.zones OWNER TO powerdns;

--
-- Name: zones_id_seq; Type: SEQUENCE; Schema: public; Owner: powerdns
--

CREATE SEQUENCE public.zones_id_seq
AS integer
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;

ALTER TABLE public.zones_id_seq OWNER TO powerdns;

--
-- Name: zones_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: powerdns
--

ALTER SEQUENCE public.zones_id_seq OWNED BY public.zones.id;

--
-- Name: comments id; Type: DEFAULT; Schema: public; Owner: powerdns
--

ALTER TABLE ONLY public.comments ALTER COLUMN id SET DEFAULT nextval('public.comments_id_seq'::regclass);

--
-- Name: cryptokeys id; Type: DEFAULT; Schema: public; Owner: powerdns
--

ALTER TABLE ONLY public.cryptokeys ALTER COLUMN id SET DEFAULT nextval('public.cryptokeys_id_seq'::regclass);

--
-- Name: domainmetadata id; Type: DEFAULT; Schema: public; Owner: powerdns
--

ALTER TABLE ONLY public.domainmetadata ALTER COLUMN id SET DEFAULT nextval('public.domainmetadata_id_seq'::regclass);

--
-- Name: domains id; Type: DEFAULT; Schema: public; Owner: powerdns
--

ALTER TABLE ONLY public.domains ALTER COLUMN id SET DEFAULT nextval('public.domains_id_seq'::regclass);

--
-- Name: perm_items id; Type: DEFAULT; Schema: public; Owner: powerdns
--

ALTER TABLE ONLY public.perm_items ALTER COLUMN id SET DEFAULT nextval('public.perm_items_id_seq'::regclass);

--
-- Name: perm_templ id; Type: DEFAULT; Schema: public; Owner: powerdns
--

ALTER TABLE ONLY public.perm_templ ALTER COLUMN id SET DEFAULT nextval('public.perm_templ_id_seq'::regclass);

--
-- Name: perm_templ_items id; Type: DEFAULT; Schema: public; Owner: powerdns
--

ALTER TABLE ONLY public.perm_templ_items ALTER COLUMN id SET DEFAULT nextval('public.perm_templ_items_id_seq'::regclass);

--
-- Name: records id; Type: DEFAULT; Schema: public; Owner: powerdns
--

ALTER TABLE ONLY public.records ALTER COLUMN id SET DEFAULT nextval('public.records_id_seq'::regclass);

--
-- Name: tsigkeys id; Type: DEFAULT; Schema: public; Owner: powerdns
--

ALTER TABLE ONLY public.tsigkeys ALTER COLUMN id SET DEFAULT nextval('public.tsigkeys_id_seq'::regclass);

--
-- Name: users id; Type: DEFAULT; Schema: public; Owner: powerdns
--

ALTER TABLE ONLY public.users ALTER COLUMN id SET DEFAULT nextval('public.users_id_seq'::regclass);

--
-- Name: zone_templ id; Type: DEFAULT; Schema: public; Owner: powerdns
--

ALTER TABLE ONLY public.zone_templ ALTER COLUMN id SET DEFAULT nextval('public.zone_templ_id_seq'::regclass);

--
-- Name: zone_templ_records id; Type: DEFAULT; Schema: public; Owner: powerdns
--

ALTER TABLE ONLY public.zone_templ_records ALTER COLUMN id SET DEFAULT nextval('public.zone_templ_records_id_seq'::regclass);

--
-- Name: zones id; Type: DEFAULT; Schema: public; Owner: powerdns
--

ALTER TABLE ONLY public.zones ALTER COLUMN id SET DEFAULT nextval('public.zones_id_seq'::regclass);

--
-- Name: comments comments_pkey; Type: CONSTRAINT; Schema: public; Owner: powerdns
--

ALTER TABLE ONLY public.comments
ADD CONSTRAINT comments_pkey PRIMARY KEY (id);

--
-- Name: cryptokeys cryptokeys_pkey; Type: CONSTRAINT; Schema: public; Owner: powerdns
--

ALTER TABLE ONLY public.cryptokeys
ADD CONSTRAINT cryptokeys_pkey PRIMARY KEY (id);

--
-- Name: domainmetadata domainmetadata_pkey; Type: CONSTRAINT; Schema: public; Owner: powerdns
--

ALTER TABLE ONLY public.domainmetadata
ADD CONSTRAINT domainmetadata_pkey PRIMARY KEY (id);

--
-- Name: domains domains_pkey; Type: CONSTRAINT; Schema: public; Owner: powerdns
--

ALTER TABLE ONLY public.domains
ADD CONSTRAINT domains_pkey PRIMARY KEY (id);

--
-- Name: perm_items perm_items_pkey; Type: CONSTRAINT; Schema: public; Owner: powerdns
--

ALTER TABLE ONLY public.perm_items
ADD CONSTRAINT perm_items_pkey PRIMARY KEY (id);

--
-- Name: perm_templ_items perm_templ_items_pkey; Type: CONSTRAINT; Schema: public; Owner: powerdns
--

ALTER TABLE ONLY public.perm_templ_items
ADD CONSTRAINT perm_templ_items_pkey PRIMARY KEY (id);

--
-- Name: perm_templ perm_templ_pkey; Type: CONSTRAINT; Schema: public; Owner: powerdns
--

ALTER TABLE ONLY public.perm_templ
ADD CONSTRAINT perm_templ_pkey PRIMARY KEY (id);

--
-- Name: records records_pkey; Type: CONSTRAINT; Schema: public; Owner: powerdns
--

ALTER TABLE ONLY public.records
ADD CONSTRAINT records_pkey PRIMARY KEY (id);

--
-- Name: supermasters supermasters_pkey; Type: CONSTRAINT; Schema: public; Owner: powerdns
--

ALTER TABLE ONLY public.supermasters
ADD CONSTRAINT supermasters_pkey PRIMARY KEY (ip, nameserver);

--
-- Name: tsigkeys tsigkeys_pkey; Type: CONSTRAINT; Schema: public; Owner: powerdns
--

ALTER TABLE ONLY public.tsigkeys
ADD CONSTRAINT tsigkeys_pkey PRIMARY KEY (id);

--
-- Name: users users_pkey; Type: CONSTRAINT; Schema: public; Owner: powerdns
--

ALTER TABLE ONLY public.users
ADD CONSTRAINT users_pkey PRIMARY KEY (id);

--
-- Name: zone_templ zone_templ_pkey; Type: CONSTRAINT; Schema: public; Owner: powerdns
--

ALTER TABLE ONLY public.zone_templ
ADD CONSTRAINT zone_templ_pkey PRIMARY KEY (id);

--
-- Name: zone_templ_records zone_templ_records_pkey; Type: CONSTRAINT; Schema: public; Owner: powerdns
--

ALTER TABLE ONLY public.zone_templ_records
ADD CONSTRAINT zone_templ_records_pkey PRIMARY KEY (id);

--
-- Name: zones zones_pkey; Type: CONSTRAINT; Schema: public; Owner: powerdns
--

ALTER TABLE ONLY public.zones
ADD CONSTRAINT zones_pkey PRIMARY KEY (id);

--
-- Name: comments_domain_id_idx; Type: INDEX; Schema: public; Owner: powerdns
--

CREATE INDEX comments_domain_id_idx ON public.comments USING btree (domain_id);

--
-- Name: comments_name_type_idx; Type: INDEX; Schema: public; Owner: powerdns
--

CREATE INDEX comments_name_type_idx ON public.comments USING btree (name, type);

--
-- Name: comments_order_idx; Type: INDEX; Schema: public; Owner: powerdns
--

CREATE INDEX comments_order_idx ON public.comments USING btree (domain_id, modified_at);

--
-- Name: domain_id; Type: INDEX; Schema: public; Owner: powerdns
--

CREATE INDEX domain_id ON public.records USING btree (domain_id);

--
-- Name: domainidindex; Type: INDEX; Schema: public; Owner: powerdns
--

CREATE INDEX domainidindex ON public.cryptokeys USING btree (domain_id);

--
-- Name: domainidmetaindex; Type: INDEX; Schema: public; Owner: powerdns
--

CREATE INDEX domainidmetaindex ON public.domainmetadata USING btree (domain_id);

--
-- Name: name_index; Type: INDEX; Schema: public; Owner: powerdns
--

CREATE UNIQUE INDEX name_index ON public.domains USING btree (name);

--
-- Name: namealgoindex; Type: INDEX; Schema: public; Owner: powerdns
--

CREATE UNIQUE INDEX namealgoindex ON public.tsigkeys USING btree (name, algorithm);

--
-- Name: nametype_index; Type: INDEX; Schema: public; Owner: powerdns
--

CREATE INDEX nametype_index ON public.records USING btree (name, type);

--
-- Name: rec_name_index; Type: INDEX; Schema: public; Owner: powerdns
--

CREATE INDEX rec_name_index ON public.records USING btree (name);

--
-- Name: recordorder; Type: INDEX; Schema: public; Owner: powerdns
--

CREATE INDEX recordorder ON public.records USING btree (domain_id, ordername text_pattern_ops);

--
-- Name: cryptokeys cryptokeys_domain_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: powerdns
--

ALTER TABLE ONLY public.cryptokeys
ADD CONSTRAINT cryptokeys_domain_id_fkey FOREIGN KEY (domain_id) REFERENCES public.domains(id) ON DELETE CASCADE;

--
-- Name: records domain_exists; Type: FK CONSTRAINT; Schema: public; Owner: powerdns
--

ALTER TABLE ONLY public.records
ADD CONSTRAINT domain_exists FOREIGN KEY (domain_id) REFERENCES public.domains(id) ON DELETE CASCADE;

--
-- Name: comments domain_exists; Type: FK CONSTRAINT; Schema: public; Owner: powerdns
--

ALTER TABLE ONLY public.comments
ADD CONSTRAINT domain_exists FOREIGN KEY (domain_id) REFERENCES public.domains(id) ON DELETE CASCADE;

--
-- Name: domainmetadata domainmetadata_domain_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: powerdns
--

ALTER TABLE ONLY public.domainmetadata
ADD CONSTRAINT domainmetadata_domain_id_fkey FOREIGN KEY (domain_id) REFERENCES public.domains(id) ON DELETE CASCADE;

--
-- PostgreSQL database dump complete
--

```

@@ Line 2: / Line 2: @@
 - https://github.com/ngoduykhanh/PowerDNS-Admin/blob/master/docker-compose.yml
 - https://github.com/PowerDNS/pdns/wiki/WebFrontends
 # Installing PowerDNS

← Older revision		Revision as of 00:30, 18 November 2020
Line 1:		Line 1:
		+	# Links
		+	- https://github.com/ngoduykhanh/PowerDNS-Admin/blob/master/docker-compose.yml
		+	- https://github.com/PowerDNS/pdns/wiki/WebFrontends
		+
	# Installing PowerDNS		# Installing PowerDNS

PowerDNS - Revision history

Busk at 01:14, 18 November 2020

Busk at 00:30, 18 November 2020

imported>Busk at 17:08, 13 June 2019