notbugAs an Amazon Associate I earn from qualifying purchases.
Want a good read? Try FreeBSD Mastery: Jails (IT Mastery Book 15)
Want a good monitor light? See my photosAll times are UTC
Ukraine
non port: databases/postgresql11-contrib/Makefile

Number of commits found: 15

Sunday, 31 Dec 2023
00:06 Muhammad Moinur Rahman (bofh) search for other commits by this committer
databases/postgresql11: Sunset
commit hash: bbd8259de39f261bcd44716957c77536b3648bd6 commit hash: bbd8259de39f261bcd44716957c77536b3648bd6 commit hash: bbd8259de39f261bcd44716957c77536b3648bd6 commit hash: bbd8259de39f261bcd44716957c77536b3648bd6 bbd8259
Saturday, 10 Sep 2022
17:41 Stefan Eßer (se) search for other commits by this committer Author: Tobias Kortkamp
Fix WWW in parent/child ports

Many of the WWW are overwritten later which means the wrong value
is used. This did not happen before where the children were either
 a) just using the pkg-descr from the parents
 b) or had their own separate pkg-descr with custom WWW

Use WWW?= in parents when the child's WWW is different.

Children that use the same WWW as the parent can just inherit it,
i.e., the child WWW can be removed.

Approved by:	portmgr (implicit)
commit hash: e79fe1aabc5b83364240652d62b99198a9ccfb32 commit hash: e79fe1aabc5b83364240652d62b99198a9ccfb32 commit hash: e79fe1aabc5b83364240652d62b99198a9ccfb32 commit hash: e79fe1aabc5b83364240652d62b99198a9ccfb32 e79fe1a
Wednesday, 7 Sep 2022
21:10 Stefan Eßer (se) search for other commits by this committer
Add WWW entries to port Makefiles

It has been common practice to have one or more URLs at the end of the
ports' pkg-descr files, one per line and prefixed with "WWW:". These
URLs should point at a project website or other relevant resources.

Access to these URLs required processing of the pkg-descr files, and
they have often become stale over time. If more than one such URL was
present in a pkg-descr file, only the first one was tarnsfered into
the port INDEX, but for many ports only the last line did contain the
port specific URL to further information.

There have been several proposals to make a project URL available as
a macro in the ports' Makefiles, over time.

This commit implements such a proposal and moves one of the WWW: entries
of each pkg-descr file into the respective port's Makefile. A heuristic
attempts to identify the most relevant URL in case there is more than
one WWW: entry in some pkg-descr file. URLs that are not moved into the
Makefile are prefixed with "See also:" instead of "WWW:" in the pkg-descr
files in order to preserve them.

There are 1256 ports that had no WWW: entries in pkg-descr files. These
ports will not be touched in this commit.

The portlint port has been adjusted to expect a WWW entry in each port
Makefile, and to flag any remaining "WWW:" lines in pkg-descr files as
deprecated.

Approved by:		portmgr (tcberner)
commit hash: b7f05445c00f2625aa19b4154ebcbce5ed2daa52 commit hash: b7f05445c00f2625aa19b4154ebcbce5ed2daa52 commit hash: b7f05445c00f2625aa19b4154ebcbce5ed2daa52 commit hash: b7f05445c00f2625aa19b4154ebcbce5ed2daa52 b7f0544
Wednesday, 20 Jul 2022
14:21 Tobias C. Berner (tcberner) search for other commits by this committer
databases: remove 'Created by' lines

A big Thank You to the original contributors of these ports:

  *  "Choe, Cheng-Dae" whitekid
  *  "Mahdi Mokhtari <mokhi64@gmail.com>"
  *  "Meikel Brandmeyer" <ocaml-sqlite3-port@kotka.de>
  *  <hvo.pm@xs4all.nl>
  *  <jsmith@resonatingmedia.com>
  *  <ports@c0decafe.net>
  *  Aaron Dalton <aaron@FreeBSD.org>
  *  Adam Weinberger <adamw@FreeBSD.org>
  *  Ade Lovett <ade@FreeBSD.org>
  *  Akinori MUSHA aka knu <knu@idaemons.org>
  *  Alan Snelson <Alan@Wave2.org>
  *  Aldis Berjoza <graudeejs@gmail.com>
  *  Alessando Sagratini <ale_sagra@hotmail.com>
  *  Alex Dupre <ale@FreeBSD.org>
  *  Alex Samorukov <samm@freebsd.org>
  *  Alexander Logvinov <ports@logvinov,com>
  *  Alexander Logvinov <ports@logvinov.com>
  *  Alexander Nedotsukov <bland@FreeBSD.org>
  *  Alexander Novitsky
  *  Alexander Zhuravlev <zaa@zaa.pp.ru>
  *  Alexey Degtyarev <alexey@renatasystems.org>
  *  Alexey Dokuchaev <danfe@FreeBSD.org>
  *  Anders Nordby <anders@fix.no>
  *  Andrei Antoukh <niwi@niwi.be>
  *  Andrew McNaughton <andrew@scoop.co.nz>
  *  Andrew Pantyukhin <infofarmer@FreeBSD.org>
  *  Andrey Kostenko <andrey@kostenko.name>
  *  Andrey Simonenko
  *  Andrey Zakhvatov
  *  Anes Mukhametov <anes@anes.su>
  *  Anton Berezin <tobez@FreeBSD.org>
  *  Anton Berezin <tobez@tobez.org>
  *  Antonio Carlos Venancio Junior (<antonio@inf.ufsc.br>)
  *  Antonio Carlos Venancio Junior (<antonio@php.net>)
  *  Autrijus Tang <autrijus@autrijus.org>
  *  Babak Farrokhi <farrokhi@FreeBSD.org>
  *  Bartek Rutkowski <r@robakdesign.com>
  *  Bernard Spil <brnrd@FreeBSD.org>
  *  Brent J. Nordquist <bjn@visi.com>
  *  Cezary Morga <cm@therek.net>
  *  Cheng-Lung Sung <clsung@FreeBSD.org>
  *  Choe, Cheng-Dae
  *  Chris D. Faulhaber <jedgar@FreeBSD.org>
  *  Chris Larsen <darth@vader.dk>
  *  Damian Gerow <dgerow@afflictions.org>
  *  Daniel O'Connor
  *  Daniel Wijnands <daniel@itxl.nl>
  *  Dave Green <dg@fastmail.co.uk>
  *  David Thiel <lx@FreeBSD.org>
  *  Davíð Steinn Geirsson <david@isnic.is>
  *  Denis Generalov <gd.workbox@gmail.com>
  *  Denis Generalov <gd@rambler-co.ru>
  *  Denis Shaposhnikov <dsh@bamus.cz>
  *  Dermot Tynan <dtynan@kalopa.com>
  *  Dmitry Liakh <dliakh@ukr.net>
  *  Dmitry Sivachenko <demon@FreeBSD.org>
  *  Dmitry Sivachenko <dima@Chg.RU>
  *  Dmitry Sivachenko <mitya@yandex-team.ru>
  *  Domas Mituzas <midom@dammit.lt>
  *  Dominic Mitchell
  *  Don Owens <don@regexguy.com>
  *  Dryice Dong Liu <dryice@dryice.name>
  *  Edwin Groothuis (edwin@mavetju.org)
  *  Eric Freeman <freebsdports@chillibear.com>
  *  Espen Tagestad <espen@tagestad.no>
  *  Espen Volden aka voldern <voldern@hoeggen.net>
  *  Evan Sarmiento <bsdports@wayfair.com>
  *  Fernan Aguero <fernan@iib.unsam.edu.ar>
  *  Frank Wall <fw@moov.de>
  *  Ganbold Tsagaankhuu <ganbold@FreeBSD.org>
  *  Gary Palmer <gpalmer@FreeBSD.org>
  *  Gea-Suan Lin <gslin@gslin.org>
  *  Geraud CONTINSOUZAS <geraud@gcu.info>
  *  Gerrit Beine <tux@pinguru.net>
  *  Greg Larkin <glarkin@FreeBSD.org>
  *  Grzegorz Blach <gblach@FreeBSD.org>
  *  Hansjoerg Pehofer <hansjoerg.pehofer@uibk.ac.at>
  *  Henk van Oers <hvo.pm@xs4all.nl>
  *  Henrik Hodne <henrik@hodne.io>
  *  Hiroyuki Hanai <hanai@FreeBSD.org>
  *  Horia Racoviceanu <horia@racoviceanu.com>
  *  Hye-Shik Chang
  *  Hye-Shik Chang <perky@python.or.kr>
  *  Ilia Chipitsine <ilia@jane.cgu.chel.su>
  *  Ivan Voras <ivoras@FreeBSD.org>
  *  J.F. Dockes
  *  Jaap Boender <jaapb@kerguelen.org>
  *  Jake Smith <jake@xz.cx>
  *  James FitzGibbon <jfitz@FreeBSD.org>
  *  Janos Mohacsi <janos.mohacsi@bsd.hu>
  *  Janos.Mohacsi@bsd.hu
  *  Jason Helfman <jgh@FreeBSD.org>
  *  Jens Rehsack <rehsack@liwing.de>
  *  Jeremy Chadwick <koitsu@FreeBSD.org>
  *  Jev Björsell <ports@ecadlabs.com>
  *  Jim Ohlstein <jim@ohlste.in>
  *  Jin-Shan Tseng <tjs@cdpa.nsysu.edu.tw>
  *  Joe Horn <joehorn@gmail.com>
  *  Joe Marcus Clarke <marcus@FreeBSD.org>
  *  Johannes Meixner <johannes@perceivon.net>
  *  John Chen <johnpupu@gmail.com>
  *  John Marino <marino@FreeBSD.org>
  *  John Merryweather Cooper
  *  John Merryweather Cooper et al
  *  Jon Nistor <nistor@snickers.org>
  *  Jonathan Weiss (<jw@innerewut.de>)
  *  Jose Jachuf <jjachuf@gmail.com>
  *  Joshua D. Abraham <jabra@ccs.neu.edu>
  *  Jov <amutu@amutu.com>
  *  Jov amutu@amutu.com
  *  Jui-Nan Lin <jnlin@freebsd.cs.nctu.edu.tw>
  *  Julien Laffaye <kimelto@gmail.com>
  *  Jyun-Yan You <jyyou@cs.nctu.edu.tw>
  *  Keith Gaughan <k@sterechro.me>
  *  Kevin Bowling <kbowling@freebsd.org>
  *  Kimo <kimor79@yahoo.com>
  *  Kimura Fuyuki <fuyuki@nigredo.org>
  *  Koop Mast <kwm@FreeBSD.org>
  *  Lars Balker Rasmussen <lbr@FreeBSD.org
  *  Lars Balker Rasmussen <lbr@FreeBSD.org>
  *  Lars Eggert <larse@isi.edu>
  *  Lars Thegler <lars@thegler.dk>
  *  Lars Thegler <lth@FreeBSD.org>
  *  Li-Wen Hsu <lwhsu@FreeBSD.org>
  *  Loïc BARTOLETTI
  *  Loïc BARTOLETTI <lbartoletti@FreeBSD.org>
  *  Lubomir Marinov <lubomir_m@abv.bg>
  *  Mahdi Mokhtari <mokhi64@gmail.com>
  *  Mahlon E. Smith <mahlon@martini.nu>
  *  Marc G. Fournier <scrappy@FreeBSD.org>
  *  Mark Felder <feld@FreeBSD.org>
  *  Markus Brueffer <markus@FreeBSD.org>
  *  Martin Matuska <martin@matuska.org>
  *  Martin Matuska <mm@FreeBSD.org>
  *  Martin Wilke <miwi@FreeBSD.org>
  *  Mathieu Arnold <m@absolight.net>
  *  Matthew Seaman
  *  Matthias Andree <mandree@FreeBSD.org>
  *  Matthias Fechner <mfechner@FreeBSD.org>
  *  Matthias Petermann <matthias@petermann-it.de>
  *  Max Khon
  *  Max Khon <fjoe@FreeBSD.org>
  *  Michael Johnson <ahze@FreeBSD.org>
  *  Michael Johnson <ahze@ahze.net>
  *  Michael Winking <mwfp@foldl.net>
  *  Mikael URANKAR and Loïc BARTOLETTI
  *  Mike Carlson (carlson39@llnl.gov)
  *  Mikhail T. <michael@fun-box.ru>
  *  Mikhail Teterin
  *  Mikhail Teterin <mi@aldan.algebra.com>
  *  Mikolaj Golub <trociny@FreeBSD.org>
  *  Mirko Zinn <mail@derzinn.de>
  *  Mohammad S. Babaei <info@babaei.net>
  *  Muhammad Moinur Rahman <bofh@FreeBSD.org>
  *  Nick Hibma <n_hibma@freebsd.org>
  *  Nick Hilliard <nick@foobar.org>
  *  Nick Sayer <nsayer@FreeBSD.org>
  *  Nicola Vitale <nivit@FreeBSD.org>
  *  Nicolas Embriz <nbari@tequila.io>
  *  Nicolas de Bari Embriz <nbari@dalmp.com>
  *  Oleg Sharoiko <os@rsu.ru>
  *  Olexander Melnyk <olexander.v.melnyk@gmail.com>
  *  Oliver Eikemeier <eikemeier@fillmore-labs.com>
  *  Olivier Duchateau <duchateau.olivier@gmail.com>
  *  Palle Girgensohn <girgen@FreeBSD.org>
  *  Palle Girgensohn <girgen@partitur.se>
  *  Palle Girgensohn <girgen@pingpong.net>
  *  Parv <parv@pair.org>
  *  Pete Fritchman <petef@databits.net>
  *  Peter Avalos <pavalos@theshell.com>
  *  Philip M. Gollucci
  *  Philip M. Gollucci <philip@p6m7g8.com>
  *  Philip Stoev <philip.stoev@galeracluster.com>
  *  Pierre-Emmanuel Andre <pea@raveland.org>
  *  Pietro Cerutti <gahr@FreeBSD.org>
  *  Piotr Kubaj <pkubaj@anongoth.pl>
  *  Po-Chuan Hsieh <sunpoet@FreeBSD.org>
  *  Qing Feng <qingfeng@douban.com>
  *  Quinton Dolan <q@onthenet.com.au>
  *  Radim Kolar
  *  Rainer Hurling <rhurlin@gwdg.de>
  *  Rick Miller
  *  Robert Kruus <rob.kruus@gmail.com>
  *  Rod Taylor <ports@rbt.ca>
  *  Roland van Laar <roland@micite.net>
  *  Rong-En Fan <rafan@FreeBSD.org>
  *  Roy Boerner
  *  Rozhuk Ivan <rozhuk.im@gmail.com>
  *  Rusty Nejdl
  *  Ryan Steinmetz <rpsfa@rit.edu>
  *  Ryan Steinmetz <zi@FreeBSD.org>
  *  Ryan T. Dean <rtdean@cytherianage.net>
  *  Sam Lawrance <boris@brooknet.com.au>
  *  Scott McWhirter <scott@surreytech.co.uk>
  *  Seamus Venasse <svenasse@polaris.ca>
  *  Sean Chittenden <seanc@FreeBSD.org>
  *  Sergei Kolobov <sergei@kolobov.com>
  *  Sergei Vyshenski <svysh.fbsd@gmail.com>
  *  Sergey A. Osokin <osa@FreeBSD.org.ru>
  *  Sergey A. Osokin <osa@FreeBSD.org>
  *  Sergey Matveychuk <sem@FreeBSD.org>
  *  Sergey Skvortsov <skv@FreeBSD.org>
  *  Sergey Skvortsov <skv@protey.ru>
  *  Sevan Janiyan <venture37@geeklan.co.uk>
  *  Sheldon Hearn <sheldonh@FreeBSD.org>
  *  Stanislav Svirid <count@211.ru>
  *  Stefan Schmidt <stefan.schmidt@stadtbuch.de>
  *  Steve Wills <swills@FreeBSD.org>
  *  Steve Wills <swills@freebsd.org>
  *  Steven Kreuzer <skreuzer@FreeBSD.org>
  *  Sunpoet Po-Chuan Hsieh <sunpoet@FreeBSD.org>
  *  Sunpoet Po-Chuan Hsieh <sunpoet@sunpoet.net>
  *  T. William Wells <bill@twwells.com>
  *  TAKATSU Tomonari <tota@FreeBSD.org>
  *  Thierry Thomas (<thierry@pompo.net>)
  *  Thomas Gellekum <tg@FreeBSD.org>
  *  Timur I. Bakeyev <bat@cpan.org>
  *  Tom Judge <tj@FreeBSD.org>
  *  Torsten Zuehlsdorff <ports@toco-domains.de>
  *  Torsten Zuhlsdorff <ports@toco-domains.de>
  *  Toshiya Saitoh (<toshiya@saitoh.nu>)
  *  Tsung-Han Yeh <snowfly@yuntech.edu.tw>
  *  Vasil Dimov <vd@FreeBSD.org>
  *  Veniamin Gvozdikov <vg@FreeBSD.org>
  *  Vladimir Timofeev <vovkasm@gmail.com>
  *  Wen Heping
  *  Wen Heping <wen@FreeBSD.org>
  *  Wen Heping <wenheping@gmail.com>
  *  Wen heping <wenheping@gmail.com>
  *  William Grzybowski <wg@FreeBSD.org>
  *  Xin Li <delphij@FreeBSD.org>
  *  Yarema <yds@CoolRat.org>
  *  Yarema <yds@Necessitu.de>
  *  Yen-Ming Lee <leeym@FreeBSD.org>
  *  Ying-Chieh Liao <ijliao@FreeBSD.org>
  *  Yoichi NAKAYAMA <yoichi@FreeBSD.org>
  *  Yuri Victorovich <yuri@rawbw.com>
  *  Zach Thompson <hideo@lastamericanempire.com>
  *  Zach Thompson <lin-chi@lastamericanempire.com>
  *  ache@FreeBSD.org
  *  alfred
  *  alp@sfedu.ru
  *  andrew@scoop.co.nz
  *  andrey@kostenko.name
  *  chinsan
  *  chinsan <chinsan.tw@gmail.com>
  *  clive
  *  clive@FreeBSD.org
  *  clsung@dragon2.net
  *  dcf@aracnet.com
  *  elvstone@gmail.com
  *  erikhb@bgnett.no
  *  erwin@FreeBSD.org
  *  gahr
  *  ijliao
  *  ijlioa
  *  ivoras
  *  johnpupu <johnpupu@gmail.com>
  *  kirk@daycos.com
  *  kuriyama
  *  lbartoletti <lbartoletti@FreeBSD.org>
  *  loïc bartoletti <lbartoletti@FreeBSD.org>
  *  mharo@FreeBSD.org
  *  michael johnson <ahze@ahze.net>
  *  milki <milki@rescomp.berkeley.edy>
  *  mm@FreeBSD.org
  *  nbm
  *  nectar@FreeBSD.org
  *  nork@FreeBSD.org
  *  nork@cityfujisawa.ne.jp
  *  olevole@olevole.ru
  *  proler@gmail.com
  *  sergey@migsoft.com.ua
  *  sobomax
  *  spam@rm-rf.kiev.ua
  *  stas
  *  tobez
  *  tremere@cainites.net
  *  vanilla
  *  vanilla@
  *  wen@FreeBSD.org
  *  wenheping<wenheping@gmail.com>
  *  wolman@cs.washington.edu
  * # Created by Kevin Bowling <kbowling@FreeBSD.org>
  * # Created by Matthias Fechner <mfechner@FreeBSD.org>

With hat:	portmgr
commit hash: d076ad94e206dda108061fe99ddb860d93cc6d16 commit hash: d076ad94e206dda108061fe99ddb860d93cc6d16 commit hash: d076ad94e206dda108061fe99ddb860d93cc6d16 commit hash: d076ad94e206dda108061fe99ddb860d93cc6d16 d076ad9
Thursday, 12 May 2022
13:41 Palle Girgensohn (girgen) search for other commits by this committer
databases/postgresql??-server: update to latest version

The PostgreSQL Global Development Group has released an update to all
supported versions of PostgreSQL, including 14.3, 13.7, 12.11, 11.16,
and 10.21. This release fixes over 50 bugs reported over the last three
months. This release closes one security vulnerability and fixes over 50
bugs reported over the last three months.

We encourage you to install this update at your earliest possible
convenience.

If you have any GiST indexes on columns using the ltree data type, you
will need to reindex them after upgrading.

For the full list of changes, please review the release notes.

It also fixes a security issue, CVE-2022-1552:

Autovacuum, REINDEX, and others omit "security restricted operation" sandbox.

Versions Affected: 10 - 14. The security team typically does not test
unsupported versions, but this problem is quite old.

Autovacuum, REINDEX, CREATE INDEX, REFRESH MATERIALIZED VIEW, CLUSTER,
and pg_amcheck made incomplete efforts to operate safely when a
privileged user is maintaining another user's objects. Those commands
activated relevant protections too late or not at all. An attacker
having permission to create non-temp objects in at least one schema
could execute arbitrary SQL functions under a superuser identity.

While promptly updating PostgreSQL is the best remediation for most
users, a user unable to do that can work around the vulnerability by
disabling autovacuum, not manually running the above commands, and not
restoring from output of the pg_dump command. Performance may degrade
quickly under this workaround. VACUUM is safe, and all commands are fine
when a trusted user owns the target object.

Security:   157ce083-d145-11ec-ab9b-6cc21735f730
Release notes:	https://www.postgresql.org/docs/release/
commit hash: 6c00f6e30fbd66a5ccc7173c9f4aca3122cd4c63 commit hash: 6c00f6e30fbd66a5ccc7173c9f4aca3122cd4c63 commit hash: 6c00f6e30fbd66a5ccc7173c9f4aca3122cd4c63 commit hash: 6c00f6e30fbd66a5ccc7173c9f4aca3122cd4c63 6c00f6e
Sunday, 10 Apr 2022
19:11 Charlie Li (vishwin) search for other commits by this committer
textproc/libxml2: bump all LIB_DEPENDS consumers

This is a separate commit to facilitate easier cherry-picking for
quarterly.

PR: 262853, 262940, 262877, 263126
Approved by: fluffy (mentor)
commit hash: d63665f7cd9c99880704a3c5bc221829cb009744 commit hash: d63665f7cd9c99880704a3c5bc221829cb009744 commit hash: d63665f7cd9c99880704a3c5bc221829cb009744 commit hash: d63665f7cd9c99880704a3c5bc221829cb009744 d63665f
Saturday, 26 Mar 2022
08:27 Matthias Fechner (mfechner) search for other commits by this committer
textproc/libxml2: bump all dependencies

This should make sure that all dependent ports will pick
up the new version commited with a13ec21cd733f67a9fc0dc00ab45268bdc236246
commit hash: 247c7db7513f1264922428278678da641c5a3f52 commit hash: 247c7db7513f1264922428278678da641c5a3f52 commit hash: 247c7db7513f1264922428278678da641c5a3f52 commit hash: 247c7db7513f1264922428278678da641c5a3f52 247c7db
Thursday, 20 May 2021
14:38 Palle Girgensohn (girgen) search for other commits by this committer
databases/postgresql14-*: Add postgresql 14 beta1 the the ports tree.

Release notes:	https://www.postgresql.org/docs/devel/release-14.html

Also reintroduce parallel builds. Some components, namely plperl,
plpython, pltcl and contrib, fail to build properly when using parallel
builds. Something with static linking using `ar` that fails.
MAKE_JOBS_UNSAFE is set for these ports.
commit hash: fccc45e5ff4a8aea150005196c0d4f2cbaeed5db commit hash: fccc45e5ff4a8aea150005196c0d4f2cbaeed5db commit hash: fccc45e5ff4a8aea150005196c0d4f2cbaeed5db commit hash: fccc45e5ff4a8aea150005196c0d4f2cbaeed5db fccc45e
Tuesday, 6 Apr 2021
14:31 Mathieu Arnold (mat) search for other commits by this committer
Remove # $FreeBSD$ from Makefiles.
commit hash: 305f148f482daf30dcf728039d03d019f88344eb commit hash: 305f148f482daf30dcf728039d03d019f88344eb commit hash: 305f148f482daf30dcf728039d03d019f88344eb commit hash: 305f148f482daf30dcf728039d03d019f88344eb 305f148
Friday, 25 Sep 2020
15:53 girgen search for other commits by this committer
Fix depenedency for postgresql13-contrib

And avoid hardcoding the version for all other versions as well, per suggestion
in the PR.

PR:		249888
Submitted by:	Christian Ullrich
Original commitRevision:550051 
Monday, 30 Dec 2019
18:04 adamw search for other commits by this committer
postgresql{96,10,11}-contrib: Add an XML option

Avoids the libxml/libxslt2 dependency chain for systems that don't need
the XML datatype plugin.

PR:		239638
Approved by:	maintainer timeout (pgsql team, nearly 5 months)
Original commitRevision:521556 
Thursday, 8 Aug 2019
15:33 girgen search for other commits by this committer
iThe PostgreSQL Global Development Group has released an update to all
supported versions of our database system, including 11.5, 10.10,
9.6.15, 9.5.19, and 9.4.24, as well as the third beta of PostgreSQL 12.
This release fixes two security issues in the PostgreSQL server, two
security issues found in one of the PostgreSQL Windows installers, and
over 40 bugs reported since the previous release.

Users should install these updates as soon as possible.

A Note on the PostgreSQL 12 Beta
================================

In the spirit of the open source PostgreSQL community, we strongly
encourage you to test the new features of PostgreSQL 12 in your database
systems to help us eliminate any bugs or other issues that may exist.
While we do not advise you to run PostgreSQL 12 Beta 3 in your
production environments, we encourage you to find ways to run your
typical application workloads against this beta release.

Your testing and feedback will help the community ensure that the
PostgreSQL 12 release upholds our standards of providing a stable,
reliable release of the world's most advanced open source relational
database.

Security Issues
===============

Two security vulnerabilities have been closed by this release:

* CVE-2019-10208: `TYPE` in `pg_temp` executes arbitrary SQL during
`SECURITY DEFINER` execution

Versions Affected: 9.4 - 11

Given a suitable `SECURITY DEFINER` function, an attacker can execute
arbitrary SQL under the identity of the function owner.  An attack
requires `EXECUTE` permission on the function, which must itself contain
a function call having inexact argument type match.  For example,
`length('foo'::varchar)` and `length('foo')` are inexact, while
`length('foo'::text)` is exact.  As part of exploiting this
vulnerability, the attacker uses `CREATE DOMAIN` to create a type in a
`pg_temp` schema. The attack pattern and fix are similar to that for
CVE-2007-2138.

Writing `SECURITY DEFINER` functions continues to require following the
considerations noted in the documentation:

https://www.postgresql.org/docs/devel/sql-createfunction.html#SQL-CREATEFUNCTION-SECURITY

The PostgreSQL project thanks Tom Lane for reporting this problem.

* CVE-2019-10209: Memory disclosure in cross-type comparison for hashed
subplan

Versions Affected: 11

In a database containing hypothetical, user-defined hash equality operators, an
attacker could read arbitrary bytes of server memory. For an attack to become
possible, a superuser would need to create unusual operators. It is possible for
operators not purpose-crafted for attack to have the properties that enable an
attack, but we are not aware of specific examples.

The PostgreSQL project thanks Andreas Seltenreich for reporting this problem.
Original commitRevision:508390 
Friday, 26 Jul 2019
20:46 gerald search for other commits by this committer
Bump PORTREVISION for ports depending on the canonical version of GCC
as defined in Mk/bsd.default-versions.mk which has moved from GCC 8.3
to GCC 9.1 under most circumstances now after revision 507371.

This includes ports
 - with USE_GCC=yes or USE_GCC=any,
 - with USES=fortran,
 - using Mk/bsd.octave.mk which in turn features USES=fortran, and
 - with USES=compiler specifying openmp, nestedfct, c11, c++0x, c++11-lang,
   c++11-lib, c++14-lang, c++17-lang, or gcc-c++11-lib
plus, everything INDEX-11 shows with a dependency on lang/gcc9 now.

PR:		238330
Original commitRevision:507372 
Wednesday, 9 Jan 2019
16:03 amdmi3 search for other commits by this committer
- Optionize SSL support in postgresql11-contrib

PR:		233257
Submitted by:	amdmi3
Approved by:	maintainer timeout (pgsql, 7 weeks)
Original commitRevision:489813 
Friday, 19 Oct 2018
21:32 girgen search for other commits by this committer
The PostgreSQL Global Development Group today announced the release of
PostgreSQL 11, the latest version of the world's most advanced open
source database.

PostgreSQL 11 provides users with improvements to overall performance of
the database system, with specific enhancements associated with very
large databases and high computational workloads. Further, PostgreSQL 11
makes significant improvements to the table partitioning system, adds
support for stored procedures capable of transaction management,
improves query parallelism and adds parallelized data definition
capabilities, and introduces just-in-time (JIT) compilation for
accelerating the execution of expressions in queries.

"For PostgreSQL 11, our development community focused on adding features
that improve PostgreSQL's ability to manage very large databases," said
(Only the first 15 lines of the commit message are shown above View all of this commit message)
Original commitRevision:482456 

Number of commits found: 15