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.3.7:
* Prevent possible loss of committed transactions during crash.
PR: 71179
Submitted by: SUGIMURA Takashi <sugimura@jp.FreeBSD.org>
Reviewed by: Palle Girgensohn <girgen@pingpong.net> (maintainer)
[PATCH] databases/postgresql73: update to 7.3.6
* Revert erroneous changes in rule permissions checking
* Repair incorrect order of operations in GetNewTransactionId()
* Ensure configure selects -fno-strict-aliasing even when an
external value for CFLAGS is supplied
* Make pg_restore handle 64-bit off_t correctly
* Make contrib/dblink not assume that local and remote type OIDs
match (Joe)
* Quote connectby()'s start_with argument properly (Joe)
* Don't crash when a rowtype argument to a plpgsql function is NULL
* Avoid generating invalid character encoding sequences in corner
cases when planning LIKE operations
* Ensure text_position() cannot scan past end of source string in
multibyte cases (Korea PostgreSQL Users' Group)
* Fix index optimization and selectivity estimates for LIKE
operations on bytea columns (Joe)
This version, as with most minor versions, does not require
a dump/reload to put into place.
PR: ports/63698
Submitted by: Palle Girgensohn <girgen@pingpong.net>
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.
[MAINTAINER] databases/postgresql73: wrong MD5_FILE for subports
Just realized that after the repo-copy, the MD5_FILE pointer for
subports was never updated.
PR: ports/61193
Submitted by: Palle Girgensohn <girgen@pingpong.net>