Starting ...git clone https://codeberg.org/decke/ports.git /usr/local/caronade/work/poudriere.143i386/repo.git Cloning into '/usr/local/caronade/work/poudriere.143i386/repo.git'... git -C "/usr/local/caronade/work/poudriere.143i386/repo.git" -c advice.detachedHead=false checkout b8d27e7dfa6b37edf569ec83916928fa0e0384ab HEAD is now at b8d27e7 databases/pgjwt: PostgreSQL extension implementation of JSON Web Tokens poudriere ports -u -p 143i386 [00:00:00] Updating portstree "143i386" with git+http... done zfs snapshot zroot/poudriere/ports/143i386@clean overlay for audio/shortwave overlay for databases/pgjwt overlay for databases/pgsql-http overlay for devel/efivar overlay for devel/esp-idf overlay for devel/kodi-platform overlay for dns/dnscontrol overlay for mail/smtprelay overlay for multimedia/dtv-scan-tables overlay for multimedia/dvb-apps overlay for multimedia/kodi-addon-inputstream.adaptive overlay for multimedia/kodi-addon-pvr.hts overlay for multimedia/kodi-addon-pvr.iptvsimple overlay for multimedia/kodi overlay for multimedia/libdvbcsa overlay for multimedia/libudfread overlay for multimedia/minisatip overlay for multimedia/tvheadend overlay for net/srelay overlay for net/wireguard-go overlay for net/wireguard-kmod overlay for net/wireguard-tools overlay for net/wireguard overlay for ports-mgmt/caronade overlay for security/glauth overlay for security/vouch-proxy overlay for sysutils/containerd overlay for sysutils/fwupd-efi overlay for sysutils/fwupd overlay for sysutils/gnome-firmware overlay for sysutils/zli overlay for sysutils/zot overlay for textproc/libjcat overlay for www/mattermost-server overlay for www/mattermost-webapp overlay for www/miniflux overlay for www/radicale overlay for www/yarr overlay for x11-toolkits/py-pangocffi poudriere testport -b latest -j 143i386 -p 143i386 databases/pgjwt [00:00:00] Creating the reference jail... done [00:00:01] Mounting system devices for 143i386-143i386 [00:00:01] Stashing existing package repository [00:00:01] Mounting ports from: /usr/local/poudriere/ports/143i386 [00:00:01] Mounting packages from: /data/packages/143i386-143i386 [00:00:01] Mounting distfiles from: /usr/ports/distfiles /etc/resolv.conf -> /data/.m/143i386-143i386/ref/etc/resolv.conf [00:00:01] Starting jail 143i386-143i386 Updating /var/run/os-release done. [00:00:01] Will build as nobody:nobody (65534:65534) [00:00:03] Ports supports: FLAVORS SUBPACKAGES SELECTED_OPTIONS [00:00:03] Inspecting ports tree for modifications to git checkout... yes [00:00:04] Ports top-level git hash: 5a5039a587 (dirty) [00:00:04] Logs: /data/logs/bulk/143i386-143i386/2025-12-07_12h58m52s [00:00:04] Loading MOVED for /data/.m/143i386-143i386/ref/usr/ports [00:00:04] Gathering ports metadata [00:00:05] Calculating ports order and dependencies [00:00:05] Trimming IGNORED and blacklisted ports [00:00:05] Package fetch: Looking for missing packages to fetch from pkg+http://pkg.FreeBSD.org/${ABI}/latest Updating FreeBSD repository catalogue... [143i386-143i386] Fetching meta.conf: . done [143i386-143i386] Fetching data.pkg: .......... done Processing entries: .......... done FreeBSD repository update completed. 35559 packages processed. Updating FreeBSD-kmods repository catalogue... [143i386-143i386] Fetching meta.conf: . done [143i386-143i386] Fetching data.pkg: .. done Processing entries: ........ done FreeBSD-kmods repository update completed. 74 packages processed. All repositories are up to date. [00:00:21] Package fetch: Will fetch 6 packages from remote or local pkg cache The following packages will be fetched: New packages to be FETCHED: postgresql17-client: 17.7_2 (4 MiB: 14.55% of the 25 MiB to download) postgresql17-server: 17.7_1 (15 MiB: 59.88% of the 25 MiB to download) py311-hatchling: 1.28.0 (154 KiB: 0.61% of the 25 MiB to download) py311-myst-parser: 4.0.1_1 (191 KiB: 0.76% of the 25 MiB to download) py311-recommonmark: 0.5.0_3 (24 KiB: 0.10% of the 25 MiB to download) swig: 4.3.1 (6 MiB: 24.10% of the 25 MiB to download) Number of packages to be fetched: 6 The process will require 25 MiB more space. 25 MiB to be downloaded. [143i386-143i386] Fetching py311-myst-parser-4.0.1_1~d7290ccbaa.pkg: ....... done [143i386-143i386] Fetching swig-4.3.1~0e8ef2d618.pkg: .......... done [143i386-143i386] Fetching postgresql17-server-17.7_1~7f006ed86a.pkg: .......... done [143i386-143i386] Fetching py311-hatchling-1.28.0~4ddbb39185.pkg: ...... done [143i386-143i386] Fetching py311-recommonmark-0.5.0_3~177de39036.pkg: . done [143i386-143i386] Fetching postgresql17-client-17.7_2~99c231df6f.pkg: .......... done [00:00:23] Package fetch: Using cached copy of postgresql17-server-17.7_1 [00:00:23] Package fetch: Using cached copy of postgresql17-client-17.7_2 [00:00:23] Package fetch: Using cached copy of py311-hatchling-1.28.0 [00:00:23] Package fetch: Using cached copy of py311-myst-parser-4.0.1_1 [00:00:23] Package fetch: Using cached copy of py311-recommonmark-0.5.0_3 [00:00:23] Package fetch: Using cached copy of swig-4.3.1 [00:00:23] Sanity checking the repository [00:00:23] Checking packages for incremental rebuild needs [00:00:23] Deleting cmake-core-3.31.9.pkg: new version: 3.31.10 [00:00:23] Deleting postgresql17-client-17.6_1.pkg: new version: 17.7_2 [00:00:23] Deleting postgresql17-server-17.6.pkg: new version: 17.7_1 [00:00:23] Deleting py311-hatchling-1.27.0.pkg: new version: 1.28.0 [00:00:23] Deleting swig-4.2.1.pkg: new version: 4.3.1 [00:00:24] Deleting llvm19-19.1.7_1.pkg: missing dependency: libedit-3.1.20250104,1 [00:00:24] Deleting lua53-5.3.6_1.pkg: missing dependency: libedit-3.1.20250104,1 [00:00:24] Deleting lua54-5.4.8.pkg: missing dependency: libedit-3.1.20250104,1 [00:00:24] Deleting postgresql17-server-17.7_1.pkg: missing dependency: llvm19-19.1.7_1 [00:00:24] Deleting py311-hatch-vcs-0.5.0.pkg: missing dependency: py311-hatchling-1.27.0 [00:00:24] Deleting py311-sphinx-markdown-tables-0.0.17_2,1.pkg: missing dependency: py311-markdown-3.9 [00:00:24] Deleting stale symlinks... done [00:00:24] Deleting empty directories... done [00:00:24] Package fetch: Generating logs for fetched packages [00:00:26] Unqueueing existing packages [00:00:26] Unqueueing orphaned build dependencies [00:00:26] Sanity checking build queue [00:00:26] Processing PRIORITY_BOOST [00:00:26] Balancing pool [00:00:26] Recording filesystem state for prepkg... done [00:00:27] Building 5 packages using up to 5 builders [00:00:27] Hit CTRL+t at any time to see build progress and stats [00:00:27] [01] [00:00:00] Builder starting [00:00:27] [02] [00:00:00] Builder starting [00:00:27] [03] [00:00:00] Builder starting [00:00:27] [01] [00:00:00] Builder started [00:00:27] [01] [00:00:00] Building devel/cmake-core | cmake-core-3.31.10 [00:00:27] [02] [00:00:00] Builder started [00:00:27] [03] [00:00:00] Builder started [00:00:27] [02] [00:00:00] Building textproc/py-sphinx-markdown-tables@py311 | py311-sphinx-markdown-tables-0.0.17_2,1 [00:00:27] [03] [00:00:00] Building lang/lua53 | lua53-5.3.6_1 [00:00:31] [02] [00:00:04] Finished textproc/py-sphinx-markdown-tables@py311 | py311-sphinx-markdown-tables-0.0.17_2,1: Success [00:00:35] [03] [00:00:08] Finished lang/lua53 | lua53-5.3.6_1: Success [00:34:22] [01] [00:33:55] Finished devel/cmake-core | cmake-core-3.31.10: Success [00:34:23] [01] [00:00:00] Building devel/llvm19@default | llvm19-19.1.7_1 [08:04:00] [01] [07:29:37] Finished devel/llvm19@default | llvm19-19.1.7_1: Success [08:04:01] [01] [00:00:00] Building databases/postgresql17-server | postgresql17-server-17.7_1 [08:11:55] [01] [00:07:54] Finished databases/postgresql17-server | postgresql17-server-17.7_1: Success [08:11:55] Stopping 5 builders [08:11:57] Creating pkg repository Creating repository in /tmp/packages: .......... done Packing files for repository: .... done [08:12:14] Committing packages to repository: /data/packages/143i386-143i386/.real_1765141867 via .latest symlink [08:12:14] Removing old packages [08:12:14] Building with flags: [08:12:14] Removing existing /usr/local build started at Sun Dec 7 21:11:07 UTC 2025 port directory: /usr/ports/databases/pgjwt package name: postgresql17-pgjwt-2.0 building for: FreeBSD 143i386-143i386 14.3-RELEASE-p4 FreeBSD 14.3-RELEASE-p4 i386 maintained by: lukas.engelhardt@gmx.de Makefile datestamp: -rw-r--r-- 1 root wheel 350 Dec 7 12:58 /usr/ports/databases/pgjwt/Makefile Ports top last git commit: 5a5039a587 Ports top unclean checkout: yes Port dir last git commit: Port dir unclean checkout: no Poudriere version: poudriere-git-3.4.4 Host OSVERSION: 1500068 Jail OSVERSION: 1403000 Job Id: ---Begin Environment--- SHELL=/bin/sh BLOCKSIZE=K MAIL=/var/mail/root MM_CHARSET=UTF-8 LANG=C.UTF-8 WARNING_WAIT=0 OSVERSION=1403000 STATUS=1 HOME=/root PATH=/sbin:/bin:/usr/sbin:/usr/bin:/usr/local/sbin:/usr/local/bin:/root/bin MAKE_OBJDIR_CHECK_WRITABLE=0 UNAME_m=i386 UNAME_p=i386 UNAME_r=14.3-RELEASE-p4 LOCALBASE=/usr/local UNAME_v=FreeBSD 14.3-RELEASE-p4 USER=root POUDRIERE_NAME=poudriere-git TRYBROKEN=yes LIBEXECPREFIX=/usr/local/libexec/poudriere POUDRIERE_VERSION=3.4.4 MASTERMNT=/data/.m/143i386-143i386/ref DEV_WARNING_WAIT=0 LC_COLLATE=C POUDRIERE_BUILD_TYPE=bulk PACKAGE_BUILDING=yes SAVED_TERM=su GID=0 OUTPUT_REDIRECTED_STDERR=4 OUTPUT_REDIRECTED=1 UID=0 PWD=/data/.m/143i386-143i386/ref/.p OUTPUT_REDIRECTED_STDOUT=3 NO_WARNING_PKG_INSTALL_EOL=yes P_PORTS_FEATURES=FLAVORS SUBPACKAGES SELECTED_OPTIONS MASTERNAME=143i386-143i386 SCRIPTPREFIX=/usr/local/share/poudriere SCRIPTNAME=testport.sh OLDPWD=/data/.m/143i386-143i386/ref/.p/pool POUDRIERE_PKGNAME=poudriere-git-3.4.4 SCRIPTPATH=/usr/local/share/poudriere/testport.sh POUDRIEREPATH=/usr/local/bin/poudriere ---End Environment--- ---Begin Poudriere Port Flags/Env--- PORT_FLAGS= PKGENV=PACKAGES=/tmp/pkgs PKGREPOSITORY=/tmp/pkgs PKGLATESTREPOSITORY=/tmp/pkgs/Latest FLAVOR= MAKE_ARGS= ---End Poudriere Port Flags/Env--- ---Begin OPTIONS List--- ---End OPTIONS List--- --MAINTAINER-- lukas.engelhardt@gmx.de --End MAINTAINER-- --CONFIGURE_ARGS-- --End CONFIGURE_ARGS-- --CONFIGURE_ENV-- MAKE=/usr/local/bin/gmake XDG_DATA_HOME=/wrkdirs/usr/ports/databases/pgjwt/work XDG_CONFIG_HOME=/wrkdirs/usr/ports/databases/pgjwt/work XDG_CACHE_HOME=/wrkdirs/usr/ports/databases/pgjwt/work/.cache HOME=/wrkdirs/usr/ports/databases/pgjwt/work TMPDIR="/tmp" PATH=/wrkdirs/usr/ports/databases/pgjwt/work/.bin:/sbin:/bin:/usr/sbin:/usr/bin:/usr/local/sbin:/usr/local/bin:/root/bin PKG_CONFIG_LIBDIR=/wrkdirs/usr/ports/databases/pgjwt/work/.pkgconfig:/usr/local/libdata/pkgconfig:/usr/local/share/pkgconfig:/usr/libdata/pkgconfig SHELL=/bin/sh CONFIG_SHELL=/bin/sh --End CONFIGURE_ENV-- --MAKE_ENV-- XDG_DATA_HOME=/wrkdirs/usr/ports/databases/pgjwt/work XDG_CONFIG_HOME=/wrkdirs/usr/ports/databases/pgjwt/work XDG_CACHE_HOME=/wrkdirs/usr/ports/databases/pgjwt/work/.cache HOME=/wrkdirs/usr/ports/databases/pgjwt/work TMPDIR="/tmp" PATH=/wrkdirs/usr/ports/databases/pgjwt/work/.bin:/sbin:/bin:/usr/sbin:/usr/bin:/usr/local/sbin:/usr/local/bin:/root/bin PKG_CONFIG_LIBDIR=/wrkdirs/usr/ports/databases/pgjwt/work/.pkgconfig:/usr/local/libdata/pkgconfig:/usr/local/share/pkgconfig:/usr/libdata/pkgconfig MK_DEBUG_FILES=no MK_KERNEL_SYMBOLS=no SHELL=/bin/sh NO_LINT=YES PREFIX=/usr/local LOCALBASE=/usr/local CC="cc" CFLAGS="-O2 -pipe -fstack-protector-strong -fno-strict-aliasing " CPP="cpp" CPPFLAGS="-I/usr/local/include" LDFLAGS=" -L/usr/local/lib " LIBS="" CXX="c++" CXXFLAGS="-O2 -pipe -fstack-protector-strong -fno-strict-aliasing " BSD_INSTALL_PROGRAM="install -s -m 555" BSD_INSTALL_LIB="install -s -m 0644" BSD_INSTALL_SCRIPT="install -m 555" BSD_INSTALL_DATA="install -m 0644" BSD_INSTALL_MAN="install -m 444" --End MAKE_ENV-- --PLIST_SUB-- OSREL=14.3 PREFIX=%D LOCALBASE=/usr/local RESETPREFIX=/usr/local LIB32DIR=lib DOCSDIR="share/doc/pgjwt" EXAMPLESDIR="share/examples/pgjwt" DATADIR="share/pgjwt" WWWDIR="www/pgjwt" ETCDIR="etc/pgjwt" --End PLIST_SUB-- --SUB_LIST-- PREFIX=/usr/local LOCALBASE=/usr/local DATADIR=/usr/local/share/pgjwt DOCSDIR=/usr/local/share/doc/pgjwt EXAMPLESDIR=/usr/local/share/examples/pgjwt WWWDIR=/usr/local/www/pgjwt ETCDIR=/usr/local/etc/pgjwt --End SUB_LIST-- ---Begin make.conf--- USE_PACKAGE_DEPENDS=yes BATCH=yes WRKDIRPREFIX=/wrkdirs PORTSDIR=/usr/ports PACKAGES=/packages DISTDIR=/distfiles FORCE_PACKAGE=yes PACKAGE_BUILDING=yes PACKAGE_BUILDING_FLAVORS=yes MACHINE=i386 MACHINE_ARCH=i386 ARCH=${MACHINE_ARCH} #### Misc Poudriere #### .include "/etc/make.conf.ports_env" ---End make.conf--- --Resource limits-- cpu time (seconds, -t) unlimited file size (512-blocks, -f) unlimited data seg size (kbytes, -d) 524288 stack size (kbytes, -s) 65536 core file size (512-blocks, -c) unlimited max memory size (kbytes, -m) unlimited locked memory (kbytes, -l) unlimited max user processes (-u) 34304 open files (-n) 8192 virtual mem size (kbytes, -v) unlimited swap limit (kbytes, -w) unlimited socket buffer size (bytes, -b) unlimited pseudo-terminals (-p) unlimited kqueues (-k) unlimited umtx shared locks (-o) unlimited pipebuf (-y) unlimited --End resource limits-- =================================================== ===== env: DEVELOPER_MODE=yes DEVELOPER=1 STRICT_DEPENDS=yes USER=nobody UID=65534 GID=65534 ===> License PostgreSQL accepted by the user =========================================================================== =================================================== ===== env: DEVELOPER_MODE=yes USE_PACKAGE_DEPENDS_ONLY=1 USER=root UID=0 GID=0 ===> postgresql17-pgjwt-2.0 depends on file: /usr/local/sbin/pkg - not found ===> Installing existing package /packages/All/pkg-2.4.2_1.pkg [143i386-143i386] Installing pkg-2.4.2_1... [143i386-143i386] Extracting pkg-2.4.2_1: .......... done ===> postgresql17-pgjwt-2.0 depends on file: /usr/local/sbin/pkg - found ===> Returning to build of postgresql17-pgjwt-2.0 =========================================================================== =================================================== ===== env: DEVELOPER_MODE=yes USE_PACKAGE_DEPENDS_ONLY=1 USER=root UID=0 GID=0 =========================================================================== =================================================== ===== env: DEVELOPER_MODE=yes STRICT_DEPENDS=yes USER=root UID=0 GID=0 ===> License PostgreSQL accepted by the user ===> postgresql17-pgjwt-2.0 depends on file: /usr/local/sbin/pkg - found ===> Fetching all distfiles required by postgresql17-pgjwt-2.0 for building =========================================================================== =================================================== ===== env: DEVELOPER_MODE=yes STRICT_DEPENDS=yes USER=root UID=0 GID=0 ===> License PostgreSQL accepted by the user ===> postgresql17-pgjwt-2.0 depends on file: /usr/local/sbin/pkg - found ===> Fetching all distfiles required by postgresql17-pgjwt-2.0 for building => SHA256 Checksum OK for michelp-pgjwt-2.0-f3d82fd_GH0.tar.gz. =========================================================================== =================================================== ===== env: DEVELOPER_MODE=yes USE_PACKAGE_DEPENDS_ONLY=1 USER=root UID=0 GID=0 =========================================================================== =================================================== ===== env: DEVELOPER_MODE=yes STRICT_DEPENDS=yes USER=nobody UID=65534 GID=65534 ===> License PostgreSQL accepted by the user ===> postgresql17-pgjwt-2.0 depends on file: /usr/local/sbin/pkg - found ===> Fetching all distfiles required by postgresql17-pgjwt-2.0 for building ===> Extracting for postgresql17-pgjwt-2.0 => SHA256 Checksum OK for michelp-pgjwt-2.0-f3d82fd_GH0.tar.gz. =========================================================================== =================================================== ===== env: DEVELOPER_MODE=yes USE_PACKAGE_DEPENDS_ONLY=1 USER=root UID=0 GID=0 =========================================================================== =================================================== ===== env: DEVELOPER_MODE=yes DEVELOPER=1 STRICT_DEPENDS=yes USER=nobody UID=65534 GID=65534 ===> Patching for postgresql17-pgjwt-2.0 =========================================================================== =================================================== ===== env: DEVELOPER_MODE=yes USE_PACKAGE_DEPENDS_ONLY=1 USER=root UID=0 GID=0 ===> postgresql17-pgjwt-2.0 depends on package: gmake>=4.4.1 - not found ===> Installing existing package /packages/All/gmake-4.4.1.pkg [143i386-143i386] Installing gmake-4.4.1... [143i386-143i386] `-- Installing gettext-runtime-0.23.1... [143i386-143i386] | `-- Installing indexinfo-0.3.1_1... [143i386-143i386] | `-- Extracting indexinfo-0.3.1_1: .... done [143i386-143i386] `-- Extracting gettext-runtime-0.23.1: .......... done [143i386-143i386] Extracting gmake-4.4.1: .......... done ===> postgresql17-pgjwt-2.0 depends on package: gmake>=4.4.1 - found ===> Returning to build of postgresql17-pgjwt-2.0 ===> postgresql17-pgjwt-2.0 depends on executable: postgres - not found ===> Installing existing package /packages/All/postgresql17-server-17.7_1.pkg [143i386-143i386] Installing postgresql17-server-17.7_1... [143i386-143i386] `-- Installing icu-76.1,1... [143i386-143i386] `-- Extracting icu-76.1,1: .......... done [143i386-143i386] `-- Installing liblz4-1.10.0_2,1... [143i386-143i386] `-- Extracting liblz4-1.10.0_2,1: .......... done [143i386-143i386] `-- Installing libxml2-2.14.6... [143i386-143i386] | `-- Installing readline-8.3.1... [143i386-143i386] | `-- Extracting readline-8.3.1: .......... done [143i386-143i386] `-- Extracting libxml2-2.14.6: .......... done [143i386-143i386] `-- Installing llvm19-19.1.7_1... [143i386-143i386] | `-- Installing libedit-3.1.20251016_1,1... [143i386-143i386] | `-- Extracting libedit-3.1.20251016_1,1: .......... done [143i386-143i386] | `-- Installing lua53-5.3.6_1... [143i386-143i386] | `-- Extracting lua53-5.3.6_1: .......... done [143i386-143i386] | `-- Installing perl5-5.42.0_1... [143i386-143i386] | `-- Extracting perl5-5.42.0_1: .......... done [143i386-143i386] | `-- Installing python311-3.11.14... [143i386-143i386] | | `-- Installing libffi-3.5.1... [143i386-143i386] | | `-- Extracting libffi-3.5.1: .......... done [143i386-143i386] | | `-- Installing mpdecimal-4.0.1... [143i386-143i386] | | `-- Extracting mpdecimal-4.0.1: .......... done [143i386-143i386] | `-- Extracting python311-3.11.14: .......... done [143i386-143i386] | `-- Installing zstd-1.5.7_1... [143i386-143i386] | `-- Extracting zstd-1.5.7_1: .......... done [143i386-143i386] `-- Extracting llvm19-19.1.7_1: .......... done [143i386-143i386] `-- Installing postgresql17-client-17.7_2... [143i386-143i386] `-- Extracting postgresql17-client-17.7_2: .......... done ===> Creating groups Creating group 'postgres' with gid '770' ===> Creating users Creating user 'postgres' with uid '770' ===> Creating homedir(s) =========== BACKUP YOUR DATA! ============= As always, backup your data before upgrading. If the upgrade leads to a higher major revision (e.g. 9.6 -> 10), a dump and restore of all databases is required. This is *NOT* done by the port! See https://www.postgresql.org/docs/current/upgrading.html =========================================== [143i386-143i386] Extracting postgresql17-server-17.7_1: .......... done ===== Message from python311-3.11.14: -- Note that some standard Python modules are provided as separate ports as they require additional dependencies. They are available as: py311-gdbm databases/py-gdbm@py311 py311-sqlite3 databases/py-sqlite3@py311 py311-tkinter x11-toolkits/py-tkinter@py311 ===== Message from postgresql17-client-17.7_2: -- The PostgreSQL port has a collection of "side orders": postgresql-docs For all of the html documentation p5-Pg A perl5 API for client access to PostgreSQL databases. postgresql-tcltk If you want tcl/tk client support. postgresql-jdbc For Java JDBC support. postgresql-odbc For client access from unix applications using ODBC as access method. Not needed to access unix PostgreSQL servers from Win32 using ODBC. See below. ruby-postgres, py-psycopg For client access to PostgreSQL databases using the ruby & python languages. postgresql-plperl, postgresql-pltcl & postgresql-plruby For using perl5, tcl & ruby as procedural languages. postgresql-contrib Lots of contributed utilities, postgresql functions and datatypes. There you find pg_standby, pgcrypto and many other cool things. etc... ===== Message from postgresql17-server-17.7_1: -- For procedural languages and postgresql functions, please note that you might have to update them when updating the server. If you have many tables and many clients running, consider raising kern.maxfiles using sysctl(8), or reconfigure your kernel appropriately. The port is set up to use autovacuum for new databases, but you might also want to vacuum and perhaps backup your database regularly. There is a periodic script, /usr/local/etc/periodic/daily/502.pgsql, that you may find useful. You can use it to backup and perform vacuum on all databases nightly. Per default, it performs `vacuum analyze'. See the script for instructions. For autovacuum settings, please review ~postgres/data/postgresql.conf. If you plan to access your PostgreSQL server using ODBC, please consider running the SQL script /usr/local/share/postgresql/odbc.sql to get the functions required for ODBC compliance. Please note that if you use the rc script, /usr/local/etc/rc.d/postgresql, to initialize the database, unicode (UTF-8) will be used to store character data by default. Set postgresql_initdb_flags or use login.conf settings described below to alter this behaviour. See the start rc script for more info. To set limits, environment stuff like locale and collation and other things, you can set up a class in /etc/login.conf before initializing the database. Add something similar to this to /etc/login.conf: --- postgres:\ :lang=en_US.UTF-8:\ :setenv=LC_COLLATE=C:\ :tc=default: --- and run `cap_mkdb /etc/login.conf'. Then add 'postgresql_login_class="postgres"' to /etc/rc.conf, or set it as the postgres user's login class in /etc/passwd. ====================================================================== To use PostgreSQL, enable it in rc.conf using sysrc postgresql_enable=yes To initialize the database, run service postgresql initdb You can then start PostgreSQL by running: service postgresql start For postmaster settings, see ~postgres/data/postgresql.conf NB. FreeBSD's PostgreSQL port logs to syslog by default See ~postgres/data/postgresql.conf for more info NB. If you're not using a checksumming filesystem like ZFS, you might wish to enable data checksumming. It can be enabled during the initdb phase, by adding the "--data-checksums" flag to the postgresql_initdb_flags rcvar. Otherwise you can enable it later by using pg_checksums. Check the initdb(1) manpage for more info and make sure you understand the performance implications. ===> postgresql17-pgjwt-2.0 depends on executable: postgres - found ===> Returning to build of postgresql17-pgjwt-2.0 =========================================================================== =================================================== ===== env: DEVELOPER_MODE=yes USE_PACKAGE_DEPENDS_ONLY=1 USER=root UID=0 GID=0 =========================================================================== =>> Recording filesystem state for prebuild... done =================================================== ===== env: DEVELOPER_MODE=yes STRICT_DEPENDS=yes USER=nobody UID=65534 GID=65534 ===> postgresql17-pgjwt-2.0 depends on package: gmake>=4.4.1 - found ===> postgresql17-pgjwt-2.0 depends on executable: postgres - found ===> Configuring for postgresql17-pgjwt-2.0 =========================================================================== =================================================== ===== env: DEVELOPER_MODE=yes STRICT_DEPENDS=yes USER=nobody UID=65534 GID=65534 ===> Building for postgresql17-pgjwt-2.0 gmake: Nothing to be done for 'all'. =========================================================================== =>> Checking for filesystem violations... done =================================================== ===== env: DEVELOPER_MODE=yes USE_PACKAGE_DEPENDS_ONLY=1 USER=root UID=0 GID=0 ===> postgresql17-pgjwt-2.0 depends on executable: postgres - found =========================================================================== =>> Recording filesystem state for prestage... done =================================================== ===== env: DEVELOPER_MODE=yes STRICT_DEPENDS=yes USER=nobody UID=65534 GID=65534 ===> Staging for postgresql17-pgjwt-2.0 ===> postgresql17-pgjwt-2.0 depends on executable: postgres - found ===> Generating temporary packing list /bin/mkdir -p '/wrkdirs/usr/ports/databases/pgjwt/work/stage/usr/local/share/postgresql/extension' /bin/mkdir -p '/wrkdirs/usr/ports/databases/pgjwt/work/stage/usr/local/share/postgresql/extension' /usr/bin/install -c -m 644 .//pgjwt.control '/wrkdirs/usr/ports/databases/pgjwt/work/stage/usr/local/share/postgresql/extension/' /usr/bin/install -c -m 644 .//pgjwt--0.1.1.sql .//pgjwt--0.1.0--0.1.1.sql .//pgjwt--0.1.1--0.2.0.sql '/wrkdirs/usr/ports/databases/pgjwt/work/stage/usr/local/share/postgresql/extension/' ====> Compressing man pages (compress-man) =========================================================================== ====> Running Q/A tests (stage-qa) ====> Checking for pkg-plist issues (check-plist) ===> Parsing plist ===> Checking for items in STAGEDIR missing from pkg-plist ===> Checking for items in pkg-plist which are not in STAGEDIR ===> No pkg-plist issues found (check-plist) =>> Checking for staging violations... done =================================================== ===== env: DEVELOPER_MODE=yes PACKAGES=/tmp/pkgs PKGREPOSITORY=/tmp/pkgs PKGLATESTREPOSITORY=/tmp/pkgs/Latest 'PKG_NOTES=build_timestamp ports_top_git_hash ports_top_checkout_unclean port_git_hash port_checkout_unclean built_by' 'PKG_NOTE_build_timestamp=2025-12-07T21:11:07+0000' 'PKG_NOTE_ports_top_git_hash=5a5039a587' 'PKG_NOTE_ports_top_checkout_unclean=yes' 'PKG_NOTE_port_git_hash=' 'PKG_NOTE_port_checkout_unclean=no' 'PKG_NOTE_built_by=poudriere-git-3.4.4' STRICT_DEPENDS=yes USER=nobody UID=65534 GID=65534 ===> Building packages for postgresql17-pgjwt-2.0 ===> Building postgresql17-pgjwt-2.0 pkg-static: DEVELOPER_MODE: Notice: arch "FreeBSD:14:i386" -- no architecture specific files found: **** could this package use a wildcard architecture? =========================================================================== =>> Recording filesystem state for preinst... done =================================================== ===== env: DEVELOPER_MODE=yes STRICT_DEPENDS=yes USER=root UID=0 GID=0 ===> Installing for postgresql17-pgjwt-2.0 ===> Checking if postgresql17-pgjwt is already installed ===> Registering installation for postgresql17-pgjwt-2.0 pkg-static: DEVELOPER_MODE: Notice: arch "FreeBSD:14:i386" -- no architecture specific files found: **** could this package use a wildcard architecture? [143i386-143i386] Installing postgresql17-pgjwt-2.0... =========================================================================== =>> Checking shared library dependencies =================================================== ===== env: DEVELOPER_MODE=yes STRICT_DEPENDS=yes USER=root UID=0 GID=0 ===> Deinstalling for postgresql17-pgjwt ===> Deinstalling postgresql17-pgjwt-2.0 Updating database digests format: .......... done Checking integrity... done (0 conflicting) Deinstallation has been requested for the following 1 packages (of 0 packages in the universe): Installed packages to be REMOVED: postgresql17-pgjwt: 2.0 Number of packages to be removed: 1 [143i386-143i386] [1/1] Deinstalling postgresql17-pgjwt-2.0... [143i386-143i386] [1/1] Deleting files for postgresql17-pgjwt-2.0: ....... done =========================================================================== =>> Checking for extra files and directories [08:12:24] Installing from package [143i386-143i386] Installing postgresql17-pgjwt-2.0... [143i386-143i386] Extracting postgresql17-pgjwt-2.0: ....... done [08:12:24] Cleaning up ===> Cleaning for postgresql17-pgjwt-2.0 [08:12:24] Deinstalling package Updating database digests format: . done Checking integrity... done (0 conflicting) Deinstallation has been requested for the following 1 packages (of 0 packages in the universe): Installed packages to be REMOVED: postgresql17-pgjwt: 2.0 Number of packages to be removed: 1 [143i386-143i386] [1/1] Deinstalling postgresql17-pgjwt-2.0... [143i386-143i386] [1/1] Deleting files for postgresql17-pgjwt-2.0: ....... done build of databases/pgjwt | postgresql17-pgjwt-2.0 ended at Sun Dec 7 21:11:17 UTC 2025 build time: 00:00:09 [08:12:24] Logs: /data/logs/bulk/143i386-143i386/2025-12-07_12h58m52s [08:12:24] Cleaning up [08:12:24] Unmounting file systems