Up to [cvs.NetBSD.org] / pkgsrc / databases / postgresql18-server / files
Request diff between arbitrary revisions
Keyword substitution: kv
Default branch: MAIN
databases/postgresql18-server: Warn about inadequate semaphores When run on NetBSD (without kernel options or sysctl), and using /etc/rc.d/pgsql start, this package fails to start, because Postgresql 18 needs many more semaphores than previous versions. While there is an error message in $PREFIX/pgsql/errlog, it seems helpful to give an earlier, more precise clue. This commit adds code to rc.d/pgsql, that, only on NetBSD, checks two semaphore size sysctl variables, and if below the values believed appropriate for pgsql, prints a warning, showing the current value and the implied ok value. This commit does not write sysctl values, on the theory that it's the base system's call to set resource limits, and packages should not override them. (A proposal to increase semaphore limits from the values used in 1993 drew an objection.) It's likely that pgsql should use POSIX semaphores instead on NetBSD, but that's a bigger change. This code is really easy to remove, if that happens. As discussed on pkgsrc-users@ in July, without objection.
databases/postgresql18-server: Drop duplicate -p in rc.d script
While "${MKDIR} -p" looks right, the variable already has -p, so drop
the extra one.
Reported by Luis Falcon, and fix proposed on netbsd-users@ with
$MAINTAINER CC without objections.
postgresql18: added version 18.0 PostgreSQL 18 improves performance for workloads of all sizes through a new I/O subsystem that has demonstrated up to 3× performance improvements when reading from storage, and also increases the number of queries that can use indexes. This release makes major-version upgrades less disruptive, accelerating upgrade times and reducing the time required to reach expected performance after an upgrade completes. Developers also benefit from PostgreSQL 18 features, including virtual generated columns that compute values at query time, and the database-friendly uuidv7() function that provides better indexing and read performance for UUIDs. PostgreSQL 18 makes it easier to integrate with single-sign on (SSO) systems with support for OAuth 2.0 authentication.