The NetBSD Project

CVS log for pkgsrc/databases/postgresql18-server/files/pgsql.sh

[BACK] Up to [cvs.NetBSD.org] / pkgsrc / databases / postgresql18-server / files

Request diff between arbitrary revisions


Keyword substitution: kv
Default branch: MAIN


Revision 1.3: download - view: text, markup, annotated - select for diffs
Sun Oct 4 12:09:32 2026 UTC (6 weeks ago) by gdt
Branches: MAIN
CVS tags: HEAD
Diff to: previous 1.2: preferred, colored
Changes since revision 1.2: +19 -1 lines
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.

Revision 1.2: download - view: text, markup, annotated - select for diffs
Fri Oct 2 18:11:09 2026 UTC (6 weeks, 2 days ago) by gdt
Branches: MAIN
Diff to: previous 1.1: preferred, colored
Changes since revision 1.1: +2 -2 lines
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.

Revision 1.1: download - view: text, markup, annotated - select for diffs
Mon Oct 6 13:30:24 2025 UTC (13 months, 1 week ago) by adam
Branches: MAIN
CVS tags: pkgsrc-2026Q3-base, pkgsrc-2026Q3, pkgsrc-2026Q2-base, pkgsrc-2026Q2, pkgsrc-2026Q1-base, pkgsrc-2026Q1, pkgsrc-2025Q4-base, pkgsrc-2025Q4
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.

Diff request

This form allows you to request diffs between any two revisions of a file. You may select a symbolic revision name using the selection box or you may type in a numeric name using the type-in text box.

Log view options

CVSweb <webmaster@jp.NetBSD.org>