FreeBSD ports tree https://cgit-dev.freebsd.org/ports/atom?h=2016Q3 2011-04-18T23:34:27Z 2011-04-18T23:34:27Z Palle Girgensohn girgen@FreeBSD.org 2011-04-18T23:34:27Z urn:sha1:73c856222edb8c22377bf9a1c81a724065e3a31c 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 2010-05-20T15:43:39Z Palle Girgensohn girgen@FreeBSD.org 2010-05-20T15:43:39Z urn:sha1:daea94a3e118c8b89d6818a084c495eaf998b797 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 2008-11-07T09:49:49Z Palle Girgensohn girgen@FreeBSD.org 2008-11-07T09:49:49Z urn:sha1:978e3de48fd8491061803765cdc592ab234edd46 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 2008-06-12T23:46:07Z Palle Girgensohn girgen@FreeBSD.org 2008-06-12T23:46:07Z urn:sha1:89025407ac8aa413884e5a33322957c188ca0a40 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 2005-01-31T00:36:16Z Palle Girgensohn girgen@FreeBSD.org 2005-01-31T00:36:16Z urn:sha1:dde08c696b7fdee8c17225a61fb9959886ae5d6d 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) 2004-11-23T19:15:12Z Ade Lovett ade@FreeBSD.org 2004-11-23T19:15:12Z urn:sha1:03e63e3bdbb7e407689c7729c740d54a32bfd7a3 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 2003-01-04T01:10:15Z Sean Chittenden seanc@FreeBSD.org 2003-01-04T01:10:15Z urn:sha1:62e1bb44328db7be12796334d8be63e24d48df05 security, and feature additions. Reduce diffs between postgresql-devel port. Re-initdb required when upgrading from previous release. See release notes for details. Schemas added are system catalogs updated. ::braces for impact:: http://developer.postgresql.org/docs/postgres/release.html#RELEASE-7-3-1 PR: ports/46701 Submitted by: girgen@pingpong.net 2002-11-06T01:41:53Z Nick Sayer nsayer@FreeBSD.org 2002-11-06T01:41:53Z urn:sha1:b77926499ee26e9c1fed44d15a969dd9081548eb PR: ports/44983 Submitted by: girgen@pingpong.net 2002-08-26T08:12:40Z Trevor Johnson trevor@FreeBSD.org 2002-08-26T08:12:40Z urn:sha1:c80f4eaad8cb1ddb2c90382e4c818d06c3591d53 documentation--it will be in a separate port. PR: 42009 Submitted by: Palle Girgensohn (maintainer) 2002-04-11T04:58:11Z Ying-Chieh Liao ijliao@FreeBSD.org 2002-04-11T04:58:11Z urn:sha1:b345761190ed0484cf7adb45e7e11d985229c85c PR: 36975 Submitted by: maintainer