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
This referral link gives you 10% off a Fastmail.com account and gives me a discount on my Fastmail account.
New feature planned: get notified when the package is available. Now is the time to contribute ideas/suggestions.
non port: Mk/Uses/pgsql.mk

Number of commits found: 44

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
Wednesday, 5 Jul 2023
14:11 Palle Girgensohn (girgen) search for other commits by this committer
databases/postgresql16-*: Introduce postgresql16 beta 1

URL:	https://www.postgresql.org/about/news/postgresql-16-beta-1-released-2643/
Release notes:	https://www.postgresql.org/docs/16/release-16.html
commit hash: 4ee225f90aa3f81a418859086a0bca660f44e7ef commit hash: 4ee225f90aa3f81a418859086a0bca660f44e7ef commit hash: 4ee225f90aa3f81a418859086a0bca660f44e7ef commit hash: 4ee225f90aa3f81a418859086a0bca660f44e7ef 4ee225f
Saturday, 15 Apr 2023
13:14 Muhammad Moinur Rahman (bofh) search for other commits by this committer
*/*: Remove pointers to EOLed pgsql versions

- Remove dotted pgsql versions

Approved by:	portmgr
commit hash: a40c0e7d8311e72078684f0a7ee388966a6adaf9 commit hash: a40c0e7d8311e72078684f0a7ee388966a6adaf9 commit hash: a40c0e7d8311e72078684f0a7ee388966a6adaf9 commit hash: a40c0e7d8311e72078684f0a7ee388966a6adaf9 a40c0e7
Tuesday, 7 Mar 2023
21:15 Rene Ladan (rene) search for other commits by this committer
Mk: unregister expired PostgreSQL 10
commit hash: 47c9ea70d88e20522cdfbb4f124c0d67df8a62a9 commit hash: 47c9ea70d88e20522cdfbb4f124c0d67df8a62a9 commit hash: 47c9ea70d88e20522cdfbb4f124c0d67df8a62a9 commit hash: 47c9ea70d88e20522cdfbb4f124c0d67df8a62a9 47c9ea7
Thursday, 19 May 2022
13:36 Palle Girgensohn (girgen) search for other commits by this committer
databases/postgresql??-*: add postgresql-15 to the ports tree

Introduce PostgreSQL-15 to the ports tree.

Make version 15 the master port, and add plist parameter for the
postgresql version.

Release notes:	https://www.postgresql.org/docs/devel/release.html
commit hash: 5b11f47f0d59c95f6dcf1ff75badede5ec84e72e commit hash: 5b11f47f0d59c95f6dcf1ff75badede5ec84e72e commit hash: 5b11f47f0d59c95f6dcf1ff75badede5ec84e72e commit hash: 5b11f47f0d59c95f6dcf1ff75badede5ec84e72e 5b11f47
Sunday, 24 Apr 2022
10:00 Tobias C. Berner (tcberner) search for other commits by this committer
framework: cleanup conditional-indentations in Mk/

Run Tools/scripts/indent_make_if.pl on all of Mk.

These white space changes contribute greatly to the readability of those files.
As we have a version control system, finding out the reasons for the changes
prior to these white space changes is still easily possible

Differential Revision:	https://reviews.freebsd.org/D35024
Reviewed by:		portmgr (rene, bapt)
commit hash: aa2539679084872cd84112e9df6bfee571570623 commit hash: aa2539679084872cd84112e9df6bfee571570623 commit hash: aa2539679084872cd84112e9df6bfee571570623 commit hash: aa2539679084872cd84112e9df6bfee571570623 aa25396
Friday, 11 Mar 2022
11:30 Rene Ladan (rene) search for other commits by this committer
Mk: unregister expired PostgreSQL 9.6

Update an IGNORE message, leave examples at the top of pgsql.mk
alone for now.
commit hash: a44429355e8c100e28806858d7fea0ee2b2d44ba commit hash: a44429355e8c100e28806858d7fea0ee2b2d44ba commit hash: a44429355e8c100e28806858d7fea0ee2b2d44ba commit hash: a44429355e8c100e28806858d7fea0ee2b2d44ba a444293
Monday, 14 Jun 2021
14:12 Sergey A. Osokin (osa) search for other commits by this committer
Mk/Uses: remove 9.5 from the VALID_PGSQL_VER list.

Fixes: 		a3da90c5e4f183d6a61b55ac6da01974ab575ed1
Approved by:	portmgr (rene)
commit hash: 7aac8c205037af73d0034882417a23e0c12ed0b0 commit hash: 7aac8c205037af73d0034882417a23e0c12ed0b0 commit hash: 7aac8c205037af73d0034882417a23e0c12ed0b0 commit hash: 7aac8c205037af73d0034882417a23e0c12ed0b0 7aac8c2
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:27 Mathieu Arnold (mat) search for other commits by this committer
framework: Remove $FreeBSD$

Where appropriate fiddle with a few other things.
commit hash: 5d33e045968104ac678d8b4b4ec1e8956bbf68e0 commit hash: 5d33e045968104ac678d8b4b4ec1e8956bbf68e0 commit hash: 5d33e045968104ac678d8b4b4ec1e8956bbf68e0 commit hash: 5d33e045968104ac678d8b4b4ec1e8956bbf68e0 5d33e04
Thursday, 24 Sep 2020
13:33 girgen search for other commits by this committer
Welcome PostgreSQL 13

Release notes:	https://www.postgresql.org/about/news/2077/
Original commitRevision:549921 
Friday, 24 Jul 2020
16:59 rene search for other commits by this committer
Mk: unregister expired PostgreSQL 9.4
Original commitRevision:543265 
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 
Tuesday, 15 Jan 2019
21:50 crees search for other commits by this committer
Add facility to give a range of allowable versions for postgresql

PR:		ports/213038
PR:		ports/234813
Submitted by:	lbartoletti@tuxfamily.org
Differential Revision:	https://reviews.freebsd.org/D18818
Original commitRevision:490431 
Monday, 14 Jan 2019
13:45 mat search for other commits by this committer
9.3 has been removed.

Reported by:	sbruno
Original commitRevision:490254 
Thursday, 20 Dec 2018
18:36 crees search for other commits by this committer
Add -plpython capability

PR:		ports/222094
Submitted by:	lbartoletti@tuxfamily.org
Original commitRevision:487898 
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
Bruce Momjian, a core team member of the PostgreSQL Global Development
Group. "On top of PostgreSQL's proven performance for transactional
workloads, PostgreSQL 11 makes it even easier for developers to run big
data applications at scale."

PostgreSQL benefits from over 20 years of open source development and
has become the preferred open source relational database for developers.
The project continues to receive recognition across the industry, and
has been featured as the "DBMS of the Year 2017" by DB-Engines and in
the SD Times 2018 100.

PostgreSQL 11 is the first major release since PostgreSQL 10 was
released on October 5, 2017. The next update release for PostgreSQL 11
containing bug fixes will be PostgreSQL 11.1, and the next major release
with new features will be PostgreSQL 12.

Release Notes: https://www.postgresql.org/docs/11/static/release-11.html
Original commitRevision:482456 
Saturday, 10 Feb 2018
22:19 rene search for other commits by this committer
Remove Postgresql 9.2 from the list of supported versions.

Submitted by:	cmt
Original commitRevision:461442 
Thursday, 10 Aug 2017
20:25 girgen search for other commits by this committer
Add PostgreSQL-10 to the ports tree
Original commitRevision:447720 
Monday, 3 Oct 2016
18:15 rene search for other commits by this committer
Unregister databases/postgresql91 and mention postgresql96 as a valid version.

Submitted by:	myself
Reviewed by:	mat
Differential Revision:	https://reviews.freebsd.org/D8123
Original commitRevision:423217 
Monday, 5 Sep 2016
11:15 girgen search for other commits by this committer
Add PostgreSQL-9.6 RC1

Please read the entry from 20160905 in UPDATING:

daemon user has changed to `postgres'
ICU is default on
Original commitRevision:421360 
Wednesday, 3 Aug 2016
12:09 mat search for other commits by this committer
Always include bsd.default-versions.mk in bsd.port.mk.

The variable defined in it are now always available after including
bsd.port.pre.mk.

PR:		210666
Submitted by:	mat
Exp-run by:	antoine
Sponsored by:	Absolight
Differential Revision:	https://reviews.freebsd.org/D6933
Original commitRevision:419511 
Friday, 1 Jul 2016
17:45 matthew search for other commits by this committer
Delete the now expired postgresql90 ports.  Upstream support for
postgresql-9.0.x was declared EoL in September 2015.

Summary:
Remove 9.0 from the list of postgresql versions available in ports

Disconnect postgresql90 ports from the build

Remove postgresql90-pgtcl port

Remove postgresql90-client port

Move the master postgreslXY-plperl makefile to postgresql95-plperl/Makefile.

Adjust include lines in other postgresqlXY-plperl ports

Delete postgresql90-plperl

Move the master postgreslXY-plpython/{Makefile,pkg-descr} to
postgresl95-plpython/{Makefile,pkg-descr}

Adjust all other postgresqlXY-plpython/Makefile to include the new master

Remove postgresql90-server

Reviewers: jgh, girgen, #portmgr, O5 Ports Framework, bapt, crees

Reviewed By: #portmgr, O5 Ports Framework, bapt, crees

Subscribers: mat

Differential Revision: https://reviews.freebsd.org/D6898
Original commitRevision:417899 
Wednesday, 22 Jun 2016
06:27 matthew search for other commits by this committer
WANT_PGSQL=lib adds a LIB_DEPENDS on postgresglXY-client (this is also
the default when WANT_PGSQL is not defined). Compare to
WANT_PGSQL=client which only adds a RUN_DEPENDS on
postgresqlXY-client. 'client' can be part of a list of different
components, but 'lib' is ignored if any other terms are specified,
which seems an arbitrary and incorrect restriction.

WANT_PGSQL=lib allows expressing that the port links against
libpq.so.X rather than just needing one of the client programs like
psql(1) at runtime. However, other than that there is little
practical difference between 'lib' and 'client' on the resulting pkg.

Approved by:	crees (pgsql@)
Sponsored by:	https://reviews.freebsd.org/D6893
Original commitRevision:417292 
Thursday, 14 Apr 2016
13:34 mat search for other commits by this committer
Try to be more helpful to our users, and keep all the possible versions
close to their default value in Mk/bsd.default-versions.mk.

Sponsored by:	Absolight
Original commitRevision:413261 
Sunday, 27 Mar 2016
01:23 bapt search for other commits by this committer
Remove the now unneeded ${PORTSDIR} from dependency definition in
The infrastructure Makefiles

PR:		206569
Exp run by:	antoine
Differential Revision:	D5047
Original commitRevision:411970 
Thursday, 17 Mar 2016
12:09 fjoe search for other commits by this committer
Fix installed version check on FreeBSD 9.

PR:		200569
Original commitRevision:411273 
Wednesday, 10 Feb 2016
12:18 fjoe search for other commits by this committer
Prefer installed version instead of insisting on using default version.

PR:		200569
Original commitRevision:408625 
Friday, 22 Jan 2016
00:18 girgen search for other commits by this committer
pgbench has moved from contrib to base in 9.5
so we need something else to depend on for -contrib
Original commitRevision:406885 
Thursday, 7 Jan 2016
19:58 girgen search for other commits by this committer
The PostgreSQL Global Development Group announces the
release of PostgreSQL 9.5.

This release adds UPSERT capability, Row Level Security,
and multiple Big Data features, which will broaden the
user base for the world's most advanced database.
With these new capabilities, PostgreSQL will be
the best choice for even more applications for startups,
large corporations, and government agencies.

Release Notes:
http://www.postgresql.org/docs/current/static/release-9-5.html

What's New in 9.5:
https://wiki.postgresql.org/wiki/What%27s_new_in_PostgreSQL_9.5
Original commitRevision:405482 
Thursday, 15 Oct 2015
07:36 bapt search for other commits by this committer
Readd PORTSDIR for now we will only start removing them after 2016Q1 is branched

This gives more time for tools to get updated, available in packages etc before
bothering users
Original commitRevision:399326 
Wednesday, 14 Oct 2015
16:49 bapt search for other commits by this committer
Drop the necessity to add ${PORTSDIR} to dependency line

Modify make describe to automatically prepend ${PORTSDIR} if the path for the
port is not absolute

Checked with poudriere, portmaster, portupgrade

PR:		203685
Exp-run by:	antoine
Differential Revision:	https://reviews.freebsd.org/D3866
Original commitRevision:399278 
Tuesday, 7 Jul 2015
21:31 pgollucci search for other commits by this committer
- Fix dependencies on docs, plperl, pltcl

postgresql93-$dep not postgresql9.3-$dep
Note, nothing uses doc, plperl, or pltcl yet

Required for PR: 201124
Approved by:     portmgr (bapt)
Original commitRevision:391531 
Wednesday, 10 Jun 2015
15:36 rene search for other commits by this committer
USES=pgsql: desupport PostgreSQL 8.4

Postgresql 8.4 expired on 2015-05-10 because upstream discontinued support for
them in July 2014.

PR:		200228
Reviewed by:	marino, portmgr (antoine)
Original commitRevision:389039 
Saturday, 22 Nov 2014
21:31 crees search for other commits by this committer
Fix special [:build] case
Original commitRevision:373104 
Sunday, 28 Sep 2014
16:36 tijl search for other commits by this committer
Change the way USES is handled:
- Loop over USES twice, once to define all *_ARGS variables and once to
  include Uses/*.mk.  This allows all Uses/*.mk to examine arguments given
  to other USES entries.
- Always define *_ARGS (possibly empty) and replace commas with spaces.

Similar for _USES_POST.

Adjust all Uses/*.mk:
- defined(u_ARGS) becomes !empty(u_ARGS)
- Eliminate helper variables like _*_ARGS=${*_ARGS:C/,/ /g}
- Some Uses/*.mk used ":" as argument separator instead of ",", but no port
  used this form
- Uses/cran.mk: remove unused variable VALID_ARGS and USES+=fortran which
  has no effect
- Uses/twisted.mk: simplify handling of the case where neither "build" nor
  "run" arguments have been specified

PR:		193931
Exp-run by:	antoine
Approved by:	portmgr (antoine)
Original commitRevision:369465 
Tuesday, 2 Sep 2014
17:53 crees search for other commits by this committer
Complain properly about invalid pgsql default versions.

Please remember you need the period; 9.0 9.1 good, 90 bad, 90+ very bad!
Original commitRevision:367065 
Monday, 25 Aug 2014
17:53 crees search for other commits by this committer
Convert pgsql ports to use USES+=pgsql

Reviewed by:	bapt
Original commitRevision:366114 
Thursday, 29 May 2014
08:09 antoine search for other commits by this committer
Add 9.4 to the list of valid pgsql versions

With hat:	portmgr
Original commitRevision:355672 
Tuesday, 27 May 2014
10:55 bapt search for other commits by this committer
Fix version comparison
Original commitRevision:355485 
Monday, 5 May 2014
12:39 bapt search for other commits by this committer
Finish USES=pgsql

Add WANT_PGSQL=client support
Do not test WANT_PGSQL if it is not defined
Fix a couple of typos makeing it unusable
add WANT_PGSQL=lib (default it nothing is specified)
only depends on library if no WANT_PGSQL is set or lib is explicitly
added to WANT_PGSQL
Original commitRevision:352998 
Saturday, 15 Mar 2014
10:31 gerald search for other commits by this committer
Move MAINTAINER lines to the end of the initial comment block and
make things a bit more consistent.

Approved by:	portmgr (bapt)
Original commitRevision:348308 
Monday, 13 Jan 2014
07:07 bapt search for other commits by this committer
First simple and easy change: use mordern LIB_DEPENDS
Original commitRevision:339571 
Sunday, 12 Jan 2014
21:16 crees search for other commits by this committer
Strip postgresql code out of bsd.database.mk, and introduce USES=pgsql.

New syntax:

# Depend on postgresql-client
USES=	pgsql

# Depend on postgresql-client at least 9.2
USES=	pgsql:9.2+

#Depend on postgresql-server at least 9.0
USES=		pgsql:9.0+
WANT_PGSQL=	server

Postgresql now supports DEFAULT_VERSIONS, and please note that the
version syntax now includes dots(!); i.e. before it was 90, now 9.0

Reviewed by:	ade, silence from pgsql@
Original commitRevision:339550 

Number of commits found: 44