aboutsummaryrefslogtreecommitdiff
path: root/databases/postgresql92-server/Makefile
Commit message (Collapse)AuthorAgeFilesLines
* Remove expired ports:Rene Ladan2018-02-101-26/+0
| | | | | | | | | 2018-01-01 devel/p5-Parse-Pidl: yes 2018-02-08 devel/rubygem-piston: No longer maintained upstream 2017-04-05 databases/postgresql92-server: PostgreSQL 9.2 support has reached End-of-line. Please upgrade to a later version. Notes: svn path=/head/; revision=461438
* Update to latest versions of PostgreSQLPalle Girgensohn2018-02-081-263/+8
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | 2018-02-08 Security Update Release ================================== The PostgreSQL Global Development Group has released an update to all supported versions of our database system, including 10.2, 9.6.7, 9.5.11, 9.4.16, 9.3.21. This release fixes two security issues. This release also fixes issues with VACUUM, GIN indexes, and hash indexes that could lead to data corruption, as well as fixes for using parallel queries and logical replication. 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. Please note that PostgreSQL changed its versioning scheme with the release of version 10.0, so updating to version 10.2 from 10.0 or 10.1 is considered a minor update. Security Issues --------------- Two security vulnerabilities have been fixed by this release: * CVE-2018-1052: Fix the processing of partition keys containing multiple expressions * CVE-2018-1053: Ensure that all temporary files made with "pg_upgrade" are non-world-readable Local fixes to the FreeBSD ports -------------------------------- Inform users about data checksums [1]. Make sure /usr/bin/su is used regardless of PATH settings [2]. Enable DTRACE by default [3]. PR: 214671 [1], 223157 [2], 215028 [3] Security: c602c791-0cf4-11e8-a2ec-6cc21735f730 Notes: svn path=/head/; revision=461251
* Fix ICU depend for postgresql10-server.Mathieu Arnold2018-01-301-0/+4
| | | | | | | | | | PR: 225049 Submitted by: mat Approved by: maintainer timeout Sponsored by: Absolight Notes: svn path=/head/; revision=460386
* Convert to USES=autoreconf.Tijl Coosemans2018-01-111-3/+3
| | | | Notes: svn path=/head/; revision=458764
* databases/postgresql92-server: set LLD_UNSAFEEd Maste2017-12-181-0/+1
| | | | | | | | | | | | | | | | | | | | postgresql*-client ports fail to build with lld as /usr/bin/ld with errors like /usr/bin/ld: error: can't create dynamic relocation R_X86_64_PC32 against symbol: __mb_sb_limit in readonly segment >>> defined in /lib/libc.so.7 >>> referenced by pgstrcasecmp.c >>> pgstrcasecmp.o:(pg_strcasecmp) in archive ../../src/port/libpgport.a Although this appears to affect only -client ports, just set LLD_UNSAFE for all of the postgresql*-* ports for simplicity. Approved by: portmgr (blanket for LLD_UNSAFE) Notes: svn path=/head/; revision=456635
* Update to latest versions of PostgreSQLPalle Girgensohn2017-11-091-2/+2
| | | | | | | | | | | | | | | | | | The PostgreSQL Global Development Group has released an update to all supported versions of our database system, including 10.1, 9.6.6, 9.5.10, 9.4.15, 9.3.20, and 9.2.24. This release fixes three security issues. This release also fixes issues found in BRIN indexing, logical replication and other bugs reported over the past three months. Please note that the CVE-2017-12172 does not affect the FreeBSD port unless you decided to not use the contrib/startscript instead of the startscript distributed with the FreeBSD port/package. Security: CVE-2017-12172, CVE-2017-15099, CVE-2017-15098 URL: https://www.postgresql.org/about/news/1801/ Notes: svn path=/head/; revision=453847
* devel/icu: update to 60.1Jan Beich2017-11-091-1/+1
| | | | | | | | | | Changes: http://site.icu-project.org/download/60 ABI: https://abi-laboratory.pro/tracker/timeline/icu4c/ PR: 223373 Exp-run by: antoine Notes: svn path=/head/; revision=453790
* devel/icu: update to 59.1Jan Beich2017-09-251-1/+1
| | | | | | | | | | | | - Temporarily keep C++98 working in consumers for Clang's default -std= Changes: http://site.icu-project.org/download/59 PR: 218788 Submitted by: takefu@airport.fm, dcarmich@dcarmichael.net (early version) Exp-run by: antoine Notes: svn path=/head/; revision=450556
* The PostgreSQL Global Development Group has released an update to allPalle Girgensohn2017-09-051-2/+2
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | 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 Notes: svn path=/head/; revision=449278
* The PostgreSQL Global Development Group has released an update to allPalle Girgensohn2017-08-101-4/+8
| | | | | | | | | | | | | | | | | supported versions of our database system, including 9.6.4, 9.5.8, 9.4.13, 9.3.18, and 9.2.22. This release fixes three security issues. It also patches over 50 other bugs reported over the last three months. Users who are affected by the below security issues should update as soon as possible. Users affected by CVE-2017-7547 (https://access.redhat.com/security/cve/CVE-2017-7547) will need to perform additional steps after upgrading to resolve the issue. Other users should plan to update at the next convenient downtime. URL: https://www.postgresql.org/about/news/1772/ Security: CVE-2017-7546, CVE-2017-7547, CVE-2017-7548 Notes: svn path=/head/; revision=447678
* Update devel/readline to 7.0 patch 3Sunpoet Po-Chuan Hsieh2017-06-271-1/+1
| | | | | | | | | | | | | | - Bump PORTREVISION for shlib change Changes: https://cnswww.cns.cwru.edu/php/chet/readline/CHANGES https://lists.gnu.org/archive/html/bug-bash/2016-09/msg00107.html https://lists.gnu.org/archive/html/bug-readline/2017-01/msg00002.html Differential Revision: https://reviews.freebsd.org/D11172 PR: 219947 Exp-run by: antoine Notes: svn path=/head/; revision=444463
* Fix OPTIONS_DEFAULT: remove NLS which is added by frameworkSunpoet Po-Chuan Hsieh2017-05-281-1/+1
| | | | | | | Approved by: portmgr (blanket) Notes: svn path=/head/; revision=441950
* PostgreSQL security updatesPalle Girgensohn2017-05-111-1/+1
| | | | | | | | | | | | | | | | | | | | The PostgreSQL Global Development Group has released an update to all supported versions of our database system, including 9.6.3, 9.5.7, 9.4.12, 9.3.17, and 9.2.21. This release fixes three security issues. It also patches a number of other bugs reported over the last three months. Users who use the PGREQUIRESSL environment variable to control connections, and users who rely on security isolation between database users when using foreign servers, should update as soon as possible. Other users should plan to update at the next convenient downtime. URL: https://www.postgresql.org/about/news/1746/ Security: CVE-2017-7484, CVE-2017-7485, CVE-2017-7486 Also modify rcorder and let sshd start before PostgreSQL, so any problems during startup can be reviewed promplty from an ssh login. Notes: svn path=/head/; revision=440628
* PostgreSQL 9.6.2, 9.5.6, 9.4.11, 9.3.16 and 9.2.20 released!Palle Girgensohn2017-02-091-2/+2
| | | | | | | | | | | | | | | | | | | | | | | | | | | | The PostgreSQL Global Development Group has released an update to all supported versions of our database system, including 9.6.2, 9.5.6, 9.4.11, 9.3.16, and 9.2.20. This release includes fixes that prevent data corruption issues in index builds and in certain write-ahead-log replay situations, which are detailed below. It also patches over 75 other bugs reported over the last three months. Users should plan to apply this update at the next scheduled downtime. Build corruption with CREATE INDEX CONCURRENTLY There existed a race condition if CREATE INDEX CONCURRENTLY was called on a column that had not been indexed before, then rows that were updated by transactions running at the same time as the CREATE INDEX CONCURRENTLY command could have been indexed incorrectly. If you suspect this may have happened, the most reliable solution is to rebuild affected indexes after installing this update. This issue is present in the 9.2, 9.3, 9.4, 9.5, and 9.6 series of PostgreSQL. URL https://www.postgresql.org/about/news/1733/ Notes: svn path=/head/; revision=433738
* Mark some ports as not openssl-devel ready.Mathieu Arnold2016-11-291-0/+4
| | | | | | | Sponsored by: Absolight Notes: svn path=/head/; revision=427389
* devel/icu: update to 58.1Jan Beich2016-11-191-1/+1
| | | | | | | | | | Changes: http://site.icu-project.org/download/58 PR: 214384 Exp-run by: antoine Approved by: office (bapt) Notes: svn path=/head/; revision=426525
* Do not redefine DEBUG_DESC when its meaning more or less matches the defaultAlexey Dokuchaev2016-10-281-1/+0
| | | | | | | | option description. Those ports where it meant something more specific were left untouched. Notes: svn path=/head/; revision=424875
* Update PostgreSQL to latest versions.Palle Girgensohn2016-10-271-7/+5
| | | | | | | | | | | | | | The PostgreSQL Global Development Group has released an update to all supported versions of our database system, including 9.6.1, 9.5.5, 9.4.10, 9.3.15, 9.2.19, and 9.1.24. This release fixes two issues that can cause data corruption, which are described in more detail below. It also patches a number of other bugs reported over the last three months. The project urges users to apply this update at the next possible downtime. Notes: svn path=/head/; revision=424765
* - Update devel/icu to 57.1.Tijl Coosemans2016-09-241-1/+2
| | | | | | | | | | | | | | | | | | | | | | | | | | | | - Clean up the Makefile. - Follow some upstream recommendations (--with-data-packaging=archive, --disable-renaming, -DICU_NO_USER_DATA_OVERRIDE). - Patch makefiles to install static libraries with INSTALL_DATA so they aren't stripped. - Patch config/mh-bsd-gcc to sync with config/mh-linux-gcc. - Fix endianness detection in ICU. The code wanted to use BYTE_ORDER defined in machine/endian.h, but this isn't visible because ICU is compiled with _XOPEN_SOURCE. Patch the code to use _BYTE_ORDER instead. - Compile ICU with C++11 compiler to enable move constructors. - Patch ICU to fix a problem with atomics in the case of a C++11 compiler without C++11 header <atomic> (like Clang on FreeBSD 9). - Bump all ports that depend on it due to library version change. - Add USES=compiler:c++0x to some ports that pick up -std=c++0x from ICU pkgconfig files. - Add USES=compiler:c++11-lib to graphics/libcdr01 because it also needs a C++11 runtime library now. Add this to all ports that depend on it so their executables load the right libstdc++.so on FreeBSD 9. PR: 205120 Exp-run by: antoine Approved by: portmgr (antoine) Notes: svn path=/head/; revision=422711
* Fix plist problem for postgresql-9.6 [1]Palle Girgensohn2016-09-071-1/+3
| | | | | | | | | | Fix spelling while here [2] Pointed out by: matthew [1], bcr [2] Pointy hat to: girgen Notes: svn path=/head/; revision=421475
* Fix broken package name for PostgreSQL 9.6 RC1Palle Girgensohn2016-09-051-1/+1
| | | | | | | Fix bad pkg-plist for postgresql 9.6 server Notes: svn path=/head/; revision=421361
* Add PostgreSQL-9.6 RC1Palle Girgensohn2016-09-051-1/+1
| | | | | | | | | | Please read the entry from 20160905 in UPDATING: daemon user has changed to `postgres' ICU is default on Notes: svn path=/head/; revision=421360
* - fix sizesOlli Hauer2016-08-111-1/+1
| | | | | | | | | - s/USE_OPENSSL/USES=ssl/ assumed OK for commit ~1h after first notify about wrong sizes in distinfo Notes: svn path=/head/; revision=420093
* The PostgreSQL Global Development Group has released an update to all supportedPalle Girgensohn2016-08-111-6/+6
| | | | | | | | | | | | | | | | | | versions of our database system, including 9.5.4, 9.4.9, 9.3.14, 9.2.18 and 9.1.23. This release fixes two security issues. It also patches a number of other bugs reported over the last three months. Users who rely on security isolation between database users should update as soon as possible. Other users should plan to update at the next convenient downtime. If you are using the ICU patch, please consult UPDATING. Improve periodic cleanup, suggested by claudius (at) ambtec.de. [1] PR: 210941 [1] Security: CVE-2016-5423, CVE-2016-5424 Notes: svn path=/head/; revision=420089
* do not strip binaries when building with DTRACEChristoph Moench-Tegeder2016-07-091-0/+1
| | | | | | | | | | | stripping would destroy some probes and might result in instable behaviour when trying to access those probes. PR: 204314 Approved by: rene (mentor), maintainer-timeout Notes: svn path=/head/; revision=418277
* Bump PORTREVISION for the icu revert.Mathieu Arnold2016-07-061-1/+1
| | | | | | | | | | | | This time not bumping lang/php70, but devel/php70-intl which is the one really depending on icu. PR: 205120 With hat: portmgr Sponsored by: Absolight Notes: svn path=/head/; revision=418153
* devel/icu: bump PORTREVISION on dependent portsPietro Cerutti2016-07-061-0/+1
| | | | Notes: svn path=/head/; revision=418119
* Update PostgreSQL to latest versionsPalle Girgensohn2016-05-121-1/+1
| | | | | | | URL: http://www.postgresql.org/docs/9.5/static/release-9-5-3.html Notes: svn path=/head/; revision=415091
* Remove ${PORTSDIR}/ from dependencies, categories d, e, f, and g.Mathieu Arnold2016-04-011-3/+3
| | | | | | | | With hat: portmgr Sponsored by: Absolight Notes: svn path=/head/; revision=412346
* Update PostgreSQL 9.1, 9.2 9.3 and 9.4 to latest versions.Palle Girgensohn2016-03-311-1/+1
| | | | | | | URL: http://www.postgresql.org/about/news/1656/ Notes: svn path=/head/; revision=412227
* Update PostgreSQL to latest versions.Palle Girgensohn2016-02-131-2/+1
| | | | | | | | | | | | | | | | | | | | Security Fixes for Regular Expressions, PL/Java This release closes security hole CVE-2016-0773, an issue with regular expression (regex) parsing. Prior code allowed users to pass in expressions which included out-of-range Unicode characters, triggering a backend crash. This issue is critical for PostgreSQL systems with untrusted users or which generate regexes based on user input. The update also fixes CVE-2016-0766, a privilege escalation issue for users of PL/Java. Certain custom configuration settings (GUCS) for PL/Java will now be modifiable only by the database superuser URL: http://www.postgresql.org/about/news/1644/ Security: CVE-2016-0773, CVE-2016-0766 Notes: svn path=/head/; revision=408835
* Some binaries where moved from contrib to base in 9.5, like pgbench andPalle Girgensohn2016-01-131-3/+2
| | | | | | | | | | | | | | | | | | | | | | 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] Notes: svn path=/head/; revision=406034
* Drop 8 support.Mathieu Arnold2015-10-151-3/+0
| | | | | | | | | With hat: portmgr Sponsored by: Absolight Differential Revision: https://reviews.freebsd.org/D3694 Notes: svn path=/head/; revision=399346
* Update PostgreSQL port to latest version.Palle Girgensohn2015-10-081-2/+1
| | | | | | | | | | | | | | | | | | | | | | | 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 Notes: svn path=/head/; revision=398895
* Fix broken XML support.Palle Girgensohn2015-10-061-2/+2
| | | | | | | PR: ports/202649 Notes: svn path=/head/; revision=398690
* Really fix ldap optionBaptiste Daroussin2015-07-241-10/+7
| | | | Notes: svn path=/head/; revision=392771
* Fix ldap optionBaptiste Daroussin2015-07-221-1/+1
| | | | Notes: svn path=/head/; revision=392703
* Only defined options marked as server only for the serversBaptiste Daroussin2015-07-221-14/+20
| | | | | | | Remove (server) from the description Notes: svn path=/head/; revision=392702
* UNIQUENAME is not used anymore for long to save optionsBaptiste Daroussin2015-07-221-6/+0
| | | | Notes: svn path=/head/; revision=392701
* Simplify a bit the MakefilesBaptiste Daroussin2015-07-221-66/+35
| | | | | | | | Use OPTIONS_SUB to automatically PLIST_SUB Use OPTIONS helpers Notes: svn path=/head/; revision=392699
* Cleanup plist and avoid useless @execBaptiste Daroussin2015-07-221-1/+1
| | | | Notes: svn path=/head/; revision=392696
* Update PostgreSQL to latest versions.Palle Girgensohn2015-06-121-1/+1
| | | | | | | | | | | | | Earlier update releases attempted to fix an issue in PostgreSQL 9.3 and 9.4 with "multixact wraparound", but failed to account for issues doing multixact cleanup during crash recovery. This could cause servers to be unable to restart after a crash. As such, all users of 9.3 and 9.4 should apply this update as soon as possible. URL: http://www.postgresql.org/about/news/1592/ Notes: svn path=/head/; revision=389267
* Update PostgreSQL to latest versions.Palle Girgensohn2015-06-051-1/+1
| | | | | | | | | | The update is mostly to fix the file persmission problem described in the URL below. You might want to wait until next upgrade, depending on you local configuration. URL: http://www.postgresql.org/about/news/1590/ Notes: svn path=/head/; revision=388585
* Update PostgreSQL ports to latest version.Palle Girgensohn2015-05-221-4/+2
| | | | | | | | | | | | | | | | | | 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 Notes: svn path=/head/; revision=387089
* MASTER_SITES cleanup.Mathieu Arnold2015-05-141-2/+1
| | | | | | | | | | | | | | | | | | | | | | - Replace ${MASTER_SITE_FOO} with FOO. - Merge MASTER_SITE_SUBDIR into MASTER_SITES when possible. (This means 99.9% of the time.) - Remove occurrences of MASTER_SITE_LOCAL when no subdirectory was present and no hint of what it should be was present. - Fix some logic. - And generally, make things more simple and easy to understand. While there, add magic values to the FESTIVAL, GENTOO, GIMP, GNUPG, QT and SAMBA macros. Also, replace some EXTRACT_SUFX occurences with USES=tar:*. Checked by: make fetch-urlall-list With hat: portmgr Sponsored by: Absolight Notes: svn path=/head/; revision=386312
* Commit the missing part of last commit: Chase upcoming update of ICU to 5.5.Palle Girgensohn2015-04-191-1/+1
| | | | Notes: svn path=/head/; revision=384279
* Chase upcoming update of ICU to 5.5.Palle Girgensohn2015-04-181-0/+1
| | | | Notes: svn path=/head/; revision=384223
* remove redundant cpe markers on the slave portsPalle Girgensohn2015-04-051-3/+1
| | | | Notes: svn path=/head/; revision=383272
* databases category: Remove $PTHREAD_LIBSJohn Marino2015-03-251-4/+2
| | | | | | | | | Note: virtuoso did not pass check-plist from before, so it was fixed. approved by: PTHREAD blanket Notes: svn path=/head/; revision=382201
* databases/postgresql92-server: add CPE informationBartek Rutkowski2015-03-201-0/+2
| | | | | | | | | | - Maintainer's timeout (pgsql@FreeBSD.org) PR: 197487 Submitted by: Shun <shun.fbsd.pr@dropcut.net> Notes: svn path=/head/; revision=381721