[Pkg-pdns-maintainers] Bug#707761: pdns-backend-pgsql: IP fields too short for master/slave operation over IPv6

James Cloos cloos at jhcloos.com
Thu May 30 15:00:54 UTC 2013


The ip column should not be varchar or text.

It should be inet.

The proper fix is:

  alter table supermasters alter COLUMN ip type inet using ip::inet;

and change the sql which creates the table during install to use inet
for that column.

That column is only supposed to hold ipv4 or ipv6 addresses, which is
exactly what the inet type is for.

As an added bonus, inet stores the address as an integer, so it should
take up less space than a text/varchar/char column.

-JimC
-- 
James Cloos <cloos at jhcloos.com>         OpenPGP: 1024D/ED7DAEA6



More information about the Pkg-pdns-maintainers mailing list