aboutsummaryrefslogtreecommitdiff
path: root/databases/postgresql92-server/pkg-plist-client
Commit message (Collapse)AuthorAgeFilesLines
* Update PostgreSQL to latest versions.Palle Girgensohn2016-02-131-27/+29
| | | | | | | | | | | | | | | | | | | | 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
* Simplify a bit the MakefilesBaptiste Daroussin2015-07-221-89/+89
| | | | | | | | 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-46/+0
| | | | Notes: svn path=/head/; revision=392696
* Update PostgreSQL-9.x to latests versions.Palle Girgensohn2015-02-051-48/+48
| | | | | | | | | | | | | | 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 Notes: svn path=/head/; revision=378500
* Stage supportAntoine Brodin2014-02-261-0/+246
| | | | | | | | Reviewed by: postgresql@ Tested by: miwi and me Notes: svn path=/head/; revision=346217
* PostgreSQL 9.2.3, 9.1.8, 9.0.12, 8.4.16 and 8.3.23 releasedPalle Girgensohn2013-02-081-0/+2
| | | | | | | | | | | | | | | This update fixes a denial-of-service (DOS) vulnerability. All users should update their PostgreSQL installations as soon as possible. The security issue fixed in this release, CVE-2013-0255, allows a previously authenticated user to crash the server by calling an internal function with invalid arguments. URL: http://www.postgresql.org/about/news/1446/ Security: http://cve.mitre.org/cgi-bin/cvename.cgi?name=CVE-2013-0255 Notes: svn path=/head/; revision=311915
* The PostgreSQL Global Development Group has released an update to all currentPalle Girgensohn2012-12-061-0/+4
| | | | | | | | | | | | | | | | versions of the PostgreSQL database system, including versions 9.2.2, 9.1.7, 9.0.11, 8.4.15, and 8.3.22. Users of PostgreSQL Hot Standby replication should update at the next possible opportunity. Other users should update at their next maintenance window. Deprecate the 8.3.22 version, since it is near end-of-life. URL: http://www.postgresql.org/about/news/1430/ Feature safe: yes Notes: svn path=/head/; revision=308391
* PostgreSQL 9.2 is released.Palle Girgensohn2012-09-101-14/+0
| | | | | | | | | | | | | "PostgreSQL 9.2 will ship with native JSON support, covering indexes, replication and performance improvements, and many more features." Read more at the web site. URL: http://www.postgresql.org/about/news/1415/ Notes: svn path=/head/; revision=304028
* The PostgreSQL Global Development Group announces the third beta releasePalle Girgensohn2012-08-071-1/+15
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | of PostgreSQL 9.2, which will include major increases in performance and both vertical and horizontal scalability. The PostgreSQL Project asks all users to download and begin testing 9.2 beta 3 as soon as possible. 9.2 Beta 3 includes multiple bug fixes to earlier beta releases, fixing almost all known outstanding issues as of last week. Among them are: * Multiple documentation updates * Apply translation updates * Fixes to transaction log and replication issues with SP-GiST * Replace libpq's "row processor" API with a "single row" mode. * Fix WITH issue with set operations (UNION/INTERSECT/EXCEPT) * Improvements to Autovacuum cancellation * Multiple pg_upgrade fixes * Fix memory leak in pg_recievexlog * Restore statistics collection broken by change to bgwriter * Prevent corner-case coredump with rfree(). If you previously tested 9.2 beta and found one or more bugs, please test 9.2 beta 3 and make sure that those issues are resolved. If you haven't yet tested 9.2, please help out the PostgreSQL project by testing it now! More information on how to test and report issues: http://www.postgresql.org/developer/beta Notes: svn path=/head/; revision=302226
* The PostgreSQL Global Development Group announces the beta release ofPalle Girgensohn2012-05-151-105/+100
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | PostgreSQL 9.2, which will include major increases in performance and both vertical and horizontal scalability. The PostgreSQL Project asks all users to download and begin testing 9.2 Beta as soon as possible. Major performance and scalability advances in this version include: * Index-only scans, allowing users to avoid inefficient scans of base tables * Enhanced read-only workload scaling to 64 cores and over 300,000 queries per second * Improvements to data write speeds, including group commit * Reductions in CPU power consumption * Cascading replication, supporting geographically distributed standby databases PostgreSQL 9.2 will also offer many new features for application developers, including: * JSON data support, enabling hybrid document-relational databases * Range types, supporting new types of calendar, time-series and * analytic applications * Multiple improvements to ALTER and other statements, easing runtime * database updates For a full listing of the features in version 9.2 Beta, please see the release notes: http://www.postgresql.org/docs/devel/static/release-9-2.html We depend on our community to help test the next version in order to guarantee that it is high-performance and bug-free. Please install PostgreSQL 9.2 Beta and try it with your workloads and applications as soon as you can, and give feedback to the PostgreSQL developers. More information on how to test and report issues: http://www.postgresql.org/developer/beta Notes: svn path=/head/; revision=296704
* The PostgreSQL Global Development Group today released security updates for allPalle Girgensohn2012-02-271-0/+6
| | | | | | | | | | | | | | | | | | | active branches of the PostgreSQL object-relational database system, including versions 9.1.3, 9.0.7, 8.4.11 and 8.3.18. Users of pg_dump, users of SSL certificates for validation or users of triggers using SECURITY DEFINER should upgrade their installations immediately. All other database administrators are urged to upgrade your version of PostgreSQL at the next scheduled downtime. More details on the security fixes here: URL: http://www.postgresql.org/about/news/1377/ Security: http://cve.mitre.org/cgi-bin/cvename.cgi?name=CVE-2012-0866 Security: http://cve.mitre.org/cgi-bin/cvename.cgi?name=CVE-2012-0867 Security: http://cve.mitre.org/cgi-bin/cvename.cgi?name=CVE-2012-0868 Notes: svn path=/head/; revision=292310
* The PostgreSQL Global Development Group today released minor version updatesPalle Girgensohn2011-10-181-3/+0
| | | | | | | | | | | | | | | | for all active branches of the PostgreSQL object-relational database system, including versions 9.1.1, 9.0.5, 8.4.9, 8.3.16 and 8.2.22. All users are strongly urged to update their installations at the next scheduled downtime. URL: http://www.postgresql.org/about/news.1355 Cleanup ports. Better handling of the knob PG_USER. Also add uuid to 9.0 and 9.1 contrib ports. Notes: svn path=/head/; revision=283757
* Update to PostgreSQL version 9.1.0Palle Girgensohn2011-09-121-3/+13
| | | | | | | SITE: http://www.postgresql.org/docs/9.1/static/release-9-1.html Notes: svn path=/head/; revision=281659
* Update to 9.1beta2Palle Girgensohn2011-06-141-81/+82
| | | | | | | Fix proken plists wrt NLS Notes: svn path=/head/; revision=275539
* Add postgresql 9.1 beta1.Palle Girgensohn2011-06-111-1/+23
| | | | | | | | | | | | | See http://www.postgresql.org/about/news.1313 for more info. Also, use USERS knob instead of explicitally creating the pgsql user while still accepting alternative names, using [1] with some added magic. PR: 157667 [1] Notes: svn path=/head/; revision=275407
* - Update to 9.0.2Martin Matuska2010-12-311-0/+8
| | | | | | | | | | - Unify ICU handling PR: ports/153245 Approved by: maintainer (timeout) Notes: svn path=/head/; revision=267208
* Update all PostgreSQL ports to latest versions.Palle Girgensohn2010-10-071-2/+5
| | | | | | | | | | | Also, try to break the previous 1:1 relation between FreeBSD system and PostgreSQL versions installed. Use different PREFIX:es to install different versions on the same system. PR: ports/132402, ports/145002, ports/146657 Notes: svn path=/head/; revision=262548
* PostgreSQL 9.0 is here! The PostgreSQL Global Development GroupPalle Girgensohn2010-09-201-73/+96
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | announces the availability of our most eagerly awaited release. PostgreSQL 9.0 includes built-in, binary replication, and over a dozen other major features which will appeal to everyone from web developers to database hackers. 9.0 includes more major features than any release before it, including: * Hot standby * Streaming replication * In-place upgrades * 64-bit Windows builds * Easy mass permissions management * Anonymous blocks and named parameter calls for stored procedures * New windowing functions and ordered aggregates ... and many more. For details on the over 200 additions and improvements in this version, developed by over a hundred contributors, please see the release notes. "These kinds of feature additions continue to make a strong case for why mission-critical technology tasks can continue to depend on the power, flexibility and robustness of PostgreSQL,” said Afilias CTO Ram Mohan. More information on PostgreSQL 9.0: * Release notes http://www.postgresql.org/docs/9.0/static/release-9-0 * Presskit http://www.postgresql.org/about/press/presskit90 * Guide to 9.0: http://wiki.postgresql.org/wiki/What's_new_in_PostgreSQL_9.0 --- PR: 150430, Add dtrace Notes: svn path=/head/; revision=261485
* - Update to 8.4.1Martin Matuska2009-12-021-0/+8
| | | | | | | | | | | - Set INTDATE on as default (this is default by PostgreSQL) PR: ports/139277 Submitted by: Olli Hauer <ohauer@gmx.de> Approved by: maintainer timeout (2 months) Notes: svn path=/head/; revision=245131
* Fix broken pkg-plist for gettext files.Palle Girgensohn2009-07-081-85/+61
| | | | | | | | | Also, inform about pg_standby rather than autovacuum. [1] PR: 136468 [1] Notes: svn path=/head/; revision=237441
* Welcome PostgreSQL 8.4Palle Girgensohn2009-07-071-3/+28
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | After many years of development, PostgreSQL has become feature-complete in many areas. This release shows a targeted approach to adding features (e.g., authentication, monitoring, space reuse), and adds capabilities defined in the later SQL standards. The major areas of enhancement are: Windowing Functions Common Table Expressions and Recursive Queries Default and variadic parameters for functions Parallel Restore Column Permissions Per-database locale settings Improved hash indexes Improved join performance for EXISTS and NOT EXISTS queries Easier-to-use Warm Standby Automatic sizing of the Free Space Map Visibility Map (greatly reduces vacuum overhead for slowly-changing tables) Version-aware psql (backslash commands work against older servers) Support SSL certificates for user authentication Per-function runtime statistics Easy editing of functions in psql New contrib modules: pg_stat_statements, auto_explain, citext, btree_gin URL: http://www.postgresql.org/docs/8.4/interactive/release-8-4.html Notes: svn path=/head/; revision=237379
* Update all PostgreSQL ports to latest versions.Palle Girgensohn2008-01-071-0/+2
| | | | | | | | | | This includes a bunch of security fixes: CVE-2007-6067, CVE-2007-4772, CVE-2007-6601, CVE-2007-6600 and CVE-2007-4769. Security: http://www.postgresql.org/about/news.905 Notes: svn path=/head/; revision=205167
* Update to PostgreSQL 8.3 beta2.Palle Girgensohn2007-11-011-0/+56
| | | | | | | | | | | http://www.postgresql.org/developer/beta This is beta quality, don't use in production. Approved by: portmgr (erwin) Notes: svn path=/head/; revision=202471
* Introducing the first beta of PostgreSQL 8.3Palle Girgensohn2007-10-151-3/+23
| | | | | | | | Note that this is a BETA VERSION of the PostgreSQL server. Use it only for testing. Notes: svn path=/head/; revision=201504
* - Welcome X.org 7.2 \o/.Florent Thoumie2007-05-191-16/+0
| | | | | | | | - Set X11BASE to ${LOCALBASE} for recent ${OSVERSION}. - Bump PORTREVISION for ports intalling files in ${X11BASE}. Notes: svn path=/head/; revision=191544
* Update postgresql to 8.2.1, 8.1.6, 8.0.10, 7.4.15 and 7.3.17.Palle Girgensohn2007-01-091-71/+0
| | | | | | | | | | | | | | | | | | | | | Release notes: http://www.postgresql.org/docs/7.3/static/release.html#RELEASE-7-3-17 http://www.postgresql.org/docs/7.4/static/release.html#RELEASE-7-4-15 http://www.postgresql.org/docs/8.0/static/release.html#RELEASE-8-0-10 http://www.postgresql.org/docs/8.1/static/release.html#RELEASE-8-1-6 http://www.postgresql.org/docs/8.2/static/release-8-2-1.html The server-side utilities of postgresql (initdb, initlocation, ipcclean, pg_controldata, pg_ctl, pg_id and pg_resetxlog) are now installed by the respective postgresql*-server port (previously they where installed with the client). If you update the client, you should also update the server to make sure you are not left without the server-side tools. Do something like: portupgrade postgresql-client postgresql-server Notes: svn path=/head/; revision=181869
* Welcome new release of the world's most advanced open source database:Palle Girgensohn2006-12-061-7/+11
| | | | | | | | | | PostgreSQL 8.2.0 Complete release notes are available at http://www.postgresql.org/docs/current/static/release-8-2.html Notes: svn path=/head/; revision=179046
* eplace ugly "@unexec rmdir %D... 2>/dev/null || true" with @dirrmtryEdwin Groothuis2006-01-221-18/+18
| | | | | | | | Approved by: krion@ PR: ports/88711 (related) Notes: svn path=/head/; revision=154134
* Add 'config' to the list of directories installed by postgresql81-client,Ade Lovett2006-01-071-1/+4
| | | | | | | | | so as to fully install everything needed for pgxs to work correctly. Approved by: maintainer Notes: svn path=/head/; revision=152919
* Welcome to PostgreSQL 8.1.Palle Girgensohn2005-11-101-5/+19
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | The new release includes performance improvements and advanced SQL features which will support bigger data warehouses, higher-volume transaction processing, and more complex distributed enterprise software. Major new features in this release include: Roles: PostgreSQL now supports database roles, which simplify the management of large numbers of users with complex overlapping database rights. IN/OUT Parameters: PostgreSQL functions now support IN, OUT and INOUT parameters, which substantially improves support of complex business logic for J2EE and .NET applications. Two-Phase Commit (2PC): Long in demand for WAN applications and heterogeneous data centers using PostgreSQL, this feature allows ACID-compliant transactions across widely separated servers. Some Performance Enhancements found in this release include: Improved Multiprocessor (SMP) Performance: The buffer manager for 8.1 has been enhanced to scale almost linearly with the number of processors, leading to significant performance gains on 8-way, 16-way, dual-core, and multi-core CPU servers. Bitmap Scan: Indexes will be dynamically converted to bitmaps in memory when appropriate, giving up to twenty times faster index performance on complex queries against very large tables. Table Partitioning: The query planner is now able to avoid scanning whole sections of a large table using a technique known as Constraint Exclusion. Shared Row Locking: PostgreSQL's "better than row-level locking" now supports even higher levels of concurrency through the addition of shared row locks for foreign keys. For a more complete listing of changes in this release, please see the Release Notes visible at: http://www.postgresql.org/docs/current/static/release.html#RELEASE-8-1 Notes: svn path=/head/; revision=147772
* Fixing problems with the recent security patch: When bison was notPalle Girgensohn2005-05-111-0/+9
| | | | | | | | | | | | | | | | | | | | installed, the patched gram.y file would not be used and the security patch would be a no-op. Also, I've had reports of compilation errors related to bison. Since checking for the correct version of bison is hard and error prone, I'm doing what the postgresql distribution does - patching the yacc:ed .c file to get rid of the building dependency. Bumping portrevision of -server. Pointy hat to: me Noticed by: Mike Harding and others Security: http://www.vuxml.org/freebsd/6b4b0b3f-8127-11d9-a9e7-0001020eed82.html Approved by: seanc (implicit) Notes: svn path=/head/; revision=135025
* Upgrade PostgreSQL to 8.0.2. Here's the brief release note:Palle Girgensohn2005-04-131-4/+4
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | Over the past several weeks, Tom Lane has been working on replacing our old Cache Management Alorithm (ARC) with a new, patent free one (2Q). In order to reduce the number of 8.x deployments out there that are using the old manager, we have just released 8.0.2, and encourage adminstrators to upgrade at their earliest convience. For those already running 8.x on your production servers, please note that this upgrade does *NOT* require a dump restore, but due to a bump in the major version number for the client library (libpq), it *WILL* require all client applications to be recompiled at the same time. For full release info, see http://www.postgresql.org/docs/8.0/static/release.html#RELEASE-8-0-2 Apart from the upgrade, three new config options are added: A patch (experimental) for supporting proper collation of utf-8 encoded locales, using IBM's ICU package (devel/icu). See http://people.freebsd.org/~girgen/postgresql-icu/README.html for more info. An optional patch written by Evgen Potemkin, which allows PostgreSQL to make hierarchical queries à la Oracle [1]. An option is added that allows the use of 64 bit ints to store dates [2]. PR: ports/79165 [1], ports/76999 [2] Submitted by: Marcos Tischer Vallim [1], Christian Ullrich [2] Approved by: ade, seanc (implicit) Notes: svn path=/head/; revision=133287
* In order to address a potential security hole recently identified withPalle Girgensohn2005-02-031-0/+1
| | | | | | | | | | | | | | | | | | | | | | the "LOAD" option, the PostgreSQL Global Development Group is announcing the release of new versions of PostgreSQL. Update to 7.3.9, 7.4.7 & 8.0.1. Take the opportunity to reset PORTREVISION of slave ports. Back out name change of startup script. The new script uses rc.subr(8), and as such also uses rcorder(8). But, rcorder does not exist in FreeBSD 4.x. Hence rename the script it back to the top of the directory list. [1] The periodic script should of course be executable. [2] [1] Noted by Niels Chr. Bank-Pedersen <ncbp at bank-pedersen dot dk> [2] Noted by Fritz Heinrichmeyer <fritz.heinrichmeyer at fernuni-hagen dot de> Notes: svn path=/head/; revision=127966
* Say hello to postgresql-8.0. Some of the highlights of the new versionPalle Girgensohn2005-01-311-15/+456
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | are savepoints (within transactions), point-in-time recovery and tablespaces. Check out the release notes and the shiny new PostgreSQL.org website at: http://www.PostgreSQL.org/docs/8.0/static/release.html#RELEASE-8-0 The port uses the new postgresql ports' layout and is split into a server and a client part. The following knobs can be used by ports depending on PostgreSQL: # USE_PGSQL - Add PostgreSQL client dependency. # If no version is given (by the maintainer via the port or # by the user via defined variable), try to find the # currently installed version. Fall back to default if # necessary (PostgreSQL-7.4 = 74). # DEFAULT_PGSQL_VER # - PostgreSQL default version. Can be overridden within a port. # Default: 74. # WANT_PGSQL_VER # - Maintainer can set an arbitrary version of PostgreSQL by # using it. # BROKEN_WITH_PGSQL # - This variable can be defined if the ports doesn't support # one or more versions of PostgreSQL. PR: 75344 Approved by: portmgr@ (kris), ade & sean (mentors) Notes: svn path=/head/; revision=127738
* Another step along the road to the postgresql new world order.Ade Lovett2004-11-231-0/+148
Note that none of these ports are (yet) hooked into the tree, and will not compile unless you set a specific environmental variable. This should be warning enough to leave well alone for now :) Submitted by: maintainer Notes: svn path=/head/; revision=122238