aboutsummaryrefslogtreecommitdiff
path: root/databases/postgresql92-server
Commit message (Collapse)AuthorAgeFilesLines
* - Update to 8.4.2Martin Matuska2009-12-173-4/+5
| | | | | | | | | | | | Security: CVE-2009-4034 Security: CVE-2009-4136 Security: http://portaudit.freebsd.org/e7bc5600-eaa0-11de-bd9c-00215c6a37bb.html PR: ports/141639 Submitted by: Alexander Pyhalov <alp@rsu.ru> Approved by: ports-security (delphij) Notes: svn path=/head/; revision=246051
* - Update to 8.4.1Martin Matuska2009-12-025-21/+34
| | | | | | | | | | | - 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 plist for contribPav Lucistnik2009-09-191-3/+0
| | | | | | | | | | | PR: ports/136654, ports/136962 Reported by: YAMAMOTO Takao <takao@oakat.org>, Gergely Czuczy <gergely.czuczy@harmless.hu> Approved by: maintainer timeout (girgen; 2 months) Feature safe: yes Notes: svn path=/head/; revision=241783
* 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-084-177/+114
| | | | | | | | | 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-077-54/+77
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | 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 Girgensohn2009-03-182-4/+4
| | | | | | | | | | | | | | | | | | | | | The PostgreSQL Project today released minor versions updating all active branches of the PostgreSQL object-relational database system, including versions 8.3.7, 8.2.13, 8.1.17, 8.0.21 and 7.4.25. This release fixes a denial of service issue with encoding conversion, and all users should update their installations at the next reasonable opportunity. There are 12 other minor fixes contained in these update releases, including fixes for xpath() functions in version 8.3. See the release notes for full details. URL: http://www.postgresql.org/docs/8.3/static/release-8-3-7.html URL: http://www.postgresql.org/docs/8.2/static/release-8-2-13.html URL: http://www.postgresql.org/docs/8.1/static/release.html#RELEASE-8-1-17 URL: http://www.postgresql.org/docs/8.0/static/release.html#RELEASE-8-0-21 URL: http://www.postgresql.org/docs/7.4/static/release.html#RELEASE-7-4-24 Notes: svn path=/head/; revision=230359
* Update PostgreSQL to latest versions.Palle Girgensohn2009-02-103-4/+5
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | URL: http://www.postgresql.org/about/news.1055 The PostgreSQL Project today released updates to all active branches of the PostgreSQL object-relational database system, including versions 8.3.6, 8.2.12, 8.1.16, 8.0.20 and 7.4.24. These updates include two serious fixes, for autovacuum crashes in version 8.1 and GiST indexing data loss in 8.3, and those two versions should be updated as soon as possible. These update releases also include patches for several low-risk security holes, as well as up to 17 other minor fixes, depending on your major version of PostgreSQL. Included as well are Daylight Savings Time changes for Nepal, Switzerland and Cuba. See the release notes for full details. The first serious issue affects users who are using version 8.1 with Autovacuum, which will fail when XID rollover is required. The second serious issue can cause data loss when CLUSTER is used with GiST indexes (such as full text indexes) on version 8.3. Both issues are fixed in these releases. Notes: svn path=/head/; revision=227984
* This time, *really* update to *latest* version of PostgreSQL, 8.3.5.Palle Girgensohn2008-11-073-4/+5
| | | | Notes: svn path=/head/; revision=222511
* Update PostgreSQL to latest versions.Palle Girgensohn2008-11-075-11/+9
| | | | | | | | | | | | | | | | | | 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
* Fix missed commit when updating ICU patch to chase update of autoconf 2.61 ↵Palle Girgensohn2008-09-011-1/+1
| | | | | | | -> 2.62 Notes: svn path=/head/; revision=219588
* Update ICU patch to chase update of autoconf 2.61 -> 2.62Palle Girgensohn2008-08-281-3/+3
| | | | | | | | PR: ports/126773 Submitted by: Robert Schulze Notes: svn path=/head/; revision=219377
* Conversion from (now defunct) autoconf-2.61 to autoconf-2.62Ade Lovett2008-08-201-1/+1
| | | | | | | Tested by: exp build run (erwin) Notes: svn path=/head/; revision=218886
* Updates of the PostgreSQL portsPalle Girgensohn2008-06-124-12/+14
| | | | | | | | | | | | | | | | | | | | 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
* Bump portrevision due to upgrade of devel/gettext.Edwin Groothuis2008-06-061-1/+1
| | | | | | | | | | | | | The affected ports are the ones with gettext as a run-dependency according to ports/INDEX-7 (5007 of them) and the ones with USE_GETTEXT in Makefile (29 of them). PR: ports/124340 Submitted by: edwin@ Approved by: portmgr (pav) Notes: svn path=/head/; revision=214430
* - Remove USE_GETOPT_LONG which is a no-op since March 200Pav Lucistnik2008-03-201-8/+0
| | | | Notes: svn path=/head/; revision=209418
* Update to 8.3.1Palle Girgensohn2008-03-183-18/+10
| | | | | | | | Release notes: http://developer.postgresql.org/pgdocs/postgres/release-8-3-1.html Notes: svn path=/head/; revision=209325
* The ICU patch <http://people.freebsd.org/~girgen/postgresql-icu/README.html>Palle Girgensohn2008-03-092-8/+11
| | | | | | | is finally ported to postgresql-8.3, thanks to Petr Jelinek and yours truly. Notes: svn path=/head/; revision=208681
* Remove bad "BETA" alert. This is not beta anymore.Palle Girgensohn2008-02-183-5/+12
| | | | | | | Set update_process_title = off, as suggested by kris@ and others. Notes: svn path=/head/; revision=207511
* Today the PostgreSQL Global Development Group releases thePalle Girgensohn2008-02-043-5/+6
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | long-awaited version 8.3 of the most advanced open source database, which cements our place as the best performing open source database. Among the performance features you'll be excited about in 8.3 are: * Heap Only Tuples * BGWriter Autotuning * Asynchronous Commit * Spread Checkpoints * Synchronous Scan * "Var-Varlena" * L2 Cache Protection * Lazy XID 8.3 also has a lot of cool features for PostgreSQL DBAs and developers, including: * CSV Logging * SQL/XML * MS Visual C++ support * ENUMs * Integrated Tsearch * SSPI & GSSAPI * Composite Type Arrays * pg_standby Notes: svn path=/head/; revision=206719
* Update to RC2.Palle Girgensohn2008-01-225-616/+633
| | | | | | | | | | | | | | | | | [1] Fix problem installing from package. [2] Use DISTVERSION instead of PORTVERSION. (the port reports now correct version 8.3.r2) [2] Enable more 8.3 features: - Add OPTION for the new XML data type (default: enabled) - Add OPTION for usage of system timezone data (default: included tzdata) PR: ports/119770 [1], ports/119561 [2] Submitted by: Artis Caune [1], Martin Matuska [2] Notes: svn path=/head/; revision=206026
* Fix MASTER_SITE_SUBDIRPalle Girgensohn2008-01-091-1/+1
| | | | | | | | PR: ports/119477 Submitted by: Sunpoet Po-Chuan Hsieh Notes: svn path=/head/; revision=205308
* Revert bad commit. The size was OK for *this* version.Palle Girgensohn2008-01-071-1/+1
| | | | Notes: svn path=/head/; revision=205187
* Fix bad distinfo sizesPalle Girgensohn2008-01-071-1/+1
| | | | Notes: svn path=/head/; revision=205186
* Update all PostgreSQL ports to latest versions.Palle Girgensohn2008-01-078-106/+61
| | | | | | | | | | 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
* - Mark BROKEN: unfetchablePav Lucistnik2007-12-141-0/+2
| | | | Notes: svn path=/head/; revision=203625
* Update to PostgreSQL 8.3 beta2.Palle Girgensohn2007-11-015-14/+90
| | | | | | | | | | | 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-156-45/+82
| | | | | | | | Note that this is a BETA VERSION of the PostgreSQL server. Use it only for testing. Notes: svn path=/head/; revision=201504
* Work in progressPalle Girgensohn2007-10-081-0/+2
| | | | Notes: svn path=/head/; revision=201098
* Remove always-false/true conditions based on OSVERSION 500000Edwin Groothuis2007-10-041-4/+0
| | | | Notes: svn path=/head/; revision=200769
* Fix plistAde Lovett2007-09-252-2/+3
| | | | | | | Approved by: maintainer Notes: svn path=/head/; revision=200113
* Update PostgreSQL ports to the latest patch releases.Palle Girgensohn2007-09-172-20/+20
| | | | | | | PR: ports/104075 Notes: svn path=/head/; revision=199626
* - Welcome X.org 7.2 \o/.Florent Thoumie2007-05-193-31/+1
| | | | | | | | - Set X11BASE to ${LOCALBASE} for recent ${OSVERSION}. - Bump PORTREVISION for ports intalling files in ${X11BASE}. Notes: svn path=/head/; revision=191544
* Update PostgreSQL to 7.3.19, 7.4.17, 8.0.13, 8.1.9 and 8.2.4 respectively:Palle Girgensohn2007-04-233-13/+19
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | The PostgreSQL Global Development Group has released updated versions for PostgreSQL 8.2 and all back versions to patch a privilege escalation exploit in SECURITY DEFINER functions. All users of this feature are urged to update to the latest minor version and follow instructions on securing these functions as soon as possible. This minor release also contains other fixes, so all users should plan to deploy it. Once you have updated, additional steps are required to secure your database against the exploit. Please read the release notes at http://www.postgresql.org/docs/8.2/static/release.html and the TechDocs article at http://www.postgresql.org/docs/techdocs.77 on how to lock down your security definer functions, if you use them. As always, application of a minor release does not require a dump and reload of the database. The frequency of security fixes recently is a result of increased scrutiny of the PostgreSQL code by government agencies and security-conscious companies. Rapid turnaround on security patches is key to keeping PostgreSQL the most secure SQL database. Your work and vigilance in applying the latest security updates ensures that there will never be a PostgreSQL "worm". http://www.postgresql.org/docs/8.2/static/release-8-2-4.html http://www.postgresql.org/docs/8.1/static/release.html#RELEASE-8-1-9 http://www.postgresql.org/docs/8.0/static/release.html#RELEASE-8-0-13 http://www.postgresql.org/docs/7.4/static/release.html#RELEASE-7-4-17 http://www.postgresql.org/docs/techdocs.77 Security: http://cve.mitre.org/cgi-bin/cvename.cgi?name=CVE-2007-2138 Notes: svn path=/head/; revision=190743
* Respect PTHREAD_CFLAGS/PTHREAD_LIBS.Norikatsu Shigemura2007-03-181-1/+3
| | | | | | | Approved by: maintainer timeout (1 month) Notes: svn path=/head/; revision=187658
* Update PostgreSQL 8.x to 8.0.12, 8.1.8 and 8.2.3 respectively:Palle Girgensohn2007-02-072-13/+13
| | | | | | | | | The recent security release (8.0.11, 8.1.7, 8.2.2) has been withdrawn. It contained an issue which causes error with custom data types, type constraints and expression indexes. These upgrades fix the problem. Notes: svn path=/head/; revision=184480
* Add option to build with LDAP authenticationPalle Girgensohn2007-02-061-0/+6
| | | | | | | Suggested by: Ederson de Moura Notes: svn path=/head/; revision=184377
* Update PostgreSQL with, amongst other things, two security fixes:Palle Girgensohn2007-02-052-13/+13
| | | | | | | | | | | | | | | | | | | | | | | A vulnerability allows suppressing the normal checks that a SQL function returns the data type it's declared to do. These errors can easily be exploited to cause a backend crash, and in principle might be used to read database content that the user should not be able to access. [CVE-2007-0555] A vulnerability involving changing the data type of a table column can easily be exploited to cause a backend crash, and in principle might be used to read database content that the user should not be able to access. [CVE-2007-0556] The release includes a set of other fixes as well. Please see the release information at http://www.postgresql.org/docs/8.2/static/release-8-2-2.html Security: http://cve.mitre.org/cgi-bin/cvename.cgi?name=CVE-2007-0555 Security: http://cve.mitre.org/cgi-bin/cvename.cgi?name=CVE-2007-0556 Notes: svn path=/head/; revision=184281
* Update postgresql to 8.2.1, 8.1.6, 8.0.10, 7.4.15 and 7.3.17.Palle Girgensohn2007-01-095-91/+89
| | | | | | | | | | | | | | | | | | | | | 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-072-14/+1
| | | | Notes: svn path=/head/; revision=179118
* Welcome new release of the world's most advanced open source database:Palle Girgensohn2006-12-0614-610/+671
| | | | | | | | | | 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
* Mark as work in progressPalle Girgensohn2006-11-061-0/+1
| | | | Notes: svn path=/head/; revision=176590
* The update to handle different versions of ICU was not sufficient.Palle Girgensohn2006-09-272-4/+4
| | | | | | | Update the patches to handle ICU version 3.6 and fall back to 3.4. Notes: svn path=/head/; revision=173972
* Fix bad file name to the ICU patch.Palle Girgensohn2006-09-211-1/+1
| | | | | | | | Pointed out by: Penty Wenngren <penty.wenngren@dgc.se> Pointy hat to: me Notes: svn path=/head/; revision=173543
* Update the patch to be more agnostic with regards to the version of icu.Palle Girgensohn2006-09-202-5/+5
| | | | | | | It now links with icu-3.6 as well as the earlier versions. Notes: svn path=/head/; revision=173449
* There is no point in setting mode of rc.d file to be 554, set it to 555.Maxim Sobolev2006-06-261-2/+2
| | | | | | | | Otherwise there could be problems with the service not starting up in the case when owner of the file has been changed. Notes: svn path=/head/; revision=166410
* Update all PostgreSQL to fix a security flawPalle Girgensohn2006-05-233-15/+15
| | | | | | | | | | | | | | | | | | | | | | 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
* Minor release 8.1.3 patches security issuePalle Girgensohn2006-02-172-14/+16
| | | | | | | | | | Release Note: http://www.postgresql.org/docs/8.1/static/release.html#RELEASE-8-1-3 PR: ports/93440 Submitted by: Hirohisa Yamaguchi <umq@ueo.co.jp> Notes: svn path=/head/; revision=156231