[Kea-users] Host reservations in PostgreSQL (was Host reservations in DB)

[Shane Kerr]

Tomek,

(Apologies for the delayed reply. Christmas vacation happened.)

At 2015-12-18 13:58:08 +0100
Tomek Mrugalski <tomasz at isc.org> wrote:

> On 18.12.2015 07:12, Михаил Ермаков wrote:
> > Hi everybody!
> > 
> > It's not clear for me how Kea stores address reservations of hosts.
> > There is something about it in 1.0.0-beta release notes "Leases and
> > (DHCPv4)host reservations stored in MySQL or Postgres".  
> Does it say MySQL or Postgres? Uh oh, in this case it's a mistake.
> Storing host reservations is supported in MySQL only.

What's the reason for this? Is it just that the schema for PostgreSQL
hasn't been devised yet? Or are there MySQL-only features that are used
(perhaps specific functions or data structures)?

I ask because if it's a schema issue then I'm happy to attempt this,
because I kind of want this for my environment. :) (I could switch to
MySQL, but I'd prefer to avoid that since I have a working setup and
also I would have to figure out which of the 32 forks of MySQL to
use....) ;)

Cheers,

--
Shane