summaryrefslogtreecommitdiff
path: root/databases/postgresql92-server/files (follow)
Commit message (Collapse)AuthorAgeFilesLines
* Remove expired ports:Rene Ladan2018-02-1016-861/+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-082-2/+11
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | 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
* Recommand psycopg2 over PyGreSQLBaptiste Daroussin2017-10-151-1/+1
| | | | | | | Submitted by: Christoph Moench-Tegeder <cmt@burggraben.net> Notes: svn path=/head/; revision=452158
* 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
* Update PostgreSQL to latest versions.Palle Girgensohn2016-10-272-5/+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
* The PostgreSQL Global Development Group has released an update to all supportedPalle Girgensohn2016-08-111-1/+1
| | | | | | | | | | | | | | | | | | 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
* Rename all files containing a : in their filename.Mathieu Arnold2016-06-171-0/+0
| | | | | | | | | | While there, run make makepatch on affected ports, and rename patches accordingly. Sponsored by: Absolight Notes: svn path=/head/; revision=417041
* - Fix trailing whitespace in pkg-messagesDmitry Marakasov2016-05-191-1/+1
| | | | | | | Approved by: portmgr blanket Notes: svn path=/head/; revision=415503
* Update PostgreSQL to latest versions.Palle Girgensohn2016-02-131-10/+11
| | | | | | | | | | | | | | | | | | | | 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
* - Unbreak builds after the lang/python27 update (r363790)Marcus von Appen2014-08-021-11/+0
| | | | | | | Exp-run: 192242, 192244 Notes: svn path=/head/; revision=363792
* Update to the latest snapshots.Chris Rees2014-07-301-106/+95
| | | | | | | | | | | uuid-ossp patch has been outdated with irrelevant changes (for us), so massage back in. In head of postgresql, this is handled properly, so eventually the ossp patches can go. Notes: svn path=/head/; revision=363500
* Fix mistake with ossp-uuid: don't use --with-ossp-uuid, since it will needPalle Girgensohn2014-03-211-0/+10
| | | | | | | the ossp library present, and then we never use it. Notes: svn path=/head/; revision=348732
* The PostgreSQL Global Development Group has released an update to all supportedPalle Girgensohn2014-03-201-0/+393
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | version of the database system, including versions 9.3.4, 9.2.8, 9.1.13, 9.0.17, and 8.4.21. This minor release fixes a data corruption issue with replication and crash recovery in version 9.3, as well as several other minor issues in all versions. All users of version 9.3 are urged to update their installations at the next possible downtime. Users of older versions should update at their convenience. The data corruption issue in PostgreSQL 9.3 affects binary replication standbys, servers being recovered from point-in-time-recovery backup, and standalone servers which recover from a system crash. The bug causes unrecoverable index corruption during recovery due to incorrect replay of row locking operations. This can then cause query results to be inconsistent depending on whether or not an index is used, and eventually lead to primary key violations and similar issues. For this reason, users are encouraged to replace each of their standby databases with a new base backup after applying the update. See release notes for more changes. URL: http://www.postgresql.org/docs/current/static/release.html URL: https://wiki.postgresql.org/wiki/20140320UpdateIssues A change specific to the FreeBSD port: Modify the contrib/uuid-ossp to actually work (not crashing the backend) by using the libc implementation of uuid instead of the ossp port. Schemas and queries will just work. Based on the work of Andrew Gierth. 9.1+ EXTENSION support added by girgen@. URL: http://pgfoundry.org/projects/uuid-freebsd PR: ports/121745, ports/182846 Notes: svn path=/head/; revision=348685
* The PostgreSQL Global Development Group today released security updates for allPalle Girgensohn2012-06-041-12/+0
| | | | | | | | | | | | | | | | | | | | | | | active branches of the PostgreSQL database system, including versions 9.1.4, 9.0.8, 8.4.12 and 8.3.19. Users of the crypt(text, text) function with DES encryption in the optional pg_crypto module should upgrade their installations immediately, if you have'nt already updated since the port was patched on May 30. All other database administrators are urged to upgrade your version of PostgreSQL at the next scheduled downtime. URL: http://www.postgresql.org/about/news/1398/ Security: http://cve.mitre.org/cgi-bin/cvename.cgi?name=CVE-2012-2143 Fix incorrect password transformation in contrib/pgcrypto’s DES crypt() function This was fixed in a patch release for the FreeBSD ports on May 30. Security: http://cve.mitre.org/cgi-bin/cvename.cgi?name=CVE-2012-2655 Ignore SECURITY DEFINER and SET attributes for a procedural language’s call handle Notes: svn path=/head/; revision=298347
* - Address postgresql*-servers for crypt vulnerability (CVE-2012-2143)Jason Helfman2012-05-301-0/+12
| | | | | | | | | http://www.postgresql.org/about/news/1397/ With hat: pgsql Notes: svn path=/head/; revision=297840
* The PostgreSQL Global Development Group announces the beta release ofPalle Girgensohn2012-05-151-8/+0
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | 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-11/+0
| | | | | | | | | | | | | | | | | | | 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
* Remove p5- from postgresql*-plperl 's mention in pkg-message-clientChris Rees2012-02-191-1/+1
| | | | Notes: svn path=/head/; revision=291849
* - Add profile support for PostgreSQL serversJason Helfman2012-01-221-2/+53
| | | | | | | | | | | | | | - re-assign LOCALBASE to PREFIX - add PG_GROUP to SUB_PLIST for packaging fix - fix permissions for package installations PR: ports/162776 Submitted by: jgh, Phil Phillips < pphillips at experts-exchange.com > Reviewed by: rene (mentor) Approved by: crees (maintainer, mentor) Notes: svn path=/head/; revision=289587
* In the rc.d scripts, change assignments to rcvar to use theDoug Barton2012-01-141-1/+1
| | | | | | | | | | | | | | literal name_enable wherever possible, and ${name}_enable when it's not, to prepare for the demise of set_rcvar(). In cases where I had to hand-edit unusual instances also modify formatting slightly to be more uniform (and in some cases, correct). This includes adding some $FreeBSD$ tags, and most importantly moving rcvar= to right after name= so it's clear that one is derived from the other. Notes: svn path=/head/; revision=289156
* The PostgreSQL Global Development Group today released minor version updatesPalle Girgensohn2011-10-183-36/+13
| | | | | | | | | | | | | | | | 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
* - Add ICU support to PostgreSQL 9.1 serverMartin Matuska2011-10-061-46/+0
| | | | | | | | | | | | - Make SSL available as an option - Make portlint happier - Fix some typos PR: ports/160915 Approved by: maintainer (timeout) Notes: svn path=/head/; revision=283031
* - Unbreak postgresql-plpython: allow build with threaded pythonSunpoet Po-Chuan Hsieh2011-10-021-0/+11
| | | | | | | | | | - Pass maintainership to submitter PR: ports/159843 Submitted by: Ruslan Mahmatkhanov <cvs-src@yandex.ru> Notes: svn path=/head/; revision=282829
* Don't rebuild manual pages if configure was changedEygene Ryabinkin2011-09-251-0/+17
| | | | | | | | | | | | | | | | Sometimes patches for PostgreSQL touch its configure script. And the logics inside current Makefiles for the documentation makes the manual pages (and other stuff) to be dependent of the timestamp of the top-level configure file. This triggers the rebuild of the manual pages, but since some additional XML-related tools are needed, this rebuild can fail. PR: 159844 Approved by: maintainer timeout (1 month) Feature safe: yes Notes: svn path=/head/; revision=282389
* Add postgresql 9.1 beta1.Palle Girgensohn2011-06-113-50/+13
| | | | | | | | | | | | | 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
* Fix typo in 502.pgsql scriptPalle Girgensohn2011-04-201-2/+2
| | | | | | | PR: 156515 Notes: svn path=/head/; revision=272955
* Update PostgreSQL to 9.0.4, 8.4.8, 8.3.15 and 8.2.21.Palle Girgensohn2011-04-184-12/+78
| | | | | | | | | | | | | | | | | | | | | | | | | This update contains a critical fix to the pg_upgrade utility which prevents significant downtime issues. Do not use pg_upgrade without installing this update first. The issue with pg_upgrade and the fix are detailed on the PostgreSQL wiki: http://wiki.postgresql.org/wiki/20110408pg_upgrade_fix Users who have already used pg_upgrade should run the database repair script given on that page on their databases as soon as possible. See the release notes for each version at http://www.postgresql.org/docs/current/static/release.html for a full list of changes with details. Allow the username of the postgresql user to configurable for 8.4 and 9.0. Largely inspired by the work of Jason Helfman [153668, 153136]. Change PGUSER knob to PG_USER not to clash with PGUSER environment. PR: 153668, 153136, 155493, 155137 Notes: svn path=/head/; revision=272900
* - Update to 9.0.2Martin Matuska2010-12-311-0/+46
| | | | | | | | | | - 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-7/+7
| | | | | | | | | | | 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-203-52/+52
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | 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
* Begin the process of deprecating sysutils/rc_subr byDoug Barton2010-03-271-1/+1
| | | | | | | s#. %%RC_SUBR%%#. /etc/rc.subr# Notes: svn path=/head/; revision=251553
* - Add ICU 4.x supportMartin Matuska2010-03-251-0/+30
| | | | | | | | | | | - Bump PORTREVISION PR: ports/143841 Submitted by: Andrei Lavreniyuk <andy.lavr@reactor-xg.kiev.ua> Approved by: maintainer (timeout) Notes: svn path=/head/; revision=251513
* - Update to 8.4.1Martin Matuska2009-12-021-13/+14
| | | | | | | | | | | - 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 a few "bad example" problems in the rc.d scripts that have beenDoug Barton2009-07-151-3/+2
| | | | | | | | | | | | | | | | | | | | | | | propogated by copy and paste. 1. Primarily the "empty variable" default assignment, which is mostly ${name}_flags="", but fix a few others as well. 2. Where they are not already documented, add the existence of the _flags (or other deleted empties) option to the comments, and in some cases add comments from scratch. 3. Replace things that look like: prefix=%%PREFIX%% command=${prefix}/sbin/foo to just use %%PREFIX%%. In many cases the $prefix variable is only used once, and in some cases it is not used at all. 4. In a few cases remove ${name}_flags from command_args 5. Remove a long-stale comment about putting the port's rc.d script in /etc/rc.d (which is no longer necessary). No PORTREVISION bumps because all of these changes are noops. Notes: svn path=/head/; revision=237892
* Fix broken pkg-plist for gettext files.Palle Girgensohn2009-07-081-1/+1
| | | | | | | | | Also, inform about pg_standby rather than autovacuum. [1] PR: 136468 [1] Notes: svn path=/head/; revision=237441
* Welcome PostgreSQL 8.4Palle Girgensohn2009-07-081-0/+11
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | 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=237405
* Welcome PostgreSQL 8.4Palle Girgensohn2009-07-072-15/+3
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | 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 PostgreSQL to latest versions.Palle Girgensohn2008-11-072-7/+4
| | | | | | | | | | | | | | | | | | http://www.postgresql.org/docs/current/static/release-8-3-5.html http://www.postgresql.org/docs/current/static/release-8-2-11.html http://www.postgresql.org/docs/current/static/release-8-1-15.html http://www.postgresql.org/docs/current/static/release-8-0-19.html http://www.postgresql.org/docs/current/static/release-7-4-23.html Note that the GiST problem mentioned does not apply to users of the FreeBSD port, since the previous version of PostgreSQL never reached the ports tree, due to the freeze of the tree pending the FreeBSD 7.1 update. PR: 121848, 124713 Notes: svn path=/head/; revision=222485
* Updates of the PostgreSQL portsPalle Girgensohn2008-06-121-3/+3
| | | | | | | | | | | | | | | | | | | | Updates for all maintained versions of PostgreSQL are available today: 8.3.3, 8.2.9, 8.1.13, 8.0.17 and 7.4.21. These releases fix more than two dozen minor issues reported and patched over the last few months. All PostgreSQL users should plan to update at their earliest convenience. People in affected time zones, in particular, should upgrade as soon as possible. Release Notes: http://www.postgresql.org/docs/8.3/static/release.html Also, fix umask error in periodic script [1]. PR: ports/124457 [1] Submitted by: Alexandre Perrin Notes: svn path=/head/; revision=214728
* Remove bad "BETA" alert. This is not beta anymore.Palle Girgensohn2008-02-181-2/+11
| | | | | | | Set update_process_title = off, as suggested by kris@ and others. Notes: svn path=/head/; revision=207511
* Update all PostgreSQL ports to latest versions.Palle Girgensohn2008-01-072-21/+32
| | | | | | | | | | 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 postgresql to 8.2.1, 8.1.6, 8.0.10, 7.4.15 and 7.3.17.Palle Girgensohn2007-01-091-3/+3
| | | | | | | | | | | | | | | | | | | | | 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
* Fix build problems when using WITH_THREADSAFEPalle Girgensohn2006-12-071-12/+0
| | | | Notes: svn path=/head/; revision=179118
* Welcome new release of the world's most advanced open source database:Palle Girgensohn2006-12-068-2/+130
| | | | | | | | | | 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
* Update all PostgreSQL to fix a security flawPalle Girgensohn2006-05-231-1/+1
| | | | | | | | | | | | | | | | | | | | | | The PostgreSQL Global Development Group today released versions 8.1.4, 8.0.8, 7.4.13 and 7.3.15. This is an urgent update to close a security hole which can permit a SQL injection attack on some applications running PostgreSQL. Users are urged to apply the update as soon as reasonably possible. Since the update affects client functionality, most driver projects will be updating this week as well. Because the security issue involved is complex, we have added a section in Techdocs to explain it: http://www.postgresql.org/docs/techdocs.52. Please read this first before applying the updates. Also, fix rc_subr startup problems on FreeBSD-7.x. Security: http://www.postgresql.org/docs/techdocs.50 PR: ports/95154 Notes: svn path=/head/; revision=163198
* Remove the FreeBSD KEYWORD from all rc.d scripts where it appears.Doug Barton2006-02-201-1/+1
| | | | | | | | | | We have not checked for this KEYWORD for a long time now, so this is a complete noop, and thus no PORTREVISION bump. Removing it at this point is mostly for pedantic reasons, and partly to avoid perpetuating this anachronism by copy and paste to future scripts. Notes: svn path=/head/; revision=156534
* Handle a change in rc.subr. nowadays, "faststart" is used instead ofPalle Girgensohn2005-12-251-2/+2
| | | | | | | | | | | | | "start" when booting, since there's no need waste time checking for running processes when the OS is starting up. Bumping portrevision. PR: 90884 Submitted by: Victor Snezhko <snezhko@indorsoft.ru> Notes: svn path=/head/; revision=152024
* Welcome to PostgreSQL 8.1.Palle Girgensohn2005-11-102-21/+12
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | 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
* Upgrade PostgreSQL to 8.0.2. Here's the brief release note:Palle Girgensohn2005-04-132-171/+0
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | 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
* Modify 8.0's startup script to simulate a full login (su -l) [1]. AlsoPalle Girgensohn2005-03-191-2/+3
| | | | | | | | | | | | | | | | add support to select login class for running postgresql [2]. The new startup script, using rc.subr, is now installed for all versions of postgresql. Bump portrevisions, since startup script is modified. PR: 78630 [1] Submitted by: Vivek Khera [1] Submitted by: Brian B. [2] Approved by: seanc (implicit) Notes: svn path=/head/; revision=131605
generated by cgit v1.2.3 (git 2.25.1) at 2025-10-31 10:14:45 +0000