summaryrefslogtreecommitdiff
path: root/databases/postgresql91-server (follow)
Commit message (Collapse)AuthorAgeFilesLines
* fix typo %%PG_GROUP%% in pkg-plist-serverJason Helfman2012-01-192-2/+2
| | | | | | | | Spotted by: decke Approved by: crees, rene (mentors,implicit) Notes: svn path=/head/; revision=289481
* - Reset ports due to maintainer timeouts and lack of response to emailsThomas Abthorpe2012-01-191-1/+1
| | | | | | | With hat: portmgr Notes: svn path=/head/; revision=289435
* Fix plist to create directory with proper ownerships PostgreSQL databaseJason Helfman2012-01-182-0/+4
| | | | | | | | | | | may start. PR: ports/164273 (critical) Submitted by: Alexander Yerenkow <yerenkow at gmail.com> Approved by: maintainer-timeout: girgen (1 day), portmgr (linimon) Notes: svn path=/head/; revision=289423
* 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 updates for allPalle Girgensohn2011-12-053-22/+7
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | 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 Notes: svn path=/head/; revision=286930
* Add DTRACE option for postgresql84-serverChris Rees2011-11-301-1/+6
| | | | | | | | | | | | | | | | | | | | | | PR: ports/150431 Submitted by: rpaulo Fix compilation with GSSAPI PR: ports/161786 Submitted by: rea Reviewed by: mandree, John Marshall <john.marshall@riverwillow.com.au> Mark IGNORE if DTRACE enabled for FreeBSD < 900021 without userland dtrace PR: ports/152502 Submitted by: Sevan Janiyan <venture37@geeklan.co.uk> Approved by: maintainer timeout (girgen, at least 2 months) Feature safe: yes Notes: svn path=/head/; revision=286685
* - do not conflict with postgresql 7.x (we don't have them in a tree anymore)Chris Rees2011-10-293-15/+14
| | | | | | | | | | | | - remove not-supported FreeBSD versions - whitespace fixes in pkg-descr - remove empty pkg-plist (portlint doesn't seems care) PR: ports/161987 Submitted by: Ruslan Mahmatkhanov <cvs-src@yandex.ru> Notes: svn path=/head/; revision=284621
* - Fix plist when postgresql-plpython installed for postgresql 9.1 andGreg Larkin2011-10-261-1/+1
| | | | | | | | | | | postgresql-plpython built with python 3+ PR: ports/161822 Submitted by: sunpoet Approved by: Ruslan Mahmatkhanov <cvs-src@yandex.ru> (maintainer), girgen (maintainer implicit) Notes: svn path=/head/; revision=284373
* - Fix packaging issue (missed %%PG_USER%% in pkg-plist-server)Chris Rees2011-10-202-0/+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) Notes: svn path=/head/; revision=284016
* This time remember to bump PORTREVISIONChris Rees2011-10-191-1/+1
| | | | Notes: svn path=/head/; revision=283933
* 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) Notes: svn path=/head/; revision=283932
* The PostgreSQL Global Development Group today released minor version updatesPalle Girgensohn2011-10-188-29/+34
| | | | | | | | | | | | | | | | 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-063-80/+35
| | | | | | | | | | | | - 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-022-1/+22
| | | | | | | | | | - 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
* PostgreSQL: unbreak GSSAPI supportEygene Ryabinkin2011-09-251-0/+7
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | The problem with GSSAPI without Kerberos is that configure.in has very funny logics of choosing GSSAPI libraries: {{{ if test "$with_gssapi" = yes ; then if test "$PORTNAME" != "win32"; then AC_SEARCH_LIBS(gss_init_sec_context, [gssapi_krb5 gss 'gssapi -lkrb5 -lcrypto'], [], [AC_MSG_ERROR([could not find function 'gss_init_sec_context' required for GSSAPI])]) else LIBS="$LIBS -lgssapi32" fi fi }}} This makes configure to happily choose -lgssapi_krb5 when the system has Kerberos support (NO_KERBEROS is absent), but ld's '--as-needed' will throw this library away when no Kerberos functions are used and linker won't produce 'postgres' binary whining about unresolved symbols: {{{ cc -O2 -pipe -fno-strict-aliasing -Wall -Wmissing-prototypes \ -Wpointer-arith -Wdeclaration-after-statement -Wendif-labels \ -fno-strict-aliasing -fwrapv -L../../src/port -L/usr/local/lib \ -rpath=/usr/lib:/usr/local/lib -L/usr/local/lib -L/usr/local/lib \ -Wl,--as-needed -Wl,-R'/usr/local/lib' -Wl,-export-dynamic \ [... a bunch of *.o files was stripped ...] ../../src/timezone/pgtz.o ../../src/port/libpgport_srv.a -lintl -lssl \ -lcrypto -lgssapi_krb5 -lcrypt -lm -o postgres libpq/auth.o: In function `pg_GSS_error': auth.c:(.text+0x6e): undefined reference to `gss_display_status' auth.c:(.text+0x8e): undefined reference to `gss_release_buffer' auth.c:(.text+0xc5): undefined reference to `gss_display_status' auth.c:(.text+0xe5): undefined reference to `gss_release_buffer' libpq/auth.o: In function `ClientAuthentication': auth.c:(.text+0x82d): undefined reference to `gss_delete_sec_context' auth.c:(.text+0x941): undefined reference to `gss_accept_sec_context' auth.c:(.text+0x9f1): undefined reference to `gss_release_buffer' auth.c:(.text+0xaf3): undefined reference to `gss_release_cred' auth.c:(.text+0xb10): undefined reference to `gss_display_name' auth.c:(.text+0xbc8): undefined reference to `gss_release_buffer' auth.c:(.text+0x10b0): undefined reference to `gss_release_buffer' auth.c:(.text+0x111e): undefined reference to `gss_release_buffer' libpq/pqcomm.o: In function `pq_close': pqcomm.c:(.text+0x105a): undefined reference to `gss_delete_sec_context' pqcomm.c:(.text+0x107d): undefined reference to `gss_release_cred' gmake: *** [postgres] Error 1 }}} Also, ports for PostgreSQL 8.4 and 9.0 had their <bsd.port.pre.mk> misplaced: OPTIONS came after it, so WITH_/WITHOUT_ knobs will not be really activated. PR: 160050 Feature safe: yes Approved by: maintainer timeout (1 month) Notes: svn path=/head/; revision=282381
* - Add LDFLAGS to CONFIGURE_ENV and MAKE_ENV (as it was done with LDFLAGS)Dmitry Marakasov2011-09-231-2/+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 Notes: svn path=/head/; revision=282282
* Update to PostgreSQL version 9.1.0Palle Girgensohn2011-09-124-15/+29
| | | | | | | SITE: http://www.postgresql.org/docs/9.1/static/release-9-1.html Notes: svn path=/head/; revision=281659
* - Unbreak slavesPav Lucistnik2011-08-071-0/+3
| | | | | | | Reported by: Portsnap buildbox Notes: svn path=/head/; revision=279148
* - Make those OPTIONS actually working at allPav Lucistnik2011-08-071-2/+2
| | | | | | | Reported by: pointyhat Notes: svn path=/head/; revision=279145
* Update to 9.1 beta 3Palle Girgensohn2011-07-203-5/+5
| | | | | | | | Fix broken plist for the postgres user's home directory Release notes at http://www.postgresql.org/about/news.1331 Notes: svn path=/head/; revision=278000
* - Mark BROKEN: leave a directory behind on deinstallPav Lucistnik2011-07-111-0/+2
| | | | | | | Reported by: pointyhat Notes: svn path=/head/; revision=277564
* Update to 9.1beta2Palle Girgensohn2011-06-144-158/+159
| | | | | | | Fix proken plists wrt NLS Notes: svn path=/head/; revision=275539
* Add postgresql 9.1 beta1.Palle Girgensohn2011-06-118-166/+210
| | | | | | | | | | | | | 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-202-2/+3
| | | | | | | 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-187-28/+43
| | | | | | | | | | | | | | | | | | | | | | | | | 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 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 Notes: svn path=/head/; revision=268521
* Fix @dirrmtry since it already filter stderr and return true.Andrej Zverev2011-01-301-6/+6
| | | | | | | | | | PR: ports/153888 Submitted by: az@ Approved by: maintainer (timeout) Feature safe: yes Notes: svn path=/head/; revision=268416
* - Update to 9.0.2Martin Matuska2010-12-315-7/+68
| | | | | | | | | | - Unify ICU handling PR: ports/153245 Approved by: maintainer (timeout) Notes: svn path=/head/; revision=267208
* - Prepare for devel/icu4 deletionBaptiste Daroussin2010-12-161-12/+4
| | | | | | | | | - fix py-icu with icu4.6 - fix portsgresql*server with icu 4.6 - remove now useless icu patch from webkit Notes: svn path=/head/; revision=266446
* Chase devel/icu upgradeBaptiste Daroussin2010-12-151-3/+3
| | | | | | | Add an updating note Notes: svn path=/head/; revision=266338
* - Fix build if WITH_ICU or WITH_ICU4 defined (bsd.autotools.mk update)Daniel Gerzo2010-12-091-1/+1
| | | | | | | | Obtained from: mm Approved by: portmgr (linimon) Notes: svn path=/head/; revision=265931
* Sync to new bsd.autotools.mkAde Lovett2010-12-041-1/+1
| | | | Notes: svn path=/head/; revision=265663
* - Use dirrmtry on share/postgresql/tsearch_data for postgresql{83|84|90}-serverSunpoet Po-Chuan Hsieh2010-11-222-2/+2
| | | | | | | | | | | - Bump PORTREVISION PR: ports/151882 Submitted by: sunpoet (myself) Approved by: girgen (maintainer timeout, 20 days) Notes: svn path=/head/; revision=264939
* - 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) Notes: svn path=/head/; revision=264890
* Make postgresql90-client depend on libxml. Technically it does not depend on ↵Palle Girgensohn2010-10-261-2/+0
| | | | | | | | | | | libxml, only postgresql90-server does, but since we don't want two different pg_config setups, one for client and one for server, I'm bringing the libxml dependency on board until I can find out a better way to solve this. Notes: svn path=/head/; revision=263611
* Punt autoconf267->autoconf268Ade Lovett2010-10-161-1/+1
| | | | Notes: svn path=/head/; revision=263089
* Update all PostgreSQL ports to latest versions.Palle Girgensohn2010-10-076-24/+47
| | | | | | | | | | | 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-208-252/+319
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | 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
* 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 Notes: svn path=/head/; revision=261230
* 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-252-3/+44
| | | | | | | | | | | - 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.3.Xin LI2010-03-253-5/+7
| | | | | | | | | | PR: ports/144863 Submitted by: Alexander <alp rsu ru> Security: e050119b-3856-11df-b2b2-002170daae37 With hat: ports-security@ Notes: svn path=/head/; revision=251509
* Reintegrate the patch for ICU (unicode support).Palle Girgensohn2010-02-032-8/+11
| | | | Notes: svn path=/head/; revision=249180
* PTHREAD_[CFLAGS|LDFLAGS] are already set in CONFIGURE_ENV.Alex Dupre2010-01-041-3/+0
| | | | | | | Approved by: portmgr and maintainer timeout (1 month) Notes: svn path=/head/; revision=247147
* 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) Notes: svn path=/head/; revision=247146
* - 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