1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
|
[
{ type: install
message: <<EOM
Enable PowerDNS in /etc/rc.conf(.local) or in /etc/rc.conf.d/pdns
with the following line:
pdns_enable="YES"
A configuration template is available in %%PREFIX%%/etc/pdns as
pdns.conf-dist.
A pdns.conf with all possible options is available in
%%EXAMPLESDIR%%.
Initialization file(s) for your database backend(s) are available
in %%DOCSDIR%% as "schema.X.sql".
EOM
}
{ type: upgrade
maximum_version: "3.4.0"
message: <<EOM
This version needs a mandatory schema change for the gmysql, gpgsql,
and gsqlite3 backends. SQL statements are available in
%%DOCSDIR%% or at https://doc.powerdns.com/.
EOM
}
{ type: upgrade
maximum_version: "4.2.0"
minimum_version: "4.0.0"
message: <<EOM
Autoserial support has been removed. The change_date column has been
removed from the records table in all gsql backends, but leaving it
in is harmless.
The Generic PostgreSQL backend schema has changed: the notified_serial
column type in the domains table has been changed from INT DEFAULT NULL
to BIGINT DEFAULT NULL:
ALTER TABLE domains ALTER notified_serial TYPE bigint USING CASE
WHEN notified_serial >= 0 THEN notified_serial::bigint END;
This version needs a mandatory schema change for the gmsyql, godbc
(mssql), gpgsql, and gsqlite3 backends. SQL statements are available
in %%DOCSDIR%% or at https://doc.powerdns.com/.
EOM
}
{ type: upgrade
maximum_version: "4.3.0"
minimum_version: "4.2.0"
message: <<EOM
MyDNS and OpenDBX backends had been removed per https://Blog.PowerDNS.com/2019/10/17/backend-removals-in-the-upcoming-authoritative-server-release/.
The new "unpublished DNSSEC keys" feature comes with a mandatory schema
change for all database backends (including BIND with a DNSSEC database).
This version needs a mandatory schema change for the gmsyql, godbc(mssql),
gpgsql, and gsqlite3 backends. SQL statements are available in
%%DOCSDIR%% or at https://doc.powerdns.com/.
For the LMDB backend, please review lmdb-schema-version (https://doc.powerdns.com/authoritative/backends/lmdb.html#setting-lmdb-schema-version).
EOM
}
{ type: upgrade
minimum_version: "4.3.0"
maximum_version: "4.7.0"
message: <<EOM
This version needs a mandatory schema change for gmysql, godbc (mssql),
gpsql, and gsqlite3 backends.
SQL statements are available at https://github.com/PowerDNS/pdns/blob/master/modules in their respective subfolders as "4.3.0_to_4.7.0_schema.xxsql.sql".
EOM
}
]
|
