summaryrefslogtreecommitdiff
path: root/databases/postgresql82-server (follow)
Commit message (Collapse)AuthorAgeFilesLines
* Remove PostgreSQL 8.2 due to EOL by upstreamChris Rees2012-04-1527-1973/+0
| | | | | With hat: pgsql Reviewed by: pgsql
* Over to new team, pgsql@FreeBSD.orgChris Rees2012-03-041-1/+1
|
* Mark FORBIDDENChris Rees2012-02-281-0/+1
| | | | Security: http://www.postgresql.org/about/news/1377/
* Remove p5- from postgresql*-plperl 's mention in pkg-message-clientChris Rees2012-02-191-1/+1
|
* Update to 8.3.17 and 8.2.23.Chris Rees2012-02-173-4/+5
| | | | | Please note that 8.2 is still deprecated, and any users are still strongly encouraged to move to 8.4 as soon as possible.
* Postgresql-8.2 is no longer supported by upstream.Chris Rees2012-01-271-0/+3
| | | | | | Time to upgrade! Port expires on 2012-03-27
* - To preserve my sanity, slave 82 and 83 to 84, and 90 to 91, resulting inChris Rees2012-01-251-290/+8
| | | | | | | | three fewer Makefiles to maintain - Switch patch master site - Various cleanups
* - Add profile support for PostgreSQL serversJason Helfman2012-01-223-7/+59
| | | | | | | | | | | - 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)
* fix typo %%PG_GROUP%% in pkg-plist-serverJason Helfman2012-01-192-2/+2
| | | | | Spotted by: decke Approved by: crees, rene (mentors,implicit)
* - Reset ports due to maintainer timeouts and lack of response to emailsThomas Abthorpe2012-01-191-1/+1
| | | | With hat: portmgr
* Fix plist to create directory with proper ownerships PostgreSQL databaseJason Helfman2012-01-182-1/+4
| | | | | | | | may start. PR: ports/164273 (critical) Submitted by: Alexander Yerenkow <yerenkow at gmail.com> Approved by: maintainer-timeout: girgen (1 day), portmgr (linimon)
* 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.
* The PostgreSQL Global Development Group today released updates for allPalle Girgensohn2011-12-051-2/+0
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | active branches of the PostgreSQL object-relational database system, including versions 9.1.2, 9.0.6, 8.4.10, 8.3.17 and 8.2.23. This release contains 52 fixes to version 9.1, and a smaller number of fixes to older versions, including: - Fix bugs in information_schema.referential_constraints view** - Correct collations for citext columns and indexes** - Prevent possible crash when joining to a scalar function - Prevent transitory data corruption of GIN indexes after a crash - Prevent data corruption on TOAST columns when copying data - Fix failures during hot standby startup - Correct another "variable not found in subplan target list" bug - Fix bug with sorting on aggregate expressions in windowing functions - Multiple bug fixes for pg_upgrade - Change Foreign Key creation order to better support self-referential keys** - Multiple bug fixes to CREATE EXTENSION - Ensure that function return type and data returned from PL/perl agree - Ensure that PL/perl strings are always UTF-8 - Assorted bug fixes for various Extensions - Updates to the time zone database, particularly to CST6 Changes marked with ** above require additional, post-update steps in order to fix all described issues. URL: http://www.postgresql.org/docs/current/static/release.html Also, fix a pthread problem in the FreeBSD port. [1] PR: 160580 [1] Feature safe: yes
* Make SSL available as an optionMartin Matuska2011-10-211-13/+13
| | | | | PR: ports/161328 Approved by: maintainer (timeout)
* - Fix packaging issue (missed %%PG_USER%% in pkg-plist-server)Chris Rees2011-10-202-2/+2
| | | | | | | | - Remove extra bsd.port.pre.mk include from postgresql82-server PR: ports/161816 ports/161824 ports/161821 Submitted by: Jason Helfman (jhelfman@e-e.com) Approved by: portmgr (pav)
* This time remember to bump PORTREVISIONChris Rees2011-10-191-0/+1
|
* Fix SUB_LIST issue by deconditionalising it.Chris Rees2011-10-191-3/+4
| | | | | | | | Temporary fix, but will stop the flurry of incoming PRs related. PR: ports/161779 ports/161774 ports/161791 ports/161771 ports/161769 Submitted by: Many people, original fix suggested by Jason Helfman (jhelfman@e-e.com) Approved by: portmgr (pav)
* The PostgreSQL Global Development Group today released minor version updatesPalle Girgensohn2011-10-186-121/+67
| | | | | | | | | | | | | 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.
* - 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>
* - Add LDFLAGS to CONFIGURE_ENV and MAKE_ENV (as it was done with LDFLAGS)Dmitry Marakasov2011-09-231-1/+1
| | | | | | | | | - Fix all ports that add {CPP,LD}FLAGS to *_ENV to modify flags instead PR: 157936 Submitted by: myself Exp-runs by: pav Approved by: pav
* Revert previous commit -- appears to cause rc problems as I missed some subsChris Rees2011-08-152-2/+45
| | | | | | | | http://www.mail-archive.com/freebsd-ports@freebsd.org/msg35324.html PR: ports/157558 ports/157559 ports/157666 ports/157669 Submitted by: rihad@mail.ru Approved by: maintainer (girgen; implicit -- this reverts a commit I did after maintainer timeout)
* - Fix databases/p5-postgresql-plperl build with Perl 5.14Sunpoet Po-Chuan Hsieh2011-08-141-0/+28
| | | | | | | | | This patch is for PostgreSQL 8.2, 8.3, 8.4 and 9.0. PostgreSQL 9.1 has it already. PR: ports/158727 Submitted by: sunpoet (myself) Approved by: girgen (maintainer timeout, 5 weeks)
* Use USERS and GROUPSChris Rees2011-08-122-45/+2
| | | | | | PR: ports/157559 Submitted by: me Approved by: maintainer timeout (girgen, 9 weeks)
* Update PostgreSQL to 9.0.4, 8.4.8, 8.3.15 and 8.2.21.Palle Girgensohn2011-04-184-6/+9
| | | | | | | | | | | | | | | | | | | | | | 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
* Update to versions 9.0.3, 8.4.7, 8.3.14 and 8.2.20.Palle Girgensohn2011-02-012-3/+3
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | This update includes a security fix which prevents a buffer overrun in the contrib module intarray's input function for the query_int type. This bug is a security risk since the function's return address could be overwritten by malicious code. All supported versions of PostgreSQL are impacted. However, the affected contrib module is optional. Only users who have installed the intarray module in their database are affected. See the CVE Advisory at http://cve.mitre.org/cgi-bin/cvename.cgi?name=CVE-2010-4015 This release includes 63 bugfixes, including: - Avoid unexpected conversion overflow in planner for distant date values - Fix assignment to an array slice that is before the existing range of subscripts - Fix pg_restore to do the right thing when escaping large objects - Avoid failures when EXPLAIN tries to display a simple-form CASE expression - Improved build support for Windows version - Fix bug in contrib/seg's GiST picksplit algorithm which caused performance degredation The 9.0.3 update also contains several fixes for issues with features introduced or changed in version 9.0: - Ensure all the received WAL is fsync'd to disk before exiting walreceiver - Improve performance of walreceiver by avoiding excess fsync activity - Make ALTER TABLE revalidate uniqueness and exclusion constraints when needed - Fix EvalPlanQual for UPDATE of an inheritance tree when the tables are not all alike PR: ports/154436 Security: http://cve.mitre.org/cgi-bin/cvename.cgi?name=CVE-2010-4015 Feature safe: yes Approved by: portmgr
* Fix @dirrmtry since it already filter stderr and return true.Andrej Zverev2011-01-301-5/+5
| | | | | | | PR: ports/153893 Submitted by: az@ Approved by: maintainer (timeout) Feature safe: yes
* - Update to 8.2.19Martin Matuska2010-12-312-5/+3
| | | | | PR: ports/153245 Approved by: maintainer (timeout)
* Sync to new bsd.autotools.mkAde Lovett2010-12-041-1/+1
|
* - Fix optional dependency on security/heimdalRene Ladan2010-11-211-1/+2
| | | | | | | | | - Bump PORTREVISION PR: ports/152029 Submitted by: Joerg Pulz [Joerg.Pulz frm2.tum.de] Approved by: Ryan Steinmetz <rpsfa@rit.edu> (maintainer of net/freeradius*) girgen (maintainer of databases/postgresql*-server, 14 day timeout)
* Punt autoconf267->autoconf268Ade Lovett2010-10-161-1/+1
|
* Update all PostgreSQL ports to latest versions.Palle Girgensohn2010-10-073-11/+15
| | | | | | | | 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
* Autotools update. Read ports/UPDATING 20100915 for details.Ade Lovett2010-09-151-2/+2
| | | | | Approved by: portmgr (for Mk/bsd.port.mk part) Tested by: Multiple -exp runs
* BROKEN should not be quoted.Erwin Lansing2010-06-131-1/+1
| | | | No functional change.
* Bounce PORTREVISION for gettext-related ports. Have fun, ya'll.Ade Lovett2010-05-311-0/+1
|
* Update all PostgreSQL ports to latest version.Palle Girgensohn2010-05-204-17/+37
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | Remove postgresql-contrib in favour for postgresqlNN-contrib. This way we will get packages built, which is nice. Security: CVE-2010-1169 Security: CVE-2010-1170 The PostgreSQL Project today released minor versions updating all active branches of the PostgreSQL object-relational database system, including versions 8.4.4, 8.3.11, 8.2.17, 8.1.21, 8.0.25, and 7.4.29. This release fixes moderate-risk security issues with PL/perl and PL/tcl, as well as a data corruption issue with standby databases. Users of any of these three features should update their PostgreSQL installations immediately. The PL/perl security fix closes a security hole in PL/perl procedures which could allow privilege escalation on the host system, caused by a flaw in Safe.pm; see CVE-2010-1169 and CVE-2010-1447 for details. A second patch prevents PL/tcl's pltcl_modules table from being subverted in order to run arbitrary Tcl scripts; see CVE-2010-1170. These issues only affect users who have enabled either of these two stored procedure languages. Also corrected is use of the command ALTER TABLE SET TABLESPACE, which previously could cause data corruption on Warm Standby database slaves. This issue affects only version 8.4. There are also 21 other bug fixes in this release, some of which apply only to version 8.4, and a few of which are specifically for Windows. While these are generally fixes for minor issues, among the changes are: * Fix for a combinational crash condition * Prevent normal users from resetting some GUCs in their own role definitions * Correctly apply constraint exclusion in UPDATE and DELETE queries * Minor fixes for WAL archiving * Update timezone data for 12 zones See the release notes for a full list of changes with details. Releasenotes at http://www.postgresql.org/docs/current/static/release.html
* Begin the process of deprecating sysutils/rc_subr byDoug Barton2010-03-271-1/+1
| | | | s#. %%RC_SUBR%%#. /etc/rc.subr#
* PTHREAD_[CFLAGS|LDFLAGS] are already set in CONFIGURE_ENV.Alex Dupre2010-01-041-3/+0
| | | | Approved by: portmgr and maintainer timeout (1 month)
* Don't link unneeded PTHREAD_LIBS. This fixes php extensions and apache modules.Alex Dupre2010-01-041-0/+4
| | | | Approved by: portmgr and maintainer timeout (1 month)
* Security update to 8.2.15.Xin LI2009-12-203-4/+5
| | | | | | Security: vid e7bc5600-eaa0-11de-bd9c-00215c6a37bb Security: CVE-2009-4034 CVE-2009-4136 With hat: ports-security
* 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.
* 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
* 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.
* Update PostgreSQL to the very latest version, 8.2.11Palle Girgensohn2008-11-073-4/+5
|
* Update PostgreSQL to latest versions.Palle Girgensohn2008-11-074-5/+6
| | | | | | | | | | | | | | | 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
* Conversion from (now defunct) autoconf-2.61 to autoconf-2.62Ade Lovett2008-08-201-1/+1
| | | | Tested by: exp build run (erwin)
* Updates of the PostgreSQL portsPalle Girgensohn2008-06-124-8/+10
| | | | | | | | | | | | | | | | | 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
* 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)
* - Remove USE_GETOPT_LONG which is a no-op since March 200Pav Lucistnik2008-03-201-8/+0
|
* Update to 8.2.7Palle Girgensohn2008-03-182-23/+8
| | | | | | | | | | | | | | | | Release notes: http://developer.postgresql.org/pgdocs/postgres/release-8-2-7.html Remove HIER patch option, since it is not available anymore. The site is down and original author responses that he does not maintain it anymore. PR: ports/116423 Remove option to build and link with thread safety, and always build thread safe instead. Decided after a discussion with postgresql hackers, and tested for a while in postgresql83. This helps when for example linking with openldap, or for using certain programming languages as postgresql functions.
* Update all PostgreSQL ports to latest versions.Palle Girgensohn2008-01-074-25/+20
| | | | | | | 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