aboutsummaryrefslogtreecommitdiff
path: root/databases/postgresql91-server/files/502.pgsql
Commit message (Collapse)AuthorAgeFilesLines
* Update PostgreSQL to 9.0.4, 8.4.8, 8.3.15 and 8.2.21.Palle Girgensohn2011-04-181-112/+0
| | | | | | | | | | | | | | | | | | | | | | | | | 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
* PostgreSQL 9.0 is here! The PostgreSQL Global Development GroupPalle Girgensohn2010-09-201-6/+24
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | 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 PostgreSQL to latest versions.Palle Girgensohn2008-11-071-6/+3
| | | | | | | | | | | | | | | | | | 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
* Say hello to postgresql-8.0. Some of the highlights of the new versionPalle Girgensohn2005-01-311-1/+1
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | 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-61/+69
| | | | | | | | | | | | 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
* Update PostgreSQL to 7.3.1[1]. Fixes builds for spac64. Many speed,Sean Chittenden2003-01-041-5/+11
| | | | | | | | | | | | | | | | security, and feature additions. Reduce diffs between postgresql-devel port. Re-initdb required when upgrading from previous release. See release notes for details. Schemas added are system catalogs updated. ::braces for impact:: http://developer.postgresql.org/docs/postgres/release.html#RELEASE-7-3-1 PR: ports/46701 Submitted by: girgen@pingpong.net Notes: svn path=/head/; revision=72481
* Port update submitted by maintainerNick Sayer2002-11-061-1/+3
| | | | | | | | PR: ports/44983 Submitted by: girgen@pingpong.net Notes: svn path=/head/; revision=69555
* Update to 7.2.2, which fixes several security bugs. Do not installTrevor Johnson2002-08-261-24/+17
| | | | | | | | | | documentation--it will be in a separate port. PR: 42009 Submitted by: Palle Girgensohn (maintainer) Notes: svn path=/head/; revision=65022
* upgrade to 7.2.1Ying-Chieh Liao2002-04-111-30/+42
| | | | | | | | PR: 36975 Submitted by: maintainer Notes: svn path=/head/; revision=57555
* Upgrade to 7.2, and spilit into several ports.Vanilla I. Shu2002-02-191-0/+76
PR: ports/34855 Submitted by: maintainer. Notes: svn path=/head/; revision=54887