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.

Get notified when packages are built

A new feature has been added. FreshPorts already tracks package built by the FreeBSD project. This information is displayed on each port page. You can now get an email when FreshPorts notices a new package is available for something on one of your watch lists. However, you must opt into that. Click on Report Subscriptions on the right, and New Package Notification box, and click on Update.

FInally, under Watch Lists, click on ABI Package Subscriptions to select your ABI (e.g. FreeBSD:14:amd64) & package set (latest/quarterly) combinatio for a given watch list. This is what FreshPorts will look for.

non port: databases/postgresql84-server/Makefile

Number of commits found: 101 (showing only 100 on this page)

1 | 2  »  

Thursday, 14 May 2015
10:15 mat search for other commits by this committer
MASTER_SITES cleanup.

- Replace ${MASTER_SITE_FOO} with FOO.
- Merge MASTER_SITE_SUBDIR into MASTER_SITES when possible. (This means 99.9%
  of the time.)
- Remove occurrences of MASTER_SITE_LOCAL when no subdirectory was present and
  no hint of what it should be was present.
- Fix some logic.
- And generally, make things more simple and easy to understand.

While there, add magic values to the FESTIVAL, GENTOO, GIMP, GNUPG, QT and
SAMBA macros.

Also, replace some EXTRACT_SUFX occurences with USES=tar:*.

Checked by:	make fetch-urlall-list
With hat:	portmgr
Sponsored by:	Absolight
Original commitRevision:386312 
Sunday, 19 Apr 2015
11:12 girgen search for other commits by this committer
Commit the missing part of last commit: Chase upcoming update of ICU to 5.5.
Original commitRevision:384279 
Saturday, 18 Apr 2015
12:37 girgen search for other commits by this committer
Chase upcoming update of ICU to 5.5.
Original commitRevision:384223 
Wednesday, 25 Mar 2015
09:33 marino search for other commits by this committer
databases category: Remove $PTHREAD_LIBS

Note: virtuoso did not pass check-plist from before, so it was fixed.

approved by:	PTHREAD blanket
Original commitRevision:382201 
Tuesday, 10 Feb 2015
07:57 girgen search for other commits by this committer
Deprecate PostgreSQL 8.4, EOL was reached in July 2014.
Original commitRevision:378760 
Wednesday, 12 Nov 2014
09:53 girgen search for other commits by this committer
Revert r247147.
We need -pthread in LDFLAGS for threaded extensions like plv8js to work.

PR:		175783
Submitted by:	Li-Wen Hsu <lwhsu@FreeBSD.org>
Original commitRevision:372487 
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 
Wednesday, 30 Jul 2014
18:21 crees search for other commits by this committer
Update to the latest snapshots.

uuid-ossp patch has been outdated with irrelevant changes (for us),
so massage back in.

In head of postgresql, this is handled properly, so eventually the ossp patches
can go.
Original commitRevision:363500 
Thursday, 24 Jul 2014
18:34 tijl search for other commits by this committer
net/openldap24-*:
- Convert to USES=libtool and bump dependent ports
- Avoid USE_AUTOTOOLS
- Don't use PTHREAD_LIBS
- Use MAKE_CMD

databases/glom:
- Drop :keepla
- Add INSTALL_TARGET=install-strip

databases/libgda4* databases/libgda5*:
- Convert to USES=libtool and bump dependent ports
- USES=tar:xz
- Use INSTALL_TARGET=install-strip
- Use @sample

databases/libgdamm:
- Drop :keepla
- USES=tar:bzip2
- Use INSTALL_TARGET=install-strip

databases/libgdamm5:
- Add INSTALL_TARGET=install-strip
- Drop --enable-static (inherited from old repocopy)

devel/anjuta x11-toolkits/py-gnome-extras:
- Drop :keepla

dns/powerdns dns/powerdns-devel:
- Convert to USES=libtool
- Add INSTALL_TARGET=install-strip
- Disable static modules
- Stop creating library symlinks with .0 suffix, not needed for dynamically
  opened modules

mail/dovecot2:
- Add USES=libtool

mail/dovecot2-pigeonhole:
- Drop CONFIGURE_TARGET (incorrect for Dragonfly)
- Add USES=libtool and INSTALL_TARGET=install-strip

math/gnumeric:
- USES=libtool tar:xz

Approved by:	portmgr (implicit, bump unstaged ports)
Original commitRevision:362835 
Tuesday, 24 Jun 2014
22:34 bapt search for other commits by this committer
Properly call MAKE_CMD
Original commitRevision:359153 
Monday, 9 Jun 2014
21:57 girgen search for other commits by this committer
Prepare for upcoming ICU-5.3 upgrade.
Original commitRevision:357209 
Wednesday, 16 Apr 2014
18:28 zeising search for other commits by this committer
The FreeBSD x11@ and graphics team proudly presents
a zeising, kwm production, with help from dumbbell, bdrewery:

NEW XORG ON FREEBSD 9-STABLE AND 10-STABLE

This update switches over to use the new xorg stack by default on FreeBSD 9
and 10 stable, on osversions where vt(9) is available.
It is still possible to use the old stack by specifying WITHOUT_NEW_XORG in
/etc/make.conf .
FreeBSD 8-STABLE and released versions of FreeBSD still use
the old version.
A package repository with binary packages for new xorg will
be available soon.

This patch also contains updates of libxcb and related ports, pixman, as well
as some drivers and utilities.

Bump portrevisions for xf86-* ports, as well as virtualbox-ose-additions due
to xserver version change.

Apart from these updates, the way shared libraries are handled has been
changed for all xorg ports, as well as libxml2 and freetype, which means
ltverhack is gone and as a consequence shared libraries have been bumped.
The plan is that this change will make library bumps less likely in the
future.
All affected ports have had their portrevisions bumped as a consequence of
this.

Fix some issues where WITH_NEW_XORG weren't detected properly on CURRENT.

Update instructions, hardware support, and more notes can be found on
https://wiki.freebsd.org/Graphics

Thanks to:	all testers, bdrewery and the FreeBSD x11@ team
exp-run by:	bdrewery [1]
PR:		ports/187602 [1]
Approved by:	portmgr (bdrewery), core (jhb)
Original commitRevision:351411 
Sunday, 23 Mar 2014
10:32 girgen search for other commits by this committer
Fix problem building postgresql84-server with ICU patch
PR:	ports/186875
Original commitRevision:348849 
Thursday, 20 Mar 2014
13:43 girgen search for other commits by this committer
The PostgreSQL Global Development Group has released an update to all supported
version of the database system, including versions 9.3.4, 9.2.8, 9.1.13,
9.0.17, and 8.4.21. This minor release fixes a data corruption issue with
replication and crash recovery in version 9.3, as well as several other minor
issues in all versions.  All users of version 9.3 are urged to update their
installations at the next possible downtime.  Users of older versions should
update at their convenience.

The data corruption issue in PostgreSQL 9.3 affects binary replication
standbys, servers being recovered from point-in-time-recovery backup, and
standalone servers which recover from a system crash. The bug causes
unrecoverable index corruption during recovery due to incorrect replay of row
locking operations.  This can then cause query results to be inconsistent
depending on whether or not an index is used, and eventually lead to primary
key violations and similar issues.  For this reason, users are encouraged to
replace each of their standby databases with a new base backup after applying
the update.

See release notes for more changes.

URL:	http://www.postgresql.org/docs/current/static/release.html
URL:	https://wiki.postgresql.org/wiki/20140320UpdateIssues

A change specific to the FreeBSD port:
Modify the contrib/uuid-ossp to actually work (not crashing the backend) by
using the libc implementation of uuid instead of the ossp port. Schemas and
queries will just work. Based on the work of Andrew Gierth. 9.1+ EXTENSION
support added by girgen@.

URL:	http://pgfoundry.org/projects/uuid-freebsd
PR:	ports/121745, ports/182846
Original commitRevision:348685 
Wednesday, 26 Feb 2014
17:24 antoine search for other commits by this committer
Stage support

Reviewed by:	postgresql@
Tested by:	miwi and me
Original commitRevision:346217 
Thursday, 20 Feb 2014
18:11 girgen search for other commits by this committer
The PostgreSQL Global Development Group has released an important
update to all supported versions of the PostgreSQL database system,
which includes minor versions 9.3.3, 9.2.7, 9.1.12, 9.0.16, and
8.4.20. This update contains fixes for multiple security issues, as
well as several fixes for replication and data integrity issues.  All
users are urged to update their installations at the earliest
opportunity, especially those using binary replication or running a
high-security application.

This update fixes CVE-2014-0060, in which PostgreSQL did not properly
enforce the WITH ADMIN OPTION permission for ROLE management. Before
this fix, any member of a ROLE was able to grant others access to the
same ROLE regardless if the member was given the WITH ADMIN OPTION
permission. It also fixes multiple privilege escalation issues,
including: CVE-2014-0061, CVE-2014-0062, CVE-2014-0063, CVE-2014-0064,
CVE-2014-0065, and CVE-2014-0066. More information on these issues can
be found on our security page and the security issue detail wiki page.

Security:	CVE-2014-0060,CVE-2014-0061,CVE-2014-0062,CVE-2014-0063
		CVE-2014-0064,CVE-2014-0065,CVE-2014-0066,CVE-2014-0067
Original commitRevision:345257 
Monday, 10 Feb 2014
16:32 girgen search for other commits by this committer
Chase ICU update
Original commitRevision:343650 
Friday, 7 Feb 2014
11:44 bapt search for other commits by this committer
Chase boost and icu bump
While here convert some LIB_DEPENDS
Original commitRevision:343214 
Wednesday, 11 Dec 2013
18:08 bapt search for other commits by this committer
In preparation for making libtool generate libraries with a sane name, fix all
LIB_DEPENDS in databases
Original commitRevision:336187 
Thursday, 5 Dec 2013
15:59 girgen search for other commits by this committer
The PostgreSQL Global Development Group has released a critical update
to all supported versions of the PostgreSQL database system, which
includes minor versions 9.3.2, 9.2.6, 9.1.11, 9.0.15, and 8.4.19. This
update fixes three serious data-loss bugs affecting replication and
database maintenance.  All users are urged to update their
installations at the earliest opportunity.

URL:	http://www.postgresql.org/about/news/1492/
Original commitRevision:335673 
Tuesday, 15 Oct 2013
17:17 sunpoet search for other commits by this committer
- Remove DISTV: only used in PKGNAMESUFFIX and complained by portlint
- Convert to new LIB_DEPENDS format for postgresql*-contrib

Submitted by:	sunpoet (myself)
Reviewed by:	crees (pgsql)
Approved by:	jgh (pgsql)
Original commitRevision:330414 
Saturday, 12 Oct 2013
00:59 girgen search for other commits by this committer
Update PostgreSQL ports to 9.3.1, 9.2.5, 9.1.10, 9.0.14, and 8.4.18.

Note that users of the hstore extension on version 9.3 must take an additional,
post upgrade step of running "ALTER EXTENSION hstore UPDATE" in each database
after update.

URL:	http://www.postgresql.org/about/news/1487/
Original commitRevision:330109 
Thursday, 10 Oct 2013
00:09 jgh search for other commits by this committer
- Fix pkg name collision

Reviewed by: pgsql@
With hat: pgsql@
Original commitRevision:329946 
Monday, 7 Oct 2013
20:03 jgh search for other commits by this committer
- revert r329725

Reported by: qat@
With hat: pgsql@
Original commitRevision:329729 
19:04 jgh search for other commits by this committer
- Fix pkg name collision

Reviewed by: crees@
With hat: pgsql@
Original commitRevision:329725 
Friday, 20 Sep 2013
16:13 bapt search for other commits by this committer
Add NO_STAGE all over the place in preparation for the staging support (cat:
databases)
Original commitRevision:327717 
Sunday, 7 Jul 2013
00:15 jgh search for other commits by this committer
- convert from USE_GMAKE to USES=gmake
- trim historical headers

With hat: pgsql@
Original commitRevision:322415 
Sunday, 28 Apr 2013
18:15 crees search for other commits by this committer
databases/postgresql-server ports: Unbreak NLS

Submitted by:	bapt
Original commitRevision:316740 
14:00 crees search for other commits by this committer
databases/postgresql{84,91,92}-server: Readd bsd.port.pre.mk; it is required for
checking existence of files in FILESDIR
Original commitRevision:316726 
Friday, 26 Apr 2013
15:10 bapt search for other commits by this committer
Convert USE_GETTEXT -> USES=gettext

While here:
- Trim headers
- Remove some useless pre.mk/post.mk
- Convert to optionsng
Original commitRevision:316620 
Friday, 5 Apr 2013
15:26 girgen search for other commits by this committer
Fix pkg-list for postgresql84-server

Approved by:	portmgr (miwi)
Original commitRevision:315734 
Thursday, 4 Apr 2013
13:21 girgen search for other commits by this committer
The PostgreSQL Global Development Group has released a security
update to all current versions of the PostgreSQL database system,
including versions 9.2.4, 9.1.9, 9.0.13, and 8.4.17. This update
fixes a high-exposure security vulnerability in versions 9.0 and
later. All users of the affected versions are strongly urged to apply
the update *immediately*.

A major security issue (for versions 9.x only) fixed in this release,
[CVE-2013-1899](http://cve.mitre.org/cgi-bin/cvename.cgi?name=CVE-2013-1899),
makes it possible for a connection request containing a database name
that begins with "-" to be crafted that can damage or destroy files
within a server's data directory. Anyone with access to the port the
PostgreSQL server listens on can initiate this request. This issue was
discovered by Mitsumasa Kondo and Kyotaro Horiguchi of NTT Open Source
Software Center.

Two lesser security fixes are also included in this release:
[CVE-2013-1900](http://cve.mitre.org/cgi-bin/cvename.cgi?name=CVE-2013-1900),
wherein random numbers generated by contrib/pgcrypto functions may be
easy for another database user to guess (all versions), and
[CVE-2013-1901](http://cve.mitre.org/cgi-bin/cvename.cgi?name=CVE-2013-1901),
which mistakenly allows an unprivileged user to run commands that
could interfere with in-progress backups (for versions 9.x only).

Approved by:	portmgr (bdrewery)
URL:		http://www.postgresql.org/about/news/1456/
Security:	http://cve.mitre.org/cgi-bin/cvename.cgi?name=CVE-2013-1899
Security:	http://cve.mitre.org/cgi-bin/cvename.cgi?name=CVE-2013-1900
Security:	http://cve.mitre.org/cgi-bin/cvename.cgi?name=CVE-2013-1901
Original commitRevision:315718 
Friday, 8 Feb 2013
07:54 girgen search for other commits by this committer
PostgreSQL 9.2.3, 9.1.8, 9.0.12, 8.4.16 and 8.3.23 released

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
Original commitRevision:311915 
Tuesday, 22 Jan 2013
18:32 crees search for other commits by this committer
Remove versioned PKGNAMESUFFIX from -plpython ports; the versions differ anyway

Submitted by:	sunpoet
Original commitRevision:310833 
17:59 crees search for other commits by this committer
Fix package build for -plpython

Although the plpython work was done by rm, this problem was actually my fault

Noticed by:	sunpoet
Original commitRevision:310832 
Thursday, 27 Dec 2012
21:11 jgh search for other commits by this committer
- remove broken configurable non-default user/group for postgresql-server
- while here fix formatting of new header

With hat: pgsql@
Original commitRevision:309555 
Wednesday, 19 Dec 2012
16:13 girgen search for other commits by this committer
Chase ICU update properly and bump PORTREVISION
Original commitRevision:309247 
Thursday, 6 Dec 2012
16:40 girgen search for other commits by this committer
The PostgreSQL Global Development Group has released an update to all current
versions of the PostgreSQL database system, including versions 9.2.2, 9.1.7,
9.0.11, 8.4.15, and 8.3.22.  Users of PostgreSQL Hot Standby replication
should update at the next possible opportunity. Other users should update
at their next maintenance window.

Deprecate the 8.3.22 version, since it is near end-of-life.

URL:	http://www.postgresql.org/about/news/1430/

Feature safe: yes
Original commitRevision:308391 
Tuesday, 16 Oct 2012
17:28 jgh search for other commits by this committer
- adopt optionsNG

with hat pgsql@
Feature safe: yes
Original commitRevision:305983 
Monday, 24 Sep 2012
22:03 girgen search for other commits by this committer
Update PostgreSQL to 9.2.1, 9.1.6, 9.0.10, 8.4.14 and 8.3.21 respectively.

This update fixes critical issues for major versions 9.1 and 9.2, and
users running those versions should apply it as soon as possible.

URL:	http://www.postgresql.org/about/news/1416/
Original commitRevision:304804 
Sunday, 19 Aug 2012
15:24 crees search for other commits by this committer
Use pre-build instead of pre-everything for backupwarning-- stop making people
wait before fetching etc

Suggested by:	ohauer
Discussed with:	girgen

While here, fix package for postgresql92-server
Original commit
Friday, 17 Aug 2012
19:39 jgh search for other commits by this committer
The PostgreSQL Global Development Group today released security updates for all
active branches
of the PostgreSQL database system, including versions 9.1.5, 9.0.9, 8.4.13 and
8.3.20. This
update patches security holes associated with libxml2 and libxslt, similar to
those affecting
other open source projects. All users are urged to update their installations at
the first
available opportunity.

This security release fixes a vulnerability in the built-in XML functionality,
and a vulnerability
in the XSLT functionality supplied by the optional XML2 extension. Both
vulnerabilities allow
reading of arbitrary files by any authenticated database user, and the XSLT
vulnerability
allows writing files as well. The fixes cause limited backwards compatibility
issues.
These issues correspond to the following two vulnerabilities:

CVE-2012-3488: PostgreSQL insecure use of libxslt
CVE-2012-3489: PostgreSQL insecure use of libxml2
This release also contains several fixes to version 9.1, and a smaller number of
fixes to older versions, including:

Updates and corrections to time zone data
Multiple documentation updates and corrections
Add limit on max_wal_senders
Fix dependencies generated during ALTER TABLE ADD CONSTRAINT USING INDEX.
Correct behavior of unicode conversions for PL/Python
Fix WITH attached to a nested set operation (UNION/INTERSECT/EXCEPT).
Fix syslogger so that log_truncate_on_rotation works in the first rotation.
Only allow autovacuum to be auto-canceled by a directly blocked process.
Improve fsync request queue operation
Prevent corner-case core dump in rfree().
Fix Walsender so that it responds correctly to timeouts and deadlocks
Several PL/Perl fixes for encoding-related issues
Make selectivity operators use the correct collation
Prevent unsuitable slaves from being selected for synchronous replication
Make REASSIGN OWNED work on extensions as well
Fix race condition with ENUM comparisons
Make NOTIFY cope with out-of-disk-space
Fix memory leak in ARRAY subselect queries
Reduce data loss at replication failover
Fix behavior of subtransactions with Hot Standby
Original commit
Monday, 4 Jun 2012
11:00 girgen search for other commits by this committer
The PostgreSQL Global Development Group today released security updates for all
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
Original commit
Wednesday, 30 May 2012
22:26 jgh search for other commits by this committer
- Address postgresql*-servers for crypt vulnerability (CVE-2012-2143)

http://www.postgresql.org/about/news/1397/

With hat: pgsql
Original commit
Monday, 5 Mar 2012
20:10 crees search for other commits by this committer
Various tidiness patches:
 - Compact -plperl ports
 - Portlint for 90-plperl
 - Update version numbers in pkg-install-server
 - s/spaces/tabs/
 - Use ${} instead of $()
 - s/YES/yes/
 - Tidy IGNORE values

Submitted by:   sunpoet
Original commit
Sunday, 4 Mar 2012
17:19 crees search for other commits by this committer
Over to new team, pgsql@FreeBSD.org
Original commit
Monday, 27 Feb 2012
16:24 girgen search for other commits by this committer
The PostgreSQL Global Development Group today released security updates for all
active branches of the PostgreSQL object-relational database system, including
versions 9.1.3, 9.0.7, 8.4.11 and 8.3.18.

Users of pg_dump, users of SSL certificates for validation or users of triggers
using SECURITY DEFINER should upgrade their installations immediately. All
other database administrators are urged to upgrade your version of PostgreSQL
at the next scheduled downtime. More details on the security fixes here:

URL:    http://www.postgresql.org/about/news/1377/

Security: http://cve.mitre.org/cgi-bin/cvename.cgi?name=CVE-2012-0866
Security: http://cve.mitre.org/cgi-bin/cvename.cgi?name=CVE-2012-0867
Security: http://cve.mitre.org/cgi-bin/cvename.cgi?name=CVE-2012-0868
Original commit
Thursday, 16 Feb 2012
13:15 crees search for other commits by this committer
Look for the correct ICU patchfile

Submitted by:   Jaime Bozza <jbozza@mindsites.com>
Original commit
Monday, 30 Jan 2012
18:39 crees search for other commits by this committer
Use DISTVERSION instead of PORTVERSION to generate UNIQUENAME; options
don't work correctly otherwise.

http://lists.freebsd.org/pipermail/freebsd-ports/2012-January/072756.html

Pointyhat:      crees
Original commit
Wednesday, 25 Jan 2012
21:12 crees search for other commits by this committer
- To preserve my sanity, slave 82 and 83 to 84, and 90 to 91, resulting in
  three fewer Makefiles to maintain

- Switch patch master site

- Various cleanups
Original commit
Sunday, 22 Jan 2012
06:59 jgh search for other commits by this committer
- Add profile support for PostgreSQL servers
- 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)
Original commit
Thursday, 19 Jan 2012
19:06 jgh search for other commits by this committer
fix typo %%PG_GROUP%% in pkg-plist-server

Spotted by: decke
Approved by:    crees, rene (mentors,implicit)
Original commit
03:35 tabthorpe search for other commits by this committer
- Reset ports due to maintainer timeouts and lack of response to emails

With hat:       portmgr
Original commit
Wednesday, 18 Jan 2012
21:35 jgh search for other commits by this committer
Fix plist to create directory with proper ownerships PostgreSQL database
may start.

PR:     ports/164273 (critical)
Submitted by: Alexander Yerenkow <yerenkow at gmail.com>
Approved by:    maintainer-timeout: girgen (1 day), portmgr (linimon)
Original commit
Monday, 5 Dec 2011
16:45 girgen search for other commits by this committer
The PostgreSQL Global Development Group today released updates for all
active branches of the PostgreSQL object-relational database system,
including versions 9.1.2, 9.0.6, 8.4.10, 8.3.17 and 8.2.23.

This release contains 52 fixes to version 9.1, and a smaller number of
fixes to older versions, including:

- Fix bugs in information_schema.referential_constraints view**
- Correct collations for citext columns and indexes**
- Prevent possible crash when joining to a scalar function
- Prevent transitory data corruption of GIN indexes after a crash
- Prevent data corruption on TOAST columns when copying data
- Fix failures during hot standby startup
- Correct another "variable not found in subplan target list" bug
- Fix bug with sorting on aggregate expressions in windowing functions
- Multiple bug fixes for pg_upgrade
- Change Foreign Key creation order to better support
 self-referential keys**
- Multiple bug fixes to CREATE EXTENSION
- Ensure that function return type and data returned from PL/perl agree
- Ensure that PL/perl strings are always UTF-8
- Assorted bug fixes for various Extensions
- Updates to the time zone database, particularly to CST6

Changes marked with ** above require additional, post-update steps in
order to fix all described issues.

URL:    http://www.postgresql.org/docs/current/static/release.html

Also, fix a pthread problem in the FreeBSD port. [1]
PR:     160580 [1]
Feature safe:   yes
Original commit
Wednesday, 30 Nov 2011
18:49 crees search for other commits by this committer
Add DTRACE option for postgresql84-server

PR:             ports/150431
Submitted by:   rpaulo

Fix compilation with GSSAPI

PR:             ports/161786
Submitted by:   rea
Reviewed by:    mandree, John Marshall <john.marshall@riverwillow.com.au>

Mark IGNORE if DTRACE enabled for FreeBSD < 900021 without userland dtrace

PR:             ports/152502
Submitted by:   Sevan Janiyan <venture37@geeklan.co.uk>

Approved by:    maintainer timeout (girgen, at least 2 months)
Feature safe:   yes
Original commit
Wednesday, 2 Nov 2011
18:09 crees search for other commits by this committer
Actually add the pgsql users on install

PR:             ports/162239
Approved by:    portmgr (pav)
Original commit
Friday, 21 Oct 2011
20:36 mm search for other commits by this committer
Make SSL available as an option

PR:             ports/161330
Approved by:    maintainer (timeout)
Original commit
Thursday, 20 Oct 2011
21:07 crees search for other commits by this committer
- Fix packaging issue (missed %%PG_USER%% in pkg-plist-server)
- 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)
Original commit
Wednesday, 19 Oct 2011
18:29 crees search for other commits by this committer
This time remember to bump PORTREVISION
Original commit
18:21 crees search for other commits by this committer
Fix SUB_LIST issue by deconditionalising it.

Temporary fix, but will stop the flurry of incoming PRs related.

PR:             ports/161779 ports/161774 ports/161791 ports/161771 ports/161769
Submitted by:   Many people, original fix suggested by Jason Helfman
(jhelfman@e-e.com)
Approved by:    portmgr (pav)
Original commit
Tuesday, 18 Oct 2011
09:03 girgen search for other commits by this committer
The PostgreSQL Global Development Group today released minor version updates
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.
Original commit
Sunday, 25 Sep 2011
19:40 rea search for other commits by this committer
PostgreSQL: unbreak 'make describe'

It was a really bad idea to include bsd.port.pre.mk
inside a conditional expression.

Detected by: portsnap buildbox
Pointyhat to: rea
Original commit
18:09 rea search for other commits by this committer
PostgreSQL: unbreak GSSAPI support

The problem with GSSAPI without Kerberos is that configure.in has
very funny logics of choosing GSSAPI libraries:
{{{
if test "$with_gssapi" = yes ; then
  if test "$PORTNAME" != "win32"; then
    AC_SEARCH_LIBS(gss_init_sec_context, [gssapi_krb5 gss 'gssapi -lkrb5
-lcrypto'], [],
                                  [AC_MSG_ERROR([could not find function
'gss_init_sec_context' required for GSSAPI])])
  else
    LIBS="$LIBS -lgssapi32"
  fi
fi
}}}

This makes configure to happily choose -lgssapi_krb5 when the system
has Kerberos support (NO_KERBEROS is absent), but ld's '--as-needed'
will throw this library away when no Kerberos functions are used and
linker won't produce 'postgres' binary whining about unresolved
symbols:
{{{
cc -O2 -pipe -fno-strict-aliasing -Wall -Wmissing-prototypes \
-Wpointer-arith -Wdeclaration-after-statement -Wendif-labels \
-fno-strict-aliasing -fwrapv -L../../src/port -L/usr/local/lib \
-rpath=/usr/lib:/usr/local/lib -L/usr/local/lib  -L/usr/local/lib \
-Wl,--as-needed -Wl,-R'/usr/local/lib' -Wl,-export-dynamic \
[... a bunch of *.o files was stripped ...]
../../src/timezone/pgtz.o ../../src/port/libpgport_srv.a -lintl -lssl \
-lcrypto -lgssapi_krb5 -lcrypt -lm -o postgres
libpq/auth.o: In function `pg_GSS_error':
auth.c:(.text+0x6e): undefined reference to `gss_display_status'
auth.c:(.text+0x8e): undefined reference to `gss_release_buffer'
auth.c:(.text+0xc5): undefined reference to `gss_display_status'
auth.c:(.text+0xe5): undefined reference to `gss_release_buffer'
libpq/auth.o: In function `ClientAuthentication':
auth.c:(.text+0x82d): undefined reference to `gss_delete_sec_context'
auth.c:(.text+0x941): undefined reference to `gss_accept_sec_context'
auth.c:(.text+0x9f1): undefined reference to `gss_release_buffer'
auth.c:(.text+0xaf3): undefined reference to `gss_release_cred'
auth.c:(.text+0xb10): undefined reference to `gss_display_name'
auth.c:(.text+0xbc8): undefined reference to `gss_release_buffer'
auth.c:(.text+0x10b0): undefined reference to `gss_release_buffer'
auth.c:(.text+0x111e): undefined reference to `gss_release_buffer'
libpq/pqcomm.o: In function `pq_close':
pqcomm.c:(.text+0x105a): undefined reference to `gss_delete_sec_context'
pqcomm.c:(.text+0x107d): undefined reference to `gss_release_cred'
gmake: *** [postgres] Error 1
}}}

Also, ports for PostgreSQL 8.4 and 9.0 had their <bsd.port.pre.mk>
misplaced: OPTIONS came after it, so WITH_/WITHOUT_ knobs will not
be really activated.

PR: 160050
Feature safe: yes
Approved by: maintainer timeout (1 month)
Original commit
Friday, 23 Sep 2011
22:26 amdmi3 search for other commits by this committer
- Add LDFLAGS to CONFIGURE_ENV and MAKE_ENV (as it was done with LDFLAGS)
- Fix all ports that add {CPP,LD}FLAGS to *_ENV to modify flags instead

PR:             157936
Submitted by:   myself
Exp-runs by:    pav
Approved by:    pav
Original commit
Thursday, 1 Sep 2011
21:52 pav search for other commits by this committer
- Hack to allow building of -client port.  The OPTIONS handling is still broken.

Submitted by:   Ruslan Mahmatkhanov <cvs-src@yandex.ru>
Original commit
Monday, 15 Aug 2011
14:52 crees search for other commits by this committer
Revert previous commit -- appears to cause rc problems as I missed some subs

http://www.mail-archive.com/freebsd-ports@freebsd.org/msg35324.html

PR:             ports/157558 ports/157559 ports/157666 ports/157669
Submitted by:   rihad@mail.ru
Approved by:    maintainer (girgen; implicit -- this reverts a commit I did
after maintainer timeout)
Original commit
Friday, 12 Aug 2011
09:55 crees search for other commits by this committer
Use USERS and GROUPS

PR:             ports/157666
Submitted by:   me
Approved by:    maintainer timeout (girgen, 8 weeks)
Original commit
Sunday, 10 Jul 2011
21:06 bapt search for other commits by this committer
- update ICU to 4.8
- chase library bump
- add an entry in UPDATING for instructions
- remove old conflict lines
Original commit
Tuesday, 17 May 2011
22:26 pav search for other commits by this committer
- Mark BROKEN on FreeBSD 9.X: does not link

  libpq/auth.o: In function `pg_GSS_error':
  auth.c:(.text+0x6e): undefined reference to `gss_display_status'
  [..]

Reported by:    pointyhat
Original commit
Monday, 2 May 2011
21:37 girgen search for other commits by this committer
Fix a problem with creating the postgresql user when using a package.
Original commit
Wednesday, 27 Apr 2011
13:28 girgen search for other commits by this committer
Fix problem creating postgres user when PGUSER was set.

PR: 156662
Original commit
Monday, 18 Apr 2011
23:34 girgen search for other commits by this committer
Update PostgreSQL to 9.0.4, 8.4.8, 8.3.15 and 8.2.21.

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
Original commit
Tuesday, 1 Feb 2011
14:48 girgen search for other commits by this committer
Update to versions 9.0.3, 8.4.7, 8.3.14 and 8.2.20.

This update includes a security fix which prevents a buffer overrun in
the contrib module intarray's input function for the query_int type.
This bug is a security risk since the function's return address could
be overwritten by malicious code.

All supported versions of PostgreSQL are impacted. However, the
affected contrib module is optional. Only users who have installed the
intarray module in their database are affected. See the CVE Advisory
at http://cve.mitre.org/cgi-bin/cvename.cgi?name=CVE-2010-4015

This release includes 63 bugfixes, including:

- Avoid unexpected conversion overflow in planner for distant date values
- Fix assignment to an array slice that is before the existing range
of subscripts
- Fix pg_restore to do the right thing when escaping large objects
- Avoid failures when EXPLAIN tries to display a simple-form CASE expression
- Improved build support for Windows version
- Fix bug in contrib/seg's GiST picksplit algorithm which caused
performance degredation

The 9.0.3 update also contains several fixes for issues with features
introduced or changed in version 9.0:

- Ensure all the received WAL is fsync'd to disk before exiting walreceiver
- Improve performance of walreceiver by avoiding excess fsync activity
- Make ALTER TABLE revalidate uniqueness and exclusion constraints when needed
- Fix EvalPlanQual for UPDATE of an inheritance tree when the tables
are not all alike

PR:             ports/154436
Security:       http://cve.mitre.org/cgi-bin/cvename.cgi?name=CVE-2010-4015
Feature safe:   yes
Approved by:    portmgr
Original commit
Friday, 31 Dec 2010
09:56 mm search for other commits by this committer
- Update to 8.4.6
- Unify ICU handling

PR:             ports/153245
Approved by:    maintainer (timeout)
Original commit
Thursday, 16 Dec 2010
18:47 bapt search for other commits by this committer
- Prepare for devel/icu4 deletion
- fix py-icu with icu4.6
- fix portsgresql*server with icu 4.6
- remove now useless icu patch from webkit
Original commit
Wednesday, 15 Dec 2010
11:37 bapt search for other commits by this committer
Chase devel/icu upgrade
Add an updating note
Original commit
Thursday, 9 Dec 2010
16:10 mm search for other commits by this committer
- Fix build if WITH_ICU or WITH_ICU4 defined (bsd.autotools.mk update)

Approved by:    portmgr (pav)
Original commit
Saturday, 4 Dec 2010
07:34 ade search for other commits by this committer
Sync to new bsd.autotools.mk
Original commit
Monday, 22 Nov 2010
19:21 sunpoet search for other commits by this committer
- Use dirrmtry on share/postgresql/tsearch_data for postgresql{83|84|90}-server
- Bump PORTREVISION

PR:             ports/151882
Submitted by:   sunpoet (myself)
Approved by:    girgen (maintainer timeout, 20 days)
Original commit
Sunday, 21 Nov 2010
23:48 rene search for other commits by this committer
- Fix optional dependency on security/heimdal
- Bump PORTREVISION
PR:             ports/152029
Submitted by:   Joerg Pulz [Joerg.Pulz frm2.tum.de]
Approved by:    Ryan Steinmetz <rpsfa@rit.edu> (maintainer of net/freeradius*)
                girgen (maintainer of databases/postgresql*-server,
                        14 day timeout)
Original commit
Saturday, 16 Oct 2010
11:52 ade search for other commits by this committer
Punt autoconf267->autoconf268
Original commit
Thursday, 7 Oct 2010
06:58 girgen search for other commits by this committer
Update all PostgreSQL ports to latest versions.

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
Original commit
Wednesday, 6 Oct 2010
10:56 mm search for other commits by this committer
- fix autoconf limitation in configure.in if WITH_ICU or WITH_ICU4 are used

PR:             ports/151066, ports/150635
Approved by:    maintainer (timeout in ports/150635)
Original commit
Wednesday, 15 Sep 2010
18:35 ade search for other commits by this committer
Autotools update.   Read ports/UPDATING 20100915 for details.

Approved by:    portmgr (for Mk/bsd.port.mk part)
Tested by:      Multiple -exp runs
Original commit
Thursday, 5 Aug 2010
21:37 mm search for other commits by this committer
Fix build with ICU4 option after ICU 4.4 update

PR:             ports/148837
Approved by:    maintainer (timeout)
Original commit
Sunday, 13 Jun 2010
08:40 erwin search for other commits by this committer
BROKEN should not be quoted.
No functional change.
Original commit
Saturday, 5 Jun 2010
11:04 girgen search for other commits by this committer
Fix package list
Original commit
Wednesday, 2 Jun 2010
10:16 girgen search for other commits by this committer
Fix broken plist
PR: ports/147312
Original commit
Monday, 31 May 2010
02:01 ade search for other commits by this committer
Bounce PORTREVISION for gettext-related ports.  Have fun, ya'll.
Original commit
Sunday, 30 May 2010
18:00 pav search for other commits by this committer
- Mark client port broken - leaves files behind on deinstall

Reported by:    pointyhat
Original commit
Thursday, 20 May 2010
15:43 girgen search for other commits by this committer
Update all PostgreSQL ports to latest version.

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
Original commit
Thursday, 25 Mar 2010
22:58 mm search for other commits by this committer
- Add ICU 4.x support
- Bump PORTREVISION

PR:             ports/143841
Submitted by:   Andrei Lavreniyuk <andy.lavr@reactor-xg.kiev.ua>
Approved by:    maintainer (timeout)
Original commit
21:47 delphij search for other commits by this committer
Update to 8.4.3.

PR:             ports/144863
Submitted by:   Alexander <alp rsu ru>
Security:       e050119b-3856-11df-b2b2-002170daae37
With hat:       ports-security@
Original commit
Wednesday, 3 Feb 2010
15:09 girgen search for other commits by this committer
Reintegrate the patch for ICU (unicode support).
Original commit
Monday, 4 Jan 2010
20:37 ale search for other commits by this committer
PTHREAD_[CFLAGS|LDFLAGS] are already set in CONFIGURE_ENV.

Approved by:    portmgr and maintainer timeout (1 month)
Original commit
20:29 ale search for other commits by this committer
Don't link unneeded PTHREAD_LIBS. This fixes php extensions and apache modules.

Approved by:    portmgr and maintainer timeout (1 month)
Original commit
Thursday, 17 Dec 2009
16:07 mm search for other commits by this committer
- Update to 8.4.2

Security:       CVE-2009-4034
Security:       CVE-2009-4136
Security:      
http://portaudit.freebsd.org/e7bc5600-eaa0-11de-bd9c-00215c6a37bb.html
PR:             ports/141639
Submitted by:   Alexander Pyhalov <alp@rsu.ru>
Approved by:    ports-security (delphij)
Original commit
Wednesday, 2 Dec 2009
22:21 mm search for other commits by this committer
- Update to 8.4.1
- Set INTDATE on as default (this is default by PostgreSQL)

PR:             ports/139277
Submitted by:   Olli Hauer <ohauer@gmx.de>
Approved by:    maintainer timeout (2 months)
Original commit
Wednesday, 8 Jul 2009
20:31 girgen search for other commits by this committer
Fix broken pkg-plist for gettext files.

Also, inform about pg_standby rather than autovacuum. [1]

PR:     136468 [1]
Original commit

Number of commits found: 101 (showing only 100 on this page)

1 | 2  »