fix permission error introduced by postgres 15 (!353) · Merge requests · ISC Open Source Projects / forge

Merged Andrei Pavel requested to merge postgres into master Jan 30, 2023

From release changes:

PostgreSQL 15 also revokes the CREATE permission from all users except a database owner from the public (or default) schema.

Initializing database using script /opt/kea/share/kea/scripts/pgsql/dhcpdb_create.pgsql
psql:/opt/kea/share/kea/scripts/pgsql/dhcpdb_create.pgsql:36: ERROR:  permission denied for schema public
LINE 1: CREATE TABLE lease4 (
                     ^
ERROR/kea-admin: Database initialization failed, status code: 3?

Tested locally on Postgres 10 and Postgres 15.