- postgresql11-server PostgreSQL is the most advanced open-source database available anywhere
11.1 databases =2
- Maintainer: pgsql@FreeBSD.org
Port Added: 2018-10-19 21:32:27
Last Update: 2019-01-09 16:03:49
SVN Revision: 489813
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 = 1541712758
SHA256 (postgresql/postgresql-11.1.tar.bz2) = 90815e812874831e9a4bf6e1136bf73bc2c5a0464ef142e2dfea40cda206db08
SIZE (postgresql/postgresql-11.1.tar.bz2) = 21263173
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.1:
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
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: 5
|Commit History - (may be incomplete: see SVNWeb link above for full details)
|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: 5
9 vulnerabilities affecting 54 ports have been reported in the past 14 days
* - modified, not new