ports/databases/postgresql93-client, branch main

Remove expired ports:

2019-01-09T16:45:54Z

2019-01-08 databases/postgresql93-client: PostgreSQL-9.3 has reached end-of-life 2019-01-08 databases/postgresql93-docs: PostgreSQL-9.3 has reached end-of-life 2019-01-08 databases/postgresql93-contrib: PostgreSQL-9.3 has reached end-of-life 2019-01-08 databases/postgresql93-pltcl: PostgreSQL-9.3 has reached end-of-life databases/postgresql93-pgtcl: part of expired PostgreSQL 9.3 2019-01-08 databases/postgresql93-plperl: PostgreSQL-9.3 has reached end-of-life 2019-01-08 databases/postgresql93-plpython: PostgreSQL-9.3 has reached end-of-life 2019-01-08 databases/postgresql93-server: PostgreSQL-9.3 has reached end-of-life

Bump PORTREVISION for ports depending on the canonical version of GCC

2018-12-12T01:35:33Z

defined via Mk/bsd.default-versions.mk which has moved from GCC 7.4 t GCC 8.2 under most circumstances. This includes ports - with USE_GCC=yes or USE_GCC=any, - with USES=fortran, - using Mk/bsd.octave.mk which in turn features USES=fortran, and - with USES=compiler specifying openmp, nestedfct, c11, c++0x, c++11-lang, c++11-lib, c++14-lang, c++17-lang, or gcc-c++11-lib plus, as a double check, everything INDEX-11 showed depending on lang/gcc7. PR: 231590

The PostgreSQL Global Development Group has released an update to all

2017-09-05T09:27:11Z

supported versions of our database system, including 9.6.5, 9.5.9, 9.4.14, 9.3.19, and 9.2.23. This release includes fixes that prevent a crash in pg_restore when using parallel mode. It also patches over a few other bugs reported since the last releases in August. Additionally, in 9.4.14 only, there is a fix to an issue with walsenders preventing primary-server shutdown unless immediate shutdown mode is used. Users should plan to update at the next convenient downtime. Bug Fixes and Improvements This update also fixes a number of bugs reported in the last few weeks. Some of these issues affect only version 9.6, but many affect all supported versions: * Show foreign tables in information_schema.table_privileges view. This fix applies to new databases, see the release notes for the procedure to apply the fix to an existing database. * Correctly identify columns that are of a range type or domain type over a composite type or domain type being searched for * Prevent crash when passing fixed-length pass-by-reference data types to parallel worker processes * Change ecpg’s parser to allow RETURNING clauses without attached C variables * Change ecpg’s parser to recognize backslash continuation of C preprocessor command lines * Improve selection of compiler flags for PL/Perl on Windows

- Include pg_regress to all postgresql*-client ports, to allow running regression tests for postgresql extensions

2017-07-17T11:15:50Z

PR: 217874 Approved by: maintainer timeout (pgsql, 4 months)

Some binaries where moved from contrib to base in 9.5, like pgbench and

2016-01-13T10:36:22Z

pg_upgrade. Other where added in 9.5, but the port failed to install them. Make sure they are properly installed by the correct port (-client or -server) [1] Remove unused and hence confusing OSSP_UUID parameters from Makefile [2] Add options to allow user to be set for the backup script in periodic. Add this option only to 9.5 for now. It will be updated to other servers at next regular patch release. [3] The path to perl in hard coded into pgxs/src/Makefile.global which is then installed. Hence, we must depend on perl when that file is installed. Noticed by: Paul Guyot [1] PR: 192387 [2] PR: 172110 [3] PR: 206046 [4]

Update PostgreSQL port to latest version.

2015-10-08T21:25:01Z

Two security issues have been fixed in this release which affect users of specific PostgreSQL features: CVE-2015-5289: json or jsonb input values constructed from arbitrary user input can crash the PostgreSQL server and cause a denial of service. CVE-2015-5288: The crypt( function included with the optional pgCrypto extension could be exploited to read a few additional bytes of memory. No working exploit for this issue has been developed. This update will also disable SSL renegotiation by default; previously, it was enabled by default. SSL renegotiation will be removed entirely in PostgreSQL versions 9.5 and later. URL: http://www.postgresql.org/about/news/1615/ Security: CVE-2015-5288 CVE-2015-5289

Update PostgreSQL ports to latest version.

2015-05-22T23:22:19Z

Data Corruption Fix For users of PostgreSQL versions 9.3 or 9.4, this release fixes a problem where the database will fail to protect against "multixact wraparound", resulting in data corruption or loss. Users with a high transaction rate (1 million or more per hour) in a database with many foreign keys are especially vulnerable. We strongly urge all users of 9.4 and 9.3 to update their installations in the next few days. Users of versions 9.2 and earlier are not affected by this issue. Security: fc38cd83-00b3-11e5-8ebd-0026551a22dc

Revert the change from readline to libedit, and instead make libedit optional.

2015-02-07T17:05:07Z

PR: ports/197362

Update PostgreSQL-9.x to latests versions.

2015-02-05T22:54:34Z

This update fixes multiple security issues reported in PostgreSQL over the past few months. All of these issues require prior authentication, and some require additional conditions, and as such are not considered generally urgent. However, users should examine the list of security holes patched below in case they are particularly vulnerable. Security: CVE-2015-0241,CVE-2015-0242,CVE-2015-0243, CVE-2015-0244,CVE-2014-8161

Revert r247147.

2014-11-12T09:53:41Z

We need -pthread in LDFLAGS for threaded extensions like plv8js to work. PR: 175783 Submitted by: Li-Wen Hsu