summaryrefslogtreecommitdiff
path: root/databases/postgresql83-server/pkg-plist-server
Commit message (Collapse)AuthorAgeFilesLines
* PostgreSQL 9.2.3, 9.1.8, 9.0.12, 8.4.16 and 8.3.23 releasedPalle Girgensohn2013-02-081-0/+1
| | | | | | | | | | | | | | | 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
* The PostgreSQL Global Development Group today released security updates for allPalle Girgensohn2012-06-041-0/+1
| | | | | | | | | | | | | | | | | | | | | | | 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
* Update to 8.3.17 and 8.2.23.Chris Rees2012-02-171-0/+1
| | | | | | | | Please note that 8.2 is still deprecated, and any users are still strongly encouraged to move to 8.4 as soon as possible. Notes: svn path=/head/; revision=291569
* - Add profile support for PostgreSQL serversJason Helfman2012-01-221-2/+2
| | | | | | | | | | | | | | - 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-191-1/+1
| | | | | | | | Spotted by: decke Approved by: crees, rene (mentors,implicit) Notes: svn path=/head/; revision=289481
* Fix plist to create directory with proper ownerships so PostgreSQL databaseJason Helfman2012-01-181-0/+2
| | | | | | | | | | | 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=289424
* - Fix packaging issue (missed %%PG_USER%% in pkg-plist-server)Chris Rees2011-10-201-0/+1
| | | | | | | | | | | - 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
* The PostgreSQL Global Development Group today released minor version updatesPalle Girgensohn2011-10-181-2/+3
| | | | | | | | | | | | | | | | 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
* Update PostgreSQL to 9.0.4, 8.4.8, 8.3.15 and 8.2.21.Palle Girgensohn2011-04-181-0/+3
| | | | | | | | | | | | | | | | | | | | | | | | | 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
* - Use dirrmtry on share/postgresql/tsearch_data for postgresql{83|84|90}-serverSunpoet Po-Chuan Hsieh2010-11-221-1/+1
| | | | | | | | | | | - Bump PORTREVISION PR: ports/151882 Submitted by: sunpoet (myself) Approved by: girgen (maintainer timeout, 20 days) Notes: svn path=/head/; revision=264939
* Update all PostgreSQL ports to latest versions.Palle Girgensohn2010-10-071-0/+2
| | | | | | | | | | | 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
* Update all PostgreSQL ports to latest version.Palle Girgensohn2010-05-201-1/+6
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | 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 Notes: svn path=/head/; revision=254659
* Security update to 8.3.9.Xin LI2009-12-201-0/+1
| | | | | | | | | Security: vid e7bc5600-eaa0-11de-bd9c-00215c6a37bb Security: CVE-2009-4034 CVE-2009-4136 With hat: ports-security Notes: svn path=/head/; revision=246275
* Update PostgreSQL to latest versions.Palle Girgensohn2009-02-101-0/+1
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | 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-071-0/+1
| | | | Notes: svn path=/head/; revision=222511
* Update PostgreSQL to latest versions.Palle Girgensohn2008-11-071-0/+1
| | | | | | | | | | | | | | | | | | 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-0/+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
* Update to 8.3.1Palle Girgensohn2008-03-181-0/+1
| | | | | | | | Release notes: http://developer.postgresql.org/pgdocs/postgres/release-8-3-1.html Notes: svn path=/head/; revision=209325
* Today the PostgreSQL Global Development Group releases thePalle Girgensohn2008-02-041-0/+1
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | 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-221-583/+583
| | | | | | | | | | | | | | | | | [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
* Update all PostgreSQL ports to latest versions.Palle Girgensohn2008-01-071-10/+5
| | | | | | | | | | 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
* Update to PostgreSQL 8.3 beta2.Palle Girgensohn2007-11-011-0/+17
| | | | | | | | | | | 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-151-1/+10
| | | | | | | | Note that this is a BETA VERSION of the PostgreSQL server. Use it only for testing. Notes: svn path=/head/; revision=201504
* Fix plistAde Lovett2007-09-251-0/+1
| | | | | | | Approved by: maintainer Notes: svn path=/head/; revision=200113
* - Welcome X.org 7.2 \o/.Florent Thoumie2007-05-191-14/+0
| | | | | | | | - 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-231-0/+6
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | 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
* Update postgresql to 8.2.1, 8.1.6, 8.0.10, 7.4.15 and 7.3.17.Palle Girgensohn2007-01-091-0/+71
| | | | | | | | | | | | | | | | | | | | | 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
* Welcome new release of the world's most advanced open source database:Palle Girgensohn2006-12-061-466/+473
| | | | | | | | | | 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
* eplace ugly "@unexec rmdir %D... 2>/dev/null || true" with @dirrmtryEdwin Groothuis2006-01-221-20/+20
| | | | | | | | Approved by: krion@ PR: ports/88711 (related) Notes: svn path=/head/; revision=154134
* Welcome to PostgreSQL 8.1.Palle Girgensohn2005-11-101-1/+4
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | The new release includes performance improvements and advanced SQL features which will support bigger data warehouses, higher-volume transaction processing, and more complex distributed enterprise software. Major new features in this release include: Roles: PostgreSQL now supports database roles, which simplify the management of large numbers of users with complex overlapping database rights. IN/OUT Parameters: PostgreSQL functions now support IN, OUT and INOUT parameters, which substantially improves support of complex business logic for J2EE and .NET applications. Two-Phase Commit (2PC): Long in demand for WAN applications and heterogeneous data centers using PostgreSQL, this feature allows ACID-compliant transactions across widely separated servers. Some Performance Enhancements found in this release include: Improved Multiprocessor (SMP) Performance: The buffer manager for 8.1 has been enhanced to scale almost linearly with the number of processors, leading to significant performance gains on 8-way, 16-way, dual-core, and multi-core CPU servers. Bitmap Scan: Indexes will be dynamically converted to bitmaps in memory when appropriate, giving up to twenty times faster index performance on complex queries against very large tables. Table Partitioning: The query planner is now able to avoid scanning whole sections of a large table using a technique known as Constraint Exclusion. Shared Row Locking: PostgreSQL's "better than row-level locking" now supports even higher levels of concurrency through the addition of shared row locks for foreign keys. For a more complete listing of changes in this release, please see the Release Notes visible at: http://www.postgresql.org/docs/current/static/release.html#RELEASE-8-1 Notes: svn path=/head/; revision=147772
* Fixing problems with the recent security patch: When bison was notPalle Girgensohn2005-05-111-0/+1
| | | | | | | | | | | | | | | | | | | | installed, the patched gram.y file would not be used and the security patch would be a no-op. Also, I've had reports of compilation errors related to bison. Since checking for the correct version of bison is hard and error prone, I'm doing what the postgresql distribution does - patching the yacc:ed .c file to get rid of the building dependency. Bumping portrevision of -server. Pointy hat to: me Noticed by: Mike Harding and others Security: http://www.vuxml.org/freebsd/6b4b0b3f-8127-11d9-a9e7-0001020eed82.html Approved by: seanc (implicit) Notes: svn path=/head/; revision=135025
* In order to address a potential security hole recently identified withPalle Girgensohn2005-02-031-1/+1
| | | | | | | | | | | | | | | | | | | | | | the "LOAD" option, the PostgreSQL Global Development Group is announcing the release of new versions of PostgreSQL. Update to 7.3.9, 7.4.7 & 8.0.1. Take the opportunity to reset PORTREVISION of slave ports. Back out name change of startup script. The new script uses rc.subr(8), and as such also uses rcorder(8). But, rcorder does not exist in FreeBSD 4.x. Hence rename the script it back to the top of the directory list. [1] The periodic script should of course be executable. [2] [1] Noted by Niels Chr. Bank-Pedersen <ncbp at bank-pedersen dot dk> [2] Noted by Fritz Heinrichmeyer <fritz.heinrichmeyer at fernuni-hagen dot de> Notes: svn path=/head/; revision=127966
* Say hello to postgresql-8.0. Some of the highlights of the new versionPalle Girgensohn2005-01-311-347/+603
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | 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-0/+411
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
generated by cgit v1.3 (git 2.53.0) at 2026-08-04 10:21:34 +0000