> On 19 Feb 2015, at 22:37, k...@rice.edu wrote: > On Thu, Feb 19, 2015 at 03:34:06PM -0600, Nick Williams wrote: >> The schema for PDNS 3.0 shows no "ordername" column or "orderindex" index on >> the records table: >> https://github.com/PowerDNS/pdns/blob/auth-3.0/pdns/no-dnssec.schema.pgsql.sql >> >> And the upgrade instructions for 3.0 -> 3.1 don't include an alter statement >> for adding the "ordername" column or "orderindex" index: >> https://doc.powerdns.com/md/authoritative/upgrading/#30-to-31 >> >> But the upgrade instructions for 3.1 -> 3.2 includes an alter statement for >> _modifying_ the "ordername" column and _dropping_ the "orderindex" index >> that were never added: >> https://doc.powerdns.com/md/authoritative/upgrading/#31-to-32 >> >> […]
>> Can someone provide me some perspective on this? ordername was added in 3.0, as part of the DNSSEC schema upgrade. (see https://github.com/PowerDNS/pdns/blob/auth-3.0/pdns/dnssec.schema.pgsql.sql ) > […] The ALTER TABLE will only apply to previously existing > tables, not create the needed new ones. The upgrade SQL scripts in general add/modify tables and columns. The instructions for upgrading to 3.4.0 include consolidated update scripts, see https://doc.powerdns.com/md/authoritative/upgrading/#database-schema . Pick the backend and schema type you currently have (if you come from 2.9.22, it’s always the ‘non-dnssec’ type), and you’ll end up with the correct schema. Best, -- Christian Hofstaedtler / Deduktiva GmbH (FN 418592 b, HG Wien) www.deduktiva.com / +43 1 353 1707 _______________________________________________ Pdns-users mailing list Pdns-users@mailman.powerdns.com http://mailman.powerdns.com/mailman/listinfo/pdns-users