aboutsummaryrefslogtreecommitdiff
path: root/databases/postgresql84-server
Commit message (Collapse)AuthorAgeFilesLines
* - convert from USE_GMAKE to USES=gmakeJason Helfman2013-07-071-4/+2
| | | | | | | | | - trim historical headers With hat: pgsql@ Notes: svn path=/head/; revision=322415
* databases/postgresql-server ports: Unbreak NLSChris Rees2013-04-281-2/+4
| | | | | | | Submitted by: bapt Notes: svn path=/head/; revision=316740
* databases/postgresql{84,91,92}-server: Readd bsd.port.pre.mk; it is required ↵Chris Rees2013-04-281-3/+4
| | | | | | | for checking existence of files in FILESDIR Notes: svn path=/head/; revision=316726
* Convert USE_GETTEXT -> USES=gettextBaptiste Daroussin2013-04-261-5/+3
| | | | | | | | | | While here: - Trim headers - Remove some useless pre.mk/post.mk - Convert to optionsng Notes: svn path=/head/; revision=316620
* Fix pkg-list for postgresql84-serverPalle Girgensohn2013-04-052-1/+4
| | | | | | | Approved by: portmgr (miwi) Notes: svn path=/head/; revision=315734
* The PostgreSQL Global Development Group has released a securityPalle Girgensohn2013-04-042-3/+3
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | update to all current versions of the PostgreSQL database system, including versions 9.2.4, 9.1.9, 9.0.13, and 8.4.17. This update fixes a high-exposure security vulnerability in versions 9.0 and later. All users of the affected versions are strongly urged to apply the update *immediately*. A major security issue (for versions 9.x only) fixed in this release, [CVE-2013-1899](http://cve.mitre.org/cgi-bin/cvename.cgi?name=CVE-2013-1899), makes it possible for a connection request containing a database name that begins with "-" to be crafted that can damage or destroy files within a server's data directory. Anyone with access to the port the PostgreSQL server listens on can initiate this request. This issue was discovered by Mitsumasa Kondo and Kyotaro Horiguchi of NTT Open Source Software Center. Two lesser security fixes are also included in this release: [CVE-2013-1900](http://cve.mitre.org/cgi-bin/cvename.cgi?name=CVE-2013-1900), wherein random numbers generated by contrib/pgcrypto functions may be easy for another database user to guess (all versions), and [CVE-2013-1901](http://cve.mitre.org/cgi-bin/cvename.cgi?name=CVE-2013-1901), which mistakenly allows an unprivileged user to run commands that could interfere with in-progress backups (for versions 9.x only). Approved by: portmgr (bdrewery) URL: http://www.postgresql.org/about/news/1456/ Security: http://cve.mitre.org/cgi-bin/cvename.cgi?name=CVE-2013-1899 Security: http://cve.mitre.org/cgi-bin/cvename.cgi?name=CVE-2013-1900 Security: http://cve.mitre.org/cgi-bin/cvename.cgi?name=CVE-2013-1901 Notes: svn path=/head/; revision=315718
* PostgreSQL 9.2.3, 9.1.8, 9.0.12, 8.4.16 and 8.3.23 releasedPalle Girgensohn2013-02-083-4/+5
| | | | | | | | | | | | | | | This update fixes a denial-of-service (DOS) vulnerability. All users should update their PostgreSQL installations as soon as possible. The security issue fixed in this release, CVE-2013-0255, allows a previously authenticated user to crash the server by calling an internal function with invalid arguments. URL: http://www.postgresql.org/about/news/1446/ Security: http://cve.mitre.org/cgi-bin/cvename.cgi?name=CVE-2013-0255 Notes: svn path=/head/; revision=311915
* Remove versioned PKGNAMESUFFIX from -plpython ports; the versions differ anywayChris Rees2013-01-221-1/+1
| | | | | | | Submitted by: sunpoet Notes: svn path=/head/; revision=310833
* Fix package build for -plpythonChris Rees2013-01-221-1/+1
| | | | | | | | | Although the plpython work was done by rm, this problem was actually my fault Noticed by: sunpoet Notes: svn path=/head/; revision=310832
* - remove broken configurable non-default user/group for postgresql-serverJason Helfman2012-12-271-15/+4
| | | | | | | | | - while here fix formatting of new header With hat: pgsql@ Notes: svn path=/head/; revision=309555
* - unbreak ICU buildJason Helfman2012-12-241-1/+1
| | | | | | | | | PR: 174603 (based on) Submitted by: basarevych@gmail.com With hat: pgsql@ Notes: svn path=/head/; revision=309467
* Chase ICU update properly and bump PORTREVISIONPalle Girgensohn2012-12-191-2/+2
| | | | Notes: svn path=/head/; revision=309247
* Chase ICU update to 50Palle Girgensohn2012-12-191-3/+7
| | | | Notes: svn path=/head/; revision=309246
* The PostgreSQL Global Development Group has released an update to all currentPalle Girgensohn2012-12-062-4/+4
| | | | | | | | | | | | | | | | versions of the PostgreSQL database system, including versions 9.2.2, 9.1.7, 9.0.11, 8.4.15, and 8.3.22. Users of PostgreSQL Hot Standby replication should update at the next possible opportunity. Other users should update at their next maintenance window. Deprecate the 8.3.22 version, since it is near end-of-life. URL: http://www.postgresql.org/about/news/1430/ Feature safe: yes Notes: svn path=/head/; revision=308391
* - adopt optionsNGJason Helfman2012-10-161-49/+49
| | | | | | | | with hat pgsql@ Feature safe: yes Notes: svn path=/head/; revision=305983
* Update PostgreSQL to 9.2.1, 9.1.6, 9.0.10, 8.4.14 and 8.3.21 respectively.Palle Girgensohn2012-09-242-3/+3
| | | | | | | | | | This update fixes critical issues for major versions 9.1 and 9.2, and users running those versions should apply it as soon as possible. URL: http://www.postgresql.org/about/news/1416/ Notes: svn path=/head/; revision=304804
* Use pre-build instead of pre-everything for backupwarning-- stop making peopleChris Rees2012-08-191-5/+3
| | | | | | | | | | | | wait before fetching etc Suggested by: ohauer Discussed with: girgen While here, fix package for postgresql92-server Notes: svn path=/head/; revision=302762
* The PostgreSQL Global Development Group today released security updates for ↵Jason Helfman2012-08-174-3/+11
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | all active branches of the PostgreSQL database system, including versions 9.1.5, 9.0.9, 8.4.13 and 8.3.20. This update patches security holes associated with libxml2 and libxslt, similar to those affecting other open source projects. All users are urged to update their installations at the first available opportunity. This security release fixes a vulnerability in the built-in XML functionality, and a vulnerability in the XSLT functionality supplied by the optional XML2 extension. Both vulnerabilities allow reading of arbitrary files by any authenticated database user, and the XSLT vulnerability allows writing files as well. The fixes cause limited backwards compatibility issues. These issues correspond to the following two vulnerabilities: CVE-2012-3488: PostgreSQL insecure use of libxslt CVE-2012-3489: PostgreSQL insecure use of libxml2 This release also contains several fixes to version 9.1, and a smaller number of fixes to older versions, including: Updates and corrections to time zone data Multiple documentation updates and corrections Add limit on max_wal_senders Fix dependencies generated during ALTER TABLE ADD CONSTRAINT USING INDEX. Correct behavior of unicode conversions for PL/Python Fix WITH attached to a nested set operation (UNION/INTERSECT/EXCEPT). Fix syslogger so that log_truncate_on_rotation works in the first rotation. Only allow autovacuum to be auto-canceled by a directly blocked process. Improve fsync request queue operation Prevent corner-case core dump in rfree(). Fix Walsender so that it responds correctly to timeouts and deadlocks Several PL/Perl fixes for encoding-related issues Make selectivity operators use the correct collation Prevent unsuitable slaves from being selected for synchronous replication Make REASSIGN OWNED work on extensions as well Fix race condition with ENUM comparisons Make NOTIFY cope with out-of-disk-space Fix memory leak in ARRAY subselect queries Reduce data loss at replication failover Fix behavior of subtransactions with Hot Standby Notes: svn path=/head/; revision=302694
* The PostgreSQL Global Development Group today released security updates for allPalle Girgensohn2012-06-044-16/+5
| | | | | | | | | | | | | | | | | | | | | | | 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-302-0/+13
| | | | | | | | | http://www.postgresql.org/about/news/1397/ With hat: pgsql Notes: svn path=/head/; revision=297840
* Various tidiness patches:Chris Rees2012-03-052-16/+16
| | | | | | | | | | | | | | | - Compact -plperl ports - Portlint for 90-plperl - Update version numbers in pkg-install-server - s/spaces/tabs/ - Use ${} instead of $() - s/YES/yes/ - Tidy IGNORE values Submitted by: sunpoet Notes: svn path=/head/; revision=292772
* Over to new team, pgsql@FreeBSD.orgChris Rees2012-03-041-1/+1
| | | | Notes: svn path=/head/; revision=292678
* The PostgreSQL Global Development Group today released security updates for allPalle Girgensohn2012-02-273-15/+3
| | | | | | | | | | | | | | | | | | | 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
* Look for the correct ICU patchfileChris Rees2012-02-161-1/+1
| | | | | | | Submitted by: Jaime Bozza <jbozza@mindsites.com> Notes: svn path=/head/; revision=291529
* Use DISTVERSION instead of PORTVERSION to generate UNIQUENAME; optionsChris Rees2012-01-301-1/+1
| | | | | | | | | | | don't work correctly otherwise. http://lists.freebsd.org/pipermail/freebsd-ports/2012-January/072756.html Pointyhat: crees Notes: svn path=/head/; revision=290126
* - To preserve my sanity, slave 82 and 83 to 84, and 90 to 91, resulting inChris Rees2012-01-251-47/+66
| | | | | | | | | | | three fewer Makefiles to maintain - Switch patch master site - Various cleanups Notes: svn path=/head/; revision=289804
* - 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) Notes: svn path=/head/; revision=289587
* 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-054-7/+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-2/+13
| | | | | | | | | | | | | | | | | | | | | | 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
* Actually add the pgsql users on installChris Rees2011-11-021-1/+7
| | | | | | | | PR: ports/162239 Approved by: portmgr (pav) Notes: svn path=/head/; revision=284932
* Make SSL available as an optionMartin Matuska2011-10-211-12/+12
| | | | | | | | PR: ports/161330 Approved by: maintainer (timeout) Notes: svn path=/head/; revision=284076
* - 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-117/+68
| | | | | | | | | | | | | | | | 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
* - 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
* PostgreSQL: unbreak 'make describe'Eygene Ryabinkin2011-09-251-0/+2
| | | | | | | | | | | It was a really bad idea to include bsd.port.pre.mk inside a conditional expression. Detected by: portsnap buildbox Pointyhat to: rea Notes: svn path=/head/; revision=282382
* PostgreSQL: unbreak GSSAPI supportEygene Ryabinkin2011-09-251-4/+8
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | 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
* - Hack to allow building of -client port. The OPTIONS handling is still broken.Pav Lucistnik2011-09-011-1/+1
| | | | | | | Submitted by: Ruslan Mahmatkhanov <cvs-src@yandex.ru> Notes: svn path=/head/; revision=281006
* Revert previous commit -- appears to cause rc problems as I missed some subsChris Rees2011-08-153-3/+49
| | | | | | | | | | | 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) Notes: svn path=/head/; revision=279751
* - 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) Notes: svn path=/head/; revision=279659
* Use USERS and GROUPSChris Rees2011-08-123-49/+3
| | | | | | | | | PR: ports/157666 Submitted by: me Approved by: maintainer timeout (girgen, 8 weeks) Notes: svn path=/head/; revision=279538
* - update ICU to 4.8Baptiste Daroussin2011-07-102-3/+3
| | | | | | | | | - chase library bump - add an entry in UPDATING for instructions - remove old conflict lines Notes: svn path=/head/; revision=277485
* - Mark BROKEN on FreeBSD 9.X: does not linkPav Lucistnik2011-05-171-1/+4
| | | | | | | | | | | libpq/auth.o: In function `pg_GSS_error': auth.c:(.text+0x6e): undefined reference to `gss_display_status' [..] Reported by: pointyhat Notes: svn path=/head/; revision=274243