Port details |
- postgresql14-server PostgreSQL is the most advanced open-source database available anywhere
- 14.13 databases =8 14.12Version of this port present on the latest quarterly branch.
- Maintainer: pgsql@FreeBSD.org
- Port Added: 2021-05-20 14:42:53
- Last Update: 2024-08-10 16:37:23
- Commit Hash: 357bf97
- People watching this port, also watch:: rust, perl5, autoconf, indexinfo, p5-Text-Unidecode
- License: PostgreSQL
- WWW:
- https://www.postgresql.org/
- Description:
- PostgreSQL is a sophisticated Object-Relational DBMS, supporting
almost all SQL constructs, including subselects, transactions, and
user-defined types and functions. It is the most advanced open-source
database available anywhere. Commercial Support is also available.
The original Postgres code was the effort of many graduate students,
undergraduate students, and staff programmers working under the direction of
Professor Michael Stonebraker at the University of California, Berkeley. In
1995, Andrew Yu and Jolly Chen took on the task of converting the DBMS query
language to SQL and created a new database system which came to known as
Postgres95. Many others contributed to the porting, testing, debugging and
enhancement of the Postgres95 code. As the code improved, and 1995 faded into
memory, PostgreSQL was born.
PostgreSQL development is presently being performed by a team of Internet
developers who are now responsible for all current and future development. The
development team coordinator is Marc G. Fournier (scrappy@PostgreSQL.ORG).
Support is available from the PostgreSQL developer/user community through the
support mailing list (questions@PostgreSQL.ORG).
PostgreSQL is free and the complete source is available.
- ¦ ¦ ¦ ¦
- Manual pages:
- FreshPorts has no man page information for this port.
- pkg-plist: as obtained via:
make generate-plist - Dependency lines:
-
- postgresql14-server>0:databases/postgresql14-server
- Conflicts:
- CONFLICTS:
- To install the port:
- cd /usr/ports/databases/postgresql14-server/ && make install clean
- To add the package, run one of these commands:
- pkg install databases/postgresql14-server
- pkg install postgresql14-server
NOTE: If this package has multiple flavors (see below), then use one of them instead of the name specified above.- PKGNAME: postgresql14-server
- Flavors: there is no flavor information for this port.
- distinfo:
- TIMESTAMP = 1722892658
SHA256 (postgresql/postgresql-14.13.tar.bz2) = 59aa3c4b495ab26a9ec69f3ad0a0228c51f0fe6facf3634dfad4d1197d613a56
SIZE (postgresql/postgresql-14.13.tar.bz2) = 22414381
Packages (timestamps in pop-ups are UTC):
- Slave ports:
-
- databases/postgresql14-client
- databases/postgresql14-contrib
- databases/postgresql14-docs
- databases/postgresql14-plperl
- databases/postgresql14-plpython
- databases/postgresql14-pltcl
- Dependencies
- NOTE: FreshPorts displays only information on required and default dependencies. Optional dependencies are not covered.
- Build dependencies:
-
- gmake>=4.4.1 : devel/gmake
- pkgconf>=1.3.0_1 : devel/pkgconf
- gettext-runtime>=0.22_1 : devel/gettext-runtime
- msgfmt : devel/gettext-tools
- Library dependencies:
-
- libicudata.so : devel/icu
- liblz4.so : archivers/liblz4
- libpq.so.5 : databases/postgresql14-client
- libLLVM-15.so : devel/llvm15
- libintl.so : devel/gettext-runtime
- This port is required by:
- for Build
-
- databases/postgresql14-plpython
- databases/postgresql14-pltcl
- for Run
-
- databases/postgresql14-plperl
- databases/postgresql14-plpython
- databases/postgresql14-pltcl
Configuration Options:
- ===> The following configuration options are available for postgresql14-server-14.13:
DEBUG=off: Build with debugging support
DOCS=on: Build and/or install documentation
DTRACE=off: Build with DTrace probes
GSSAPI=off: Build with GSSAPI support
LDAP=off: Build with LDAP authentication support
LLVM=on: Build with support for JIT-compiling expressions
LZ4=on: Build with LZ4 compression support
NLS=on: Use internationalized messages
OPTIMIZED_CFLAGS=off: Builds with compiler optimizations (-O3)
PAM=off: Build with PAM Support
SSL=on: Build with OpenSSL support
TZDATA=off: Use internal timezone database
XML=off: Build with XML data type
===> Use 'make config' to modify these settings
- Options name:
- databases_postgresql14-server
- USES:
- tar:bzip2 cpe gmake pgsql:14 pkgconfig llvm:min=11,lib gettext ssl
- pkg-message:
- For install:
- 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.
======================================================================
SECURITY ADVICE
If upgrading from a version 14.x < 14.12:
A security vulnerability was found in the system views pg_stats_ext
and pg_stats_ext_exprs, potentially allowing authenticated database
users to see data they shouldn't. If this is of concern in your
installation, run the SQL script /usr/local/share/postgresql/fix-CVE-2024-4317.sql
for each of your databases. For details, see
https://www.postgresql.org/support/security/CVE-2024-4317/
- Master Sites:
|
Commit History - (may be incomplete: for full details, see links to repositories near top of page) |
Commit | Credits | Log message |
14.13 10 Aug 2024 16:37:23 |
Dimitry Andric (dim) |
databases/postgresql1[456]-server: fix typo in pkg-message-server.in
s/upgradring/upgrading/
MFH: 2024Q3 |
14.13 08 Aug 2024 13:02:46 |
Palle Girgensohn (girgen) |
databases/postgresql??-*: Update to latest minor versions
The PostgreSQL Global Development Group has released an update to all
supported versions of PostgreSQL, including 16.4, 15.8, 14.13, 13.16,
and 12.20. This release fixes 1 security vulnerability and over 55 bugs
reported over the last several months.
PR: 279671 - make the rc script service jails aware
PR: 279536 - remove LLVM max version restriction
PR: 278887 - SETENV -> SETENVI for -contrib ports
Release notes: https://www.postgresql.org/docs/release/ |
14.12 09 May 2024 22:34:46 |
Palle Girgensohn (girgen) |
databases/postgresql??-*: Update to latest versions
PostgreSQL 16.3, 15.7, 14.12, 13.15, and 12.19 Released!
The PostgreSQL Global Development Group has released an update to all
supported versions of PostgreSQL, including 16.3, 15.7, 14.12, 13.15,
and 12.19. This release fixes one security vulnerability and over 55
bugs reported over the last several months.
Please note that the fix in this release for CVE-2024-4317 only fixes
fresh PostgreSQL installations, namely those that are created with the
initdb utility after this fix is applied. If you have a current
PostgreSQL installation and are concerned about this issue, please
follow the additional updating instructions provided in the
CVE-2024-4317 description or the release notes for the remediation. [1] (Only the first 15 lines of the commit message are shown above ) |
14.11 08 Feb 2024 21:28:36 |
Palle Girgensohn (girgen) |
databases/postgresql??-*: Update to latest version
The PostgreSQL Global Development Group has released an update to all
supported versions of PostgreSQL, including 16.2, 15.6, 14.11, 13.14,
and 12.18. This release fixes one security vulnerability and over 65
bugs reported over the last several months.
If you use GIN indexes, you may need to reindex after updating to this
release. Please see the release notes for more information.
URL: https://www.postgresql.org/about/news/postgresql-162-156-1411-1314-and-1218-released-2807/
Release notes: https://www.postgresql.org/docs/release/
Security: 19e6dd1b-c6a5-11ee-9cd0-6cc21735f730 |
14.10_4 23 Jan 2024 19:56:16 |
Muhammad Moinur Rahman (bofh) |
databases/postgresql1*: Impelled to share/man
Approved by: portmgr (blanket) |
14.10_4 14 Jan 2024 10:00:18 |
Palle Girgensohn (girgen) |
postgresql??-server: fix rc script bug when using profiles
Submitted by: John W. O'Brien |
14.10_3 11 Jan 2024 21:50:31 |
Palle Girgensohn (girgen) |
databases/postgresql??-server: honour login class set in /etc/passwd
If postgresql_login_class is not set, honour the setting in /etc/passwd.
The previous commit ignored the passwd setting and set the login class
to "default" if it was left unset.
PR: 275851 |
14.10_2 28 Dec 2023 10:20:24 |
Palle Girgensohn (girgen) |
databases/postgresql??-server: Properly set login class at start
PR: 275851 (submitted by takeda at takeda.tk) |
14.10_1 17 Nov 2023 11:46:00 |
Jan Beich (jbeich) |
devel/icu: update to 74.1
Changes: https://github.com/unicode-org/icu/releases/tag/release-74-1
Reported by: GitHub (watch releases)
PR: 274317
Exp-run by: antoine (incomplete)
Approved by: fluffy |
14.10 09 Nov 2023 15:09:19 |
Palle Girgensohn (girgen) |
databases/postgresql??-*: update to latest version
PostgreSQL 16.1, 15.5, 14.10, 13.13, 12.17, and 11.22 Released!
The PostgreSQL Global Development Group has released an update to all
supported versions of PostgreSQL, including 16.1, 15.5, 14.10, 13.13,
12.17, and 11.22 This release fixes three security vulnerabilities and
over 55 bugs reported over the last several months.
Release
notes: https://www.postgresql.org/about/news/postgresql-161-155-1410-1313-1217-and-1122-released-2749/
Security: CVE-2023-5868, CVE-2023-5869, CVE-2023-5870
Security: 31f45d06-7f0e-11ee-94b4-6cc21735f730
Security: 0f445859-7f0e-11ee-94b4-6cc21735f730
Security: bbb18fcb-7f0d-11ee-94b4-6cc21735f730 |
14.9 10 Aug 2023 14:13:24 |
Palle Girgensohn (girgen) |
databases/postgresql??-*: Update to latest versions.
PostgreSQL 15.4, 14.9, 13.12, 12.16, 11.21, and PostgreSQL 16 Beta 3
Released.
The PostgreSQL Global Development Group has released an update to all
supported versions of PostgreSQL, including 15.4, 14.9, 13.12, 12.16,
and 11.21, as well as the third beta release of PostgreSQL 16. This
release fixes two security vulnerabilities and over 40 bugs reported
over the last several months.
If you use BRIN indexes to look up NULL values, you will need to reindex
them after upgrading to this release. On PostgreSQL 12 and above, you
can use REINDEX CONCURRENTLY to avoid blocking writes to the affected
index and table, for example:
REINDEX INDEX CONCURRENTLY your_index_name;
Also, remove the patch for postgresql.conf.sample suggesting to turn off
update_process_title [1], since it is no longer a problem.
Release
notes: https://www.postgresql.org/about/news/postgresql-154-149-1312-1216-1121-and-postgresql-16-beta-3-released-2689/
[1]: https://commitfest.postgresql.org/19/1715/ |
14.8 05 Jul 2023 14:11:39 |
Palle Girgensohn (girgen) |
databases/postgresql16-*: Introduce postgresql16 beta 1
URL: https://www.postgresql.org/about/news/postgresql-16-beta-1-released-2643/
Release notes: https://www.postgresql.org/docs/16/release-16.html |
14.8 11 May 2023 15:42:57 |
Palle Girgensohn (girgen) |
databases/postgresql??-server: update to latest version
The PostgreSQL Global Development Group has released an update to all
supported versions of PostgreSQL, including 15.3, 14.8, 13.11, 12.15,
and 11.20. This release fixes two security vulnerabilities over 80 bugs
reported over the last several months.
CVE-2023-2454: CREATE SCHEMA ... schema_element defeats protective search_path
changes.
This enabled an attacker having database-level CREATE privilege to
execute arbitrary code as the bootstrap superuser. Database owners have
that right by default, and explicit grants may extend it to other users.
CVE-2023-2455: Row security policies disregard user ID changes after inlining.
(Only the first 15 lines of the commit message are shown above ) |
14.7_1 13 Apr 2023 00:56:37 |
Jan Beich (jbeich) |
devel/icu: update to 73.1
- Temporarily switch to GitHub auto archive (release artifacts are N/A atm)
Changes: https://github.com/unicode-org/icu/releases/tag/release-73-1
Reported by: GitHub (watch releases)
PR: 270422
Exp-run by: antoine |
14.7 09 Feb 2023 14:52:35 |
Palle Girgensohn (girgen) |
databases/postgresql??-*: upgrade to latest versions
The PostgreSQL Global Development Group has released an update to all
supported versions of PostgreSQL, including 15.2, 14.7, 13.10, 12.14,
and 11.19. This release closes one security vulnerability and fixes over
60 bugs reported over the last several months.
Release notes: https://www.postgresql.org/docs/release/
Security: CVE-2022-41862: Client memory disclosure when
connecting, with Kerberos, to modified server. |
14.6_1 15 Nov 2022 15:40:59 |
Dmitry Marakasov (amdmi3) |
databases/postgresql*-server: require mountlate in rc.d scripts
PostgreSQL server may use late-mounted filesystems, so require these
in rc.d scripts. Real life example is when /tmp is late-mounted tmpfs
atop of ZFS, and if posgresql-server starts before mountlate, its
socket which resides on /tmp is hidden under tmpfs which is mounted
afterwards.
PR: 267500
Approved by: maintainer timeout (pgsql, 2 weeks) |
14.6 10 Nov 2022 16:23:11 |
Palle Girgensohn (girgen) |
databases/postgresq??-*: update to latest version
PostgreSQL 15.1, 14.6, 13.9, 12.13, 11.18, and 10.23 Released!
The PostgreSQL Global Development Group has released an update to all
supported versions of PostgreSQL, including 15.1, 14.6, 13.9, 12.13,
11.18, and 10.23. This release fixes 25 bugs reported over the last
several months.
This is the final release of PostgreSQL 10. PostgreSQL 10 will no longer
receive security and bug fixes. If you are running PostgreSQL 10 in a
production environment, we suggest that you make plans to upgrade.
Release notes: https://www.postgresql.org/docs/release/ |
14.5_1 19 Oct 2022 08:10:29 |
Jan Beich (jbeich) |
devel/icu: update to 72.1
Changes: https://github.com/unicode-org/icu/releases/tag/release-72-1
Reported by: GitHub (watch releases)
PR: 266582
Exp-run by: antoine |
14.5 03 Oct 2022 08:29:02 |
Palle Girgensohn (girgen) |
databases/postgresql??-server: fix bad PLIST substitutions
Noted by: sunpoet@ |
14.5 14 Sep 2022 04:10:22 |
Alexey Dokuchaev (danfe) |
databases/postgresql*-server: fix minor style bugs in maintenance script
Convert to ASCII and trim EOL whitespace. The scripts are now identical
across all PostgreSQL server versions we have in the ports.
Verified by: cksum(1) |
14.5 10 Sep 2022 17:41:16 |
Stefan Eßer (se) Author: Tobias Kortkamp |
Fix WWW in parent/child ports
Many of the WWW are overwritten later which means the wrong value
is used. This did not happen before where the children were either
a) just using the pkg-descr from the parents
b) or had their own separate pkg-descr with custom WWW
Use WWW?= in parents when the child's WWW is different.
Children that use the same WWW as the parent can just inherit it,
i.e., the child WWW can be removed.
Approved by: portmgr (implicit) |
07 Sep 2022 21:58:51 |
Stefan Eßer (se) |
Remove WWW entries moved into port Makefiles
Commit b7f05445c00f has added WWW entries to port Makefiles based on
WWW: lines in pkg-descr files.
This commit removes the WWW: lines of moved-over URLs from these
pkg-descr files.
Approved by: portmgr (tcberner) |
14.5 07 Sep 2022 21:10:59 |
Stefan Eßer (se) |
Add WWW entries to port Makefiles
It has been common practice to have one or more URLs at the end of the
ports' pkg-descr files, one per line and prefixed with "WWW:". These
URLs should point at a project website or other relevant resources.
Access to these URLs required processing of the pkg-descr files, and
they have often become stale over time. If more than one such URL was
present in a pkg-descr file, only the first one was tarnsfered into
the port INDEX, but for many ports only the last line did contain the
port specific URL to further information.
There have been several proposals to make a project URL available as
a macro in the ports' Makefiles, over time.
(Only the first 15 lines of the commit message are shown above ) |
14.5 12 Aug 2022 09:05:24 |
Palle Girgensohn (girgen) |
databases/postgresql??-*: Update to latest version
The PostgreSQL Global Development Group has released an update to all
supported versions of PostgreSQL, including 14.5, 13.8, 12.12, 11.17,
and 10.22, as well as the third beta release of PostgreSQL 15. This
release closes one security vulnerability and fixes over 40 bugs
reported over the last three months.
PostgreSQL 10 will stop receiving fixes on November 10, 2022. If you are
running PostgreSQL 10 in a production environment, we strongly advise
that you make plans to upgrade to a newer, supported version of
PostgreSQL so you can continue to receive bug and security fixes.
Security: CVE-2022-2625
Release
notes: https://www.postgresql.org/about/news/postgresql-145-138-1212-1117-1022-and-15-beta-3-released-2496/ |
14.4 20 Jul 2022 14:21:07 |
Tobias C. Berner (tcberner) |
databases: remove 'Created by' lines
A big Thank You to the original contributors of these ports:
* "Choe, Cheng-Dae" whitekid
* "Mahdi Mokhtari <mokhi64@gmail.com>"
* "Meikel Brandmeyer" <ocaml-sqlite3-port@kotka.de>
* <hvo.pm@xs4all.nl>
* <jsmith@resonatingmedia.com>
* <ports@c0decafe.net>
* Aaron Dalton <aaron@FreeBSD.org>
* Adam Weinberger <adamw@FreeBSD.org>
* Ade Lovett <ade@FreeBSD.org>
* Akinori MUSHA aka knu <knu@idaemons.org>
* Alan Snelson <Alan@Wave2.org> (Only the first 15 lines of the commit message are shown above ) |
14.4 16 Jun 2022 13:08:02 |
Palle Girgensohn (girgen) |
databases/postgresql14-server: update to 14.4
This release fixes an issue with all versions of PostgreSQL 14 that can
lead to silent corruption of indexes.
Since the release of PostgreSQL 14.0, there existed an issue with CREATE
INDEX CONCURRENTLY and REINDEX CONCURRENTLY that could cause silent data
corruption in indexes. This issue is fixed in the upcoming PostgreSQL
14.4 release.
If you ran either of these commands on any version of PostgreSQL 14
prior to 14.4, you may have experienced silent data corruption. You can
use the pg_amcheck command with the --heapallindexed flag to detect this
issue with B-tree indexes.
If you need an immediate remediation for this issue before the
PostgreSQL 14.4 release, you can run CREATE INDEX or REINDEX without
CONCURRENTLY. You can also run the reindexdb command and use the --jobs
flag for added parallelism, but do not use the --concurrently flag.
Once PostgreSQL 14.4 is released, you can safely use CREATE INDEX
CONCURRENTLY and REINDEX CONCURRENTLY to manage your indexes, as well as
the --concurrently flag on reindexdb.
URL: https://www.postgresql.org/message-id/165473835807.573551.1512237163040609764%40wrigleys.postgresql.org |
14.3_1 14 Jun 2022 21:02:40 |
Palle Girgensohn (girgen) |
databases/postgresql1[45]-client: add missing pg_amcheck tool
Also add some missing plist files for postgresql15-client and contrib |
14.3_1 23 May 2022 10:46:14 |
Palle Girgensohn (girgen) |
postgresql??-server: fix regression in the rc script
The rc script was converted to use a SUB_LIST variable, but I failed to
introduce the variable correctly in the Makefile. [1]
The plist for postgresql15-server was incorrect. Fixed this as well.
PR: 264097 [1] |
14.3 19 May 2022 13:36:48 |
Palle Girgensohn (girgen) |
databases/postgresql??-*: add postgresql-15 to the ports tree
Introduce PostgreSQL-15 to the ports tree.
Make version 15 the master port, and add plist parameter for the
postgresql version.
Release notes: https://www.postgresql.org/docs/devel/release.html |
14.3 12 May 2022 13:41:07 |
Palle Girgensohn (girgen) |
databases/postgresql??-server: update to latest version
The PostgreSQL Global Development Group has released an update to all
supported versions of PostgreSQL, including 14.3, 13.7, 12.11, 11.16,
and 10.21. This release fixes over 50 bugs reported over the last three
months. This release closes one security vulnerability and fixes over 50
bugs reported over the last three months.
We encourage you to install this update at your earliest possible
convenience.
If you have any GiST indexes on columns using the ltree data type, you
will need to reindex them after upgrading.
For the full list of changes, please review the release notes. (Only the first 15 lines of the commit message are shown above ) |
14.2_1 07 Apr 2022 00:39:10 |
Jan Beich (jbeich) |
devel/icu: update to 71.1
Changes: https://github.com/unicode-org/icu/releases/tag/release-71-1
Reported by: GitHub (watch releases)
PR: 262654
Exp-run by: antoine
Approved by: fluffy |
14.2 16 Mar 2022 18:28:57 |
Dimitry Andric (dim) |
databases/postgresql14-server: Avoid using llvm14
When the base system compiler is clang 14, the postgresql ports attempt
to build against the devel/llvm14 port. This will fail with several
compile errors as there are a few incompatible changes in the LLVM 14 C
and C++ APIs. Until upstream postgresql adapts to these changes, limit
the PG_LLVM_VERSION to a maximum of 13.
PR: 261976
Approved by: maintainer timeout (2 weeks)
MFH: 2022Q1 |
14.2 10 Feb 2022 14:17:45 |
Palle Girgensohn (girgen) |
databases/postgresql??-server: Upgrade to latest version
The PostgreSQL Global Development Group has released an update to all
supported versions of PostgreSQL, including 14.2, 13.6, 12.10, 11.15,
and 10.20. This release fixes over 55 bugs reported over the last three
months.
Announcement: https://www.postgresql.org/about/news/postgresql-142-136-1210-1115-and-1020-released-2402/
Release notes: https://www.postgresql.org/docs/release/ |
14.1 22 Dec 2021 10:43:26 |
Piotr Kubaj (pkubaj) |
databases/postgresql14-server: fix build on riscv64
Same issue as other postgresql ports. |
14.1 11 Nov 2021 14:37:02 |
Palle Girgensohn (girgen) |
databases/postgresql??-*: updated to latest version
This release contains a variety of fixes from the previous version.
A dump/restore is not required for those running the same major version.
However, note that installations using physical replication should
update standby servers before the primary server, as explained in the
release notes.
Also, several bugs have been found that may have resulted in corrupted
indexes, as explained in the next several changelog entries. If any of
those cases apply to you, it's recommended to reindex possibly-affected
indexes after updating.
This release also mitigates two possible man-in-the-middle attacks.
Security: 2ccd71bd-426b-11ec-87db-6cc21735f730
Release notes: https://www.postgresql.org/docs/release/14.1/ |
14.0_1 28 Oct 2021 16:37:30 |
Jan Beich (jbeich) |
devel/icu: update to 70.1
Changes: https://github.com/unicode-org/icu/releases/tag/release-70-1
Reported by: GitHub (watch releases)
PR: 258794
Exp-run by: antoine |
14.0 30 Sep 2021 12:55:46 |
Palle Girgensohn (girgen) |
databases/postgresql14-server: Introducing PostgreSQL-14
PostgreSQL 14 brings a variety of features that help developers and
administrators deploy their data-backed applications. PostgreSQL
continues to add innovations on complex data types, including more
convenient access for JSON and support for noncontiguous ranges of data.
This latest release adds to PostgreSQL's trend on improving high
performance and distributed data workloads, with advances in connection
concurrency, high-write workloads, query parallelism and logical
replication.
Release notes: https://www.postgresql.org/docs/14/release-14.html |
14.r1_2 29 Sep 2021 09:39:17 |
Palle Girgensohn (girgen) |
databases/postgresql14-server: fix openssl dependency
libpq.pc should not require openssl from ports when built with base -lssl
PR: 258760 |
14.r1_1 28 Sep 2021 06:55:29 |
Palle Girgensohn (girgen) |
databases/postgresql14-server: add support for lz4 compression |
14.r1 24 Sep 2021 08:51:14 |
Palle Girgensohn (girgen) |
databases/postgresql14: update to 14rc1
Release notes: https://www.postgresql.org/docs/14/release-14.html |
14.b3 12 Aug 2021 16:23:00 |
Palle Girgensohn (girgen) |
databases/postgresql*: update to latest versions
The PostgreSQL Global Development Group has released an update to all supported
versions of our database system, including 13.4, 12.8, 11.13, 10.18, and
9.6.23, as well as the third beta release of PostgreSQL 14. This release closes
one security vulnerability and fixes over 75 bugs reported over the last three
months.
Turn off parallel builds since we continue to struggle with build problems when
it is activated. [1]
Avoid chasing latest LLVM version. [2]
PR: 256466 [1], 256167 [2]
Release notes: https://www.postgresql.org/docs/release/
Security: b471130b-fb86-11eb-87db-6cc21735f730 |
14.b2_2 24 Jun 2021 19:09:41 |
Palle Girgensohn (girgen) |
databases/postgres14-*: Update to 14.0-beta2
Release notes: https://www.postgresql.org/developer/beta/ |
14.b1_2 01 Jun 2021 13:59:35 |
Palle Girgensohn (girgen) |
databases/postgresql??-server: rc-script should require DAEMON
Changeset ab83f2b4bb78 changed the startup order for Postgresql. The cleartmp
rc.d now comes after the Postgresql startup. Unfortunately, Postgresql likes
to create a socket in /tmp/.s.PGSQL.5432. After cleartmp does its work, that
socket disappears from the filesystem.
Submitted by: Jeroen Pulles
PR: 256335 |
14.b1_1 24 May 2021 16:03:46 |
Palle Girgensohn (girgen) |
databases/postgresql14-server: fix data directory
PR: 256125 |
14.b1 20 May 2021 14:38:55 |
Palle Girgensohn (girgen) |
databases/postgresql14-*: Add postgresql 14 beta1 the the ports tree.
Release notes: https://www.postgresql.org/docs/devel/release-14.html
Also reintroduce parallel builds. Some components, namely plperl,
plpython, pltcl and contrib, fail to build properly when using parallel
builds. Something with static linking using `ar` that fails.
MAKE_JOBS_UNSAFE is set for these ports. |