From nobody Wed May 10 11:07:56 2023 X-Original-To: dev-commits-ports-all@mlmmj.nyi.freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2610:1c1:1:606c::19:1]) by mlmmj.nyi.freebsd.org (Postfix) with ESMTP id 4QGXLj1nW9z49l6G; Wed, 10 May 2023 11:07:57 +0000 (UTC) (envelope-from git@FreeBSD.org) Received: from mxrelay.nyi.freebsd.org (mxrelay.nyi.freebsd.org [IPv6:2610:1c1:1:606c::19:3]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits) key-exchange X25519 server-signature RSA-PSS (4096 bits) server-digest SHA256 client-signature RSA-PSS (4096 bits) client-digest SHA256) (Client CN "mxrelay.nyi.freebsd.org", Issuer "R3" (verified OK)) by mx1.freebsd.org (Postfix) with ESMTPS id 4QGXLj1BPFz3BvP; Wed, 10 May 2023 11:07:57 +0000 (UTC) (envelope-from git@FreeBSD.org) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=freebsd.org; s=dkim; t=1683716877; h=from:from:reply-to:subject:subject:date:date:message-id:message-id: to:to:cc:mime-version:mime-version:content-type:content-type: content-transfer-encoding:content-transfer-encoding; bh=onzlZszAcX4Yw8oqJWwwRO0XEVuXtp3l3wKjtIJsN5g=; b=jC6vhISsVn7Ja/XBnpn7q+wTSNdKAjaTb2gbRQy1n3UXg1fS5agl3sCx79n8kCgO8FKq5V jnKx+XwNp5aYF19Doty3waRZMIQqCQ69vPZoXwYjfb6ktDjbaz0BOIJy3zgw/maAAxpIDL XIgvrj2H3xGocwFM2XDa+/Bw0Ep9h8eMTc2ymqamSq6tYjaZr1oqUyV6X4vWGXexYcUcb2 vVnnLoDmWr0owcPgoY3GIji0LBbJoLJi/u6zUizG4gnQEUsmKs8ypImGFbxhmpmcxSnWAm TyUeJxpO56ENRUUD3HfmvmDHM7lIDaoU2D0829iiyCycqdcx2oEAYFAL35n0Og== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=freebsd.org; s=dkim; t=1683716877; h=from:from:reply-to:subject:subject:date:date:message-id:message-id: to:to:cc:mime-version:mime-version:content-type:content-type: content-transfer-encoding:content-transfer-encoding; bh=onzlZszAcX4Yw8oqJWwwRO0XEVuXtp3l3wKjtIJsN5g=; b=qy/uUEiddyRhaVYfa+UpemEeJm3Mwxz5CzI1ObYbXDQereWgVa9B8F41+Y0SsmXEs/NATy vv2N1Q/X1n3nqI37b5r6qD/2qUbZfd54Izg5jfzDGeVJ9hgErc6QEGo/d9iLxEMBo1mXSh GJO7xU0sU7h3YDarupsElsKFT61peHyS+y/cTPoO7JCErligP/HTHA2WaXZ7Ri9vggQAmm 4d5bYMArTH1P8drk5egPS/3JE9/WKdikdkl4ORbT0d6yMkiwUysgQ58LbQ6+L+9QtSH4l3 qehgQDehoEl+eZjKf8dFHCj+qjnWiPEdcvtGdICFZTdGRr2LtDYrIGTK9Xs7mg== ARC-Authentication-Results: i=1; mx1.freebsd.org; none ARC-Seal: i=1; s=dkim; d=freebsd.org; t=1683716877; a=rsa-sha256; cv=none; b=fJVQOjWOCKeQx6a/NRohVYZ5Ah+PBZbn/tcNY5rlUG2CDCcqCuZNHredOEEYcZJ9+bTBr7 hw4iR3o7MWxSoZoFsxe4EGqBYBBX6RrbWcLwGhLu3tj70alVWCYr4cIXXLRfsliwKklwvB Z30o+XoTlMG/ZOY7uRMRNT6v5wesIg8OshPYyOECxYOhK+r5sWnqDCkSiQLNXsYcR498U9 drWGrBsBy4EaqXHOgAdQWbuw/EZC0Z4mFYFZVvKQxSyZx76rjqVikod9uwSRd9vo+V1xkp ZaEpqH3Nj1enoQ5zhJ27xzwALkK0Nh7ODjn4arYk1QDUMZ8L+wbt7o+6BV0Kng== Received: from gitrepo.freebsd.org (gitrepo.freebsd.org [IPv6:2610:1c1:1:6068::e6a:5]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits) key-exchange X25519 server-signature RSA-PSS (4096 bits) server-digest SHA256) (Client did not present a certificate) by mxrelay.nyi.freebsd.org (Postfix) with ESMTPS id 4QGXLh71zrz16sn; Wed, 10 May 2023 11:07:56 +0000 (UTC) (envelope-from git@FreeBSD.org) Received: from gitrepo.freebsd.org ([127.0.1.44]) by gitrepo.freebsd.org (8.16.1/8.16.1) with ESMTP id 34AB7ugS058446; Wed, 10 May 2023 11:07:56 GMT (envelope-from git@gitrepo.freebsd.org) Received: (from git@localhost) by gitrepo.freebsd.org (8.16.1/8.16.1/Submit) id 34AB7uNu058445; Wed, 10 May 2023 11:07:56 GMT (envelope-from git) Date: Wed, 10 May 2023 11:07:56 GMT Message-Id: <202305101107.34AB7uNu058445@gitrepo.freebsd.org> To: ports-committers@FreeBSD.org, dev-commits-ports-all@FreeBSD.org, dev-commits-ports-main@FreeBSD.org From: Alexey Dokuchaev Subject: git: 918701834eed - main - dns/powerdns: improve installation/upgrade instructions (pkg-message) List-Id: Commit messages for all branches of the ports repository List-Archive: https://lists.freebsd.org/archives/dev-commits-ports-all List-Help: List-Post: List-Subscribe: List-Unsubscribe: Sender: owner-dev-commits-ports-all@freebsd.org X-BeenThere: dev-commits-ports-all@freebsd.org MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 8bit X-Git-Committer: danfe X-Git-Repository: ports X-Git-Refname: refs/heads/main X-Git-Reftype: branch X-Git-Commit: 918701834eed647bbb9f4492ae2d241dda77f4d1 Auto-Submitted: auto-generated X-ThisMailContainsUnwantedMimeParts: N The branch main has been updated by danfe: URL: https://cgit.FreeBSD.org/ports/commit/?id=918701834eed647bbb9f4492ae2d241dda77f4d1 commit 918701834eed647bbb9f4492ae2d241dda77f4d1 Author: Alexey Dokuchaev AuthorDate: 2023-05-10 11:07:08 +0000 Commit: Alexey Dokuchaev CommitDate: 2023-05-10 11:07:08 +0000 dns/powerdns: improve installation/upgrade instructions (pkg-message) Fix a typo (mimimum_version -> minimum_version), wrap some very long lines for better readability, add missing Oxford commas, and replace UTF-8 quotes with ASCII ones. --- dns/powerdns/files/pkg-message.in | 65 ++++++++++++++++++++++----------------- 1 file changed, 37 insertions(+), 28 deletions(-) diff --git a/dns/powerdns/files/pkg-message.in b/dns/powerdns/files/pkg-message.in index 210aeb0cebcb..50c3b23624fe 100644 --- a/dns/powerdns/files/pkg-message.in +++ b/dns/powerdns/files/pkg-message.in @@ -1,63 +1,72 @@ [ { type: install message: <= 0 THEN -notified_serial::bigint END; - -This version needs a mandatory schema change for the gmsyql, godbc (mssql), gpgsql and gsqlite3 -backends. SQL statements are available in %%DOCSDIR%% or https://doc.powerdns.com +Autoserial support has been removed. The change_date column has been +removed from the records table in all gsql backends, but leaving it +in is harmless. + +The Generic PostgreSQL backend schema has changed: the notified_serial +column type in the domains table has been changed from INT DEFAULT NULL +to BIGINT DEFAULT NULL: + + ALTER TABLE domains ALTER notified_serial TYPE bigint USING CASE + WHEN notified_serial >= 0 THEN notified_serial::bigint END; + +This version needs a mandatory schema change for the gmsyql, godbc +(mssql), gpgsql, and gsqlite3 backends. SQL statements are available +in %%DOCSDIR%% or at https://doc.powerdns.com/. EOM } { type: upgrade maximum_version: "4.3.0" minimum_version: "4.2.0" message: <