Upgrading ISC Kea DHCPv4 Server on Ubuntu 22.04
For the most part, the documentation for ISC Kea DHCPv4 Server on Ubuntu 22.04 LTS while using PostgreSQL as a backend is fine.
However, when running a PostgreSQL instance on the same server as ISC's Kea DHCPv4 Server on Ubuntu 22.04 LTS using the defaults, the PostgreSQL database is only accessable via the Unix socket /var/run/postgresql
. As such, the below adaptations to the regularly documented commands are required to run the kea-admin db-*
commands.
# Check version
sudo -u _kea kea-admin db-version pgsql -u _kea -n _kea -h /var/run/postgresql
# Upgrade schema
sudo -u _kea kea-admin db-upgrade pgsql -u _kea -n _kea -h /var/run/postgresql