- postgresql11-server PostgreSQL is the most advanced open-source database available anywhere
11.2 databases =4
- Maintainer: pgsql@FreeBSD.org
Port Added: 2018-10-19 21:32:27
Last Update: 2019-02-15 11:02:22
SVN Revision: 492989
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.
WWW: https://www.postgresql.org/SVNWeb : Homepage : PortsMon
Pseudo-pkg-plist information, but much better, from
Dependency line: postgresql11-server>0:databases/postgresql11-serverConflicts:
There are no Conflicts Matches for this port. This is usually an error.
To install the port:
cd /usr/ports/databases/postgresql11-server/ && make install clean
To add the package:
pkg install postgresql11-server
There is no flavor information for this port.
TIMESTAMP = 1550095269
SHA256 (postgresql/postgresql-11.2.tar.bz2) = 2676b9ce09c21978032070b6794696e0aa5a476e3d21d60afc036dc0a9c09405
SIZE (postgresql/postgresql-11.2.tar.bz2) = 19714229
NOTE: FreshPorts displays only information on required and default dependencies. Optional dependencies are not covered.Build dependencies:
- gmake : devel/gmake
- pkgconf>=1.3.0_1 : devel/pkgconf
- msgfmt : devel/gettext-tools
- libicudata.so : devel/icu
- libpq.so.5 : databases/postgresql11-client
- libintl.so : devel/gettext-runtime
This port is required by:for Build
* - deleted ports are only shown under the This port is required by section. It was harder to do for the Required section. Perhaps later...
===> The following configuration options are available for postgresql11-server-11.2:
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
INTDATE=on: Builds with 64-bit date/time type
LDAP=off: Build with LDAP authentication support
LLVM=off: Build with support for JIT-compiling expressions
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=on: Use internal timezone database
XML=off: Build with XML data type
===> Use 'make config' to modify these settings
tar:bzip2 cpe gmake pgsql:11 pkgconfig gettext ssl
|Notes from UPDATING
These upgrade notes are taken from /usr/ports/UPDATING|
Affects: users of databases/postgresql*-server
Affected users are those who use the crypt(text, text) function with
DES encryption in the optional pg_crypto module. Passwords affected
are those that contain characters that cannot be represented with
7-bit ASCII. If a password contains a character that has the most
significant bit set (0x80), and DES encryption is used, that character
and all characters after it will be ignored.
Number of commits found: 7
|Commit History - (may be incomplete: see SVNWeb link above for full details)
|15 Feb 2019 11:02:22
The PostgreSQL Global Development Group has released an update to all
supported versions of our database system, including 11.2, 10.7, 9.6.12,
9.5.16, and 9.4.21. This release changes the behavior in how PostgreSQL
interfaces with `fsync()` and includes fixes for partitioning and over
70 other bugs that were reported over the past three months.
Users should plan to apply this update at the next scheduled downtime.
FreeBSD port adds OPTIONS knob to support LLVM JIT. 
Highlight: Change in behavior with fsync()
When available in an operating system and enabled in the configuration
file (which it is by default), PostgreSQL uses the kernel function(Only the first 15 lines of the commit message are shown above )
|11 Feb 2019 08:55:59
Formatting, whitespace changes only
|09 Jan 2019 16:03:49
- Optionize SSL support in postgresql11-contrib
Submitted by: amdmi3
Approved by: maintainer timeout (pgsql, 7 weeks)
|08 Nov 2018 23:21:19
Posted on 2018-11-08 by PostgreSQL Global Development Group The PostgreSQL
Global Development Group has released an update to all supported versions of
our database system, including 11.1, 10.6, 9.6.11, 9.5.15, 9.4.20, and 9.3.25.
This release fixes one security issue as well as bugs reported over the last
All users using the affected versions of PostgreSQL should update as soon as
possible. Please see the notes on "Updating" below for any post-update steps
that may be required if you are using pg_stat_statements in your installation.
This update is also the final release for PostgreSQL 9.3, which is now
end-of-life and will no longer receive any bug or security fixes. If your
environment still uses PostgreSQL 9.3, please make plans to update to a
community supported version as soon as possible. Please see our versioning
policy for more information.
|23 Oct 2018 11:35:04
devel/icu: update to 63.1
Exp-run by: antoine
|21 Oct 2018 21:55:24
Minor patch to fix the default data directory used on startup.
Submitted by: Jonathan Chen
|19 Oct 2018 21:32:08
The PostgreSQL Global Development Group today announced the release of
PostgreSQL 11, the latest version of the world's most advanced open
PostgreSQL 11 provides users with improvements to overall performance of
the database system, with specific enhancements associated with very
large databases and high computational workloads. Further, PostgreSQL 11
makes significant improvements to the table partitioning system, adds
support for stored procedures capable of transaction management,
improves query parallelism and adds parallelized data definition
capabilities, and introduces just-in-time (JIT) compilation for
accelerating the execution of expressions in queries.
"For PostgreSQL 11, our development community focused on adding features
that improve PostgreSQL's ability to manage very large databases," said(Only the first 15 lines of the commit message are shown above )
Number of commits found: 7
10 vulnerabilities affecting 80 ports have been reported in the past 14 days
* - modified, not new