FreeBSD ports tree https://cgit-dev.freebsd.org/ports/atom?h=release%2F7.0.0 2008-02-24T03:11:57Z 2008-02-24T03:11:57Z cvs2svn cvs2svn@FreeBSD.org 2008-02-24T03:11:57Z urn:sha1:fa4a943c17e47bf910596a414fd7287983350b9b 2007-11-01T07:10:04Z Palle Girgensohn girgen@FreeBSD.org 2007-11-01T07:10:04Z urn:sha1:1577187ba7baa34a3aa9c44dafd670283dbae50b http://www.postgresql.org/developer/beta This is beta quality, don't use in production. Approved by: portmgr (erwin) 2007-10-15T15:32:19Z Palle Girgensohn girgen@FreeBSD.org 2007-10-15T15:32:19Z urn:sha1:104aa6c0488bea9251649a6bf593b0b855a435b6 Note that this is a BETA VERSION of the PostgreSQL server. Use it only for testing. 2007-09-25T22:34:32Z Ade Lovett ade@FreeBSD.org 2007-09-25T22:34:32Z urn:sha1:3e862d356dee0cce23898d9a2ff56a643ea74e1c Approved by: maintainer 2007-05-19T20:36:56Z Florent Thoumie flz@FreeBSD.org 2007-05-19T20:36:56Z urn:sha1:d4f0d0048a8755106a4b0445221a19761e746984 - Set X11BASE to ${LOCALBASE} for recent ${OSVERSION}. - Bump PORTREVISION for ports intalling files in ${X11BASE}. 2007-04-23T16:10:54Z Palle Girgensohn girgen@FreeBSD.org 2007-04-23T16:10:54Z urn:sha1:0460921154a83d30802fb47542396c669821a8c0 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 2007-01-09T16:29:35Z Palle Girgensohn girgen@FreeBSD.org 2007-01-09T16:29:35Z urn:sha1:6b11e898761ec7ced9bf9b652a24b78697eac863 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 2006-12-06T16:50:34Z Palle Girgensohn girgen@FreeBSD.org 2006-12-06T16:50:34Z urn:sha1:5b1dcdfc6fde3d24f31e5afec5e3d67d11a4e639 PostgreSQL 8.2.0 Complete release notes are available at http://www.postgresql.org/docs/current/static/release-8-2.html 2006-01-22T05:52:28Z Edwin Groothuis edwin@FreeBSD.org 2006-01-22T05:52:28Z urn:sha1:d568611c3eb334453c4a0352b61f081a623d72f1 Approved by: krion@ PR: ports/88711 (related) 2005-11-10T02:23:38Z Palle Girgensohn girgen@FreeBSD.org 2005-11-10T02:23:38Z urn:sha1:d587b3a37a4a02fadb87e491df608d71c7f86e07 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