PostgreSQL is a sophisticated Object-Relational DBMS, supporting
almost all SQL constructs, including subselects, transactions, and
user-defined types and functions. It is the most advanced open-source
database available anywhere. Commercial Support is also available.
The original Postgres code was the effort of many graduate students,
undergraduate students, and staff programmers working under the direction of
Professor Michael Stonebraker at the University of California, Berkeley. In
1995, Andrew Yu and Jolly Chen took on the task of converting the DBMS query
language to SQL and created a new database system which came to known as
Postgres95. Many others contributed to the porting, testing, debugging and
enhancement of the Postgres95 code. As the code improved, and 1995 faded into
memory, PostgreSQL was born.
PostgreSQL development is presently being performed by a team of Internet
developers who are now responsible for all current and future development. The
development team coordinator is Marc G. Fournier (scrappy@PostgreSQL.ORG).
Support is available from the PostgreSQL developer/user community through the
support mailing list (questions@PostgreSQL.ORG).
PostgreSQL is free and the complete source is available.
WWW: http://www.postgresql.org/
Split the postgresql ports into a server and a client part. Hence,
remove this port. Please see UPDATING for more info.
PR: 75344
Approved by: portmgr@ (kris), ade & sean (mentors)
Clean up handling of locale directories at deinstall-time:
* Don't remove "system directories" (which were created by BSD.*.dist)
* Silently try to remove locale directories which we might have created
Update postgresql 7.3.7 -> 7.3.8 and 7.4.5 -> 7.4.6 due to security
advisories in http://www.postgresql.org/news/234.html
Note that postgresql 7.2.x is NOT being updated here since it is
due for termination real soon now.
Submitted by: maintainer, also referenced in ports/73142 (no patch)
- update to version 7.4.5:
* Prevent possible loss of committed transactions during crash
* Repair possible crash during concurrent btree index insertions
PR: 71176
Submitted by: SUGIMURA Takashi <sugimura@jp.FreeBSD.org>
Reviewed by: Palle Girgensohn <girgen@pingpong.net> (maintainer)
Update to latest release 7.4.2.
Release notes available at http://www.postgresql.org/news/173.html
NOTICE: unlike most minor versions, this version does require
some updates to the pg_* system tables. Full instructions for
how to do this are included in the full HISTORY file.
DO NOT UPGRADE WITHOUT READING THESE INSTRUCTIONS.
SIZEfy.
Submitted by: Palle Girgensohn <girgen@pingpong.net> (maintainer)
PR: 64105
Update the PostgreSQL ports to use the KRB5_HOME variable instead of
LOCALBASE to find krb5-config in the MIT case.
Prodded by: Our friendly folks at the ISC who want to use FreeBSD's
PostgreSQL ports instead of an unmanaged build from a tarball.
Remove the PORTNAME from postgreql-client. PORTNAME is set by
MASTERDIR/Makefile[1]. Improve the CONFLICTS messages[2]. Fix the DEPENDS
so that MIT krb5 depends on security/krb5, not heimdal[3]. Add a file that
was missing in the upgrade that has PostgreSQL log to syslog by default[4].
PR: [4] Originally submitted in ports/59402
Submitted by: [1,2,4] maintainer
[3] keoki seu <keoki@camelot.physics.wm.edu>
Update to 7.3.4
"In order to address a potentially serious (although rare)
server startup failure that was recently reported, we have
released PostgreSQL version 7.3.4. This release is critical
for users of PostgreSQL version 7.3.3, and highly recommended
for all other PostgreSQL users."
Submitted by: Palle Girgensohn <girgen@pingpong.net> (maintainer)
PR: 55354
The control script that ships with the postgres
port (files/pgsql.sh.tmpl) lacks a parameter in the
restart option, causing logs to be send to stdout,
instead of the log file.
Submitted by: Fernando Schapachnik <fernando@mecon.gov.ar>
Approved by: maintainer
PR: 53142
Approved by: fjoe (implicit)
Update to 7.3.3.
1. Optionally link with libc_r to get plpython working. [1]
2. Fix kerberos build. [2]
3. There was a duplication of some declarations. [3]
PR: ports/52851
PR: ports/51080 [2]
Submitted by: Mike Meyer <mwm@mired.org> [1]
Submitted by: Gerweck <andy@tacnode.com> [2]
Pointed out by: Mike Harding <mvh@ix.netcom.com> [3]
Submitted by: Palle Girgensohn <girgen@pingpong.net> (maintainer)
Add patch for a fix for braindead applications that were depending on
atoi('') (ex: RT and Horde). While I'm here, de-"pkg-comment"-ify. Port
revision bump.
Submitted by: Larry Rosenman <ler@lerctr.org>
Approved by: maintainer
Add a patch fix a long standing bug in PostgreSQL with LISTEN/NOTIFY
queues and shutting down the database. Not bumping port revision, but if
you are having problems related to the above, update as necessary.
Submitted by: Larry Rosenman <ler@lerctr.org>
Update PostgreSQL to the maintenance release 7.3.2.
Fixes numerous bugs especially with various interface libraries and
pg_dump. All users are advised to upgrade. This update fixes all known
problems with the postgresql7 port. See release notes for details:
http://developer.postgresql.org/docs/postgres/release-7-3-2.html
A dump/restore is *not* required when upgrading to this version.
PR: ports/47983 [1], ports/47284 [2], ports/47808 [3]
Submitted by: maintainer [1]
Jason C. Wells [2]
Michel Oosterhof <m.oosterhof@xs4all.nl> [3]
Download the PostgreSQL documentation and MD5 for the test bundle. These
should ideally be downloaded as needed to save bandwidth.
Submitted by: Eric Hodel
Update PostgreSQL to 7.3.1[1]. Fixes builds for spac64. Many speed,
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
Update to 7.2.3 and maintainer's email address. All advised to update
to this version as soon as possible. Check PR description.
PR: ports/43676
Submitted by: maintainer
Update to 7.2.2, which fixes several security bugs. Do not install
documentation--it will be in a separate port.
PR: 42009
Submitted by: Palle Girgensohn (maintainer)
Forbid because of unconfirmed security bugs:
The following buffer overruns have been identified and
addressed [in 7.2.2]:
* in handling long datetime input
* in repeat()
* in lpad() and rpad() with multibyte
* in SET TIME ZONE and TZ env var
Fix build on -CURRENT:
* The compiler in -CURRENT now complains if you precede -I/usr/include
with -I... . The same applies to -I/usr/lib .
* The distribution's configure file treats the compiler's unexpected
warning message as a failure and errors out.
Maintainer notified in private mail.
gettext upgrade uber-patch (stage 3)
- switch devel/gettext (0.11.1) on, installing full package
- flip devel/gettext-old (0.10.35) to installing only static binaries
with a "-old" suffix -- gettext-old will have its deorbit burn
sequence initiated just after 4.6-RELEASE
- fix up ports for the new world order
Reviewed by: portmgr
Fix some bitrot for the non-default case of WITH_GETTEXT -- lib-depend
on -lintl instead of build-depending on msgfmt and make sure -lintl is
linked into the shared -lpq.
Approved by: maintainer
Work around the way in which the package building cluster validates ports by
defining LIB_DEPENDS for the BATCH defaults in the Makefile. The dynamic
determination of LIB_DEPENDS in configure.postgresql remains in place for the
!BATCH case and is unaffected by this.
The configure script *must* run pre-fetch, since the dependencies are checked
in the fetch target. Before the patch below, make install will fail to depend
on Tcl/Tk, for instance.
Change the way the configure script is executed and included in order to make
dependencies work. Call the script pre-fetch and include Makefile.inc AFTER it
has been created.
Fix problems when installing postgresql7 with pkg_add: - pkg-install used
wrong uid# - chown lib dir *after* it is created - pkg-install created data
dir where Makefile didn't - add pkg-deinstall and remove user & group -
don't chown data dir, since we don't create it anymore - spell and
documentation fixes in the rc.d script
Do not set the shell for user "pgsql" to `/bin/nologin' at package install
time: this breaks the rc.d script. Default to `/bin/sh' as a `make install'
would do.
