<feed xmlns='http://www.w3.org/2005/Atom'>
<title>ports/databases/postgresql84-server/files, branch release/6.0.0</title>
<subtitle>FreeBSD ports tree</subtitle>
<id>https://cgit-dev.freebsd.org/ports/atom?h=release%2F6.0.0</id>
<link rel='self' href='https://cgit-dev.freebsd.org/ports/atom?h=release%2F6.0.0'/>
<link rel='alternate' type='text/html' href='https://cgit-dev.freebsd.org/ports/'/>
<updated>2005-10-16T07:41:55Z</updated>
<entry>
<title>This commit was manufactured by cvs2svn to create tag 'RELEASE_6_0_0'.</title>
<updated>2005-10-16T07:41:55Z</updated>
<author>
<name>cvs2svn</name>
<email>cvs2svn@FreeBSD.org</email>
</author>
<published>2005-10-16T07:41:55Z</published>
<link rel='alternate' type='text/html' href='https://cgit-dev.freebsd.org/ports/commit/?id=40a3261d1a6e2617f6afde0cd6d762a7e211af7a'/>
<id>urn:sha1:40a3261d1a6e2617f6afde0cd6d762a7e211af7a</id>
<content type='text'>
</content>
</entry>
<entry>
<title>Upgrade PostgreSQL to 8.0.2. Here's the brief release note:</title>
<updated>2005-04-13T23:15:49Z</updated>
<author>
<name>Palle Girgensohn</name>
<email>girgen@FreeBSD.org</email>
</author>
<published>2005-04-13T23:15:49Z</published>
<link rel='alternate' type='text/html' href='https://cgit-dev.freebsd.org/ports/commit/?id=763de9d278b9b9f456337dfb5abee68f4358669a'/>
<id>urn:sha1:763de9d278b9b9f456337dfb5abee68f4358669a</id>
<content type='text'>
  Over the past several weeks, Tom Lane has been working on replacing
  our old Cache Management Alorithm (ARC) with a new, patent free one
  (2Q).

  In order to reduce the number of 8.x deployments out there that are
  using the old manager, we have just released 8.0.2, and encourage
  adminstrators to upgrade at their earliest convience.

  For those already running 8.x on your production servers, please
  note that this upgrade does *NOT* require a dump restore, but due to
  a bump in the major version number for the client library (libpq),
  it *WILL* require all client applications to be recompiled at the
  same time.

For full release info, see
http://www.postgresql.org/docs/8.0/static/release.html#RELEASE-8-0-2

Apart from the upgrade, three new config options are added:

 A patch (experimental) for supporting proper collation
 of utf-8 encoded locales, using IBM's ICU package (devel/icu). See
 http://people.freebsd.org/~girgen/postgresql-icu/README.html for more
 info.

 An optional patch written by Evgen Potemkin, which allows
 PostgreSQL to make hierarchical queries à la Oracle [1].

 An option is added that allows the use of 64 bit ints to
 store dates [2].

PR: ports/79165 [1], ports/76999 [2]
Submitted by: Marcos Tischer Vallim [1], Christian Ullrich [2]
Approved by: ade, seanc (implicit)
</content>
</entry>
<entry>
<title>Modify 8.0's startup script to simulate a full login (su -l) [1]. Also</title>
<updated>2005-03-19T03:51:45Z</updated>
<author>
<name>Palle Girgensohn</name>
<email>girgen@FreeBSD.org</email>
</author>
<published>2005-03-19T03:51:45Z</published>
<link rel='alternate' type='text/html' href='https://cgit-dev.freebsd.org/ports/commit/?id=75063741266f3fd43477a6ac526b36c2899c0108'/>
<id>urn:sha1:75063741266f3fd43477a6ac526b36c2899c0108</id>
<content type='text'>
add support to select login class for running postgresql [2].

The new startup script, using rc.subr, is now installed for all
versions of postgresql. Bump portrevisions, since startup script is
modified.

PR:		78630 [1]
Submitted by:	Vivek Khera [1]
Submitted by:	Brian B. [2]
Approved by:	seanc (implicit)
</content>
</entry>
<entry>
<title>Fixing problems with the recent security patch: When bison was not</title>
<updated>2005-02-20T05:38:24Z</updated>
<author>
<name>Palle Girgensohn</name>
<email>girgen@FreeBSD.org</email>
</author>
<published>2005-02-20T05:38:24Z</published>
<link rel='alternate' type='text/html' href='https://cgit-dev.freebsd.org/ports/commit/?id=11c6621cb5e7fd88c084d69472323f3fa5d8c8e7'/>
<id>urn:sha1:11c6621cb5e7fd88c084d69472323f3fa5d8c8e7</id>
<content type='text'>
installed, the patched gram.y file would not be used and the security
patch would be a no-op. Also, I've had reports of compilation errors
related to bison.

Since checking for the correct version of bison is hard and error
prone, I'm doing what the postgresql distribution does - patching the
yacc:ed .c file to get rid of the building dependency.

Bumping portrevision of -server.

Pointy hat to:	me
Noticed by:	Mike Harding and others
Security:	http://www.vuxml.org/freebsd/6b4b0b3f-8127-11d9-a9e7-0001020eed82.html
Approved by:	seanc (implicit)
</content>
</entry>
<entry>
<title>Fix security alert using a patch from PostgreSQL's CVS repository:</title>
<updated>2005-02-19T12:07:46Z</updated>
<author>
<name>Palle Girgensohn</name>
<email>girgen@FreeBSD.org</email>
</author>
<published>2005-02-19T12:07:46Z</published>
<link rel='alternate' type='text/html' href='https://cgit-dev.freebsd.org/ports/commit/?id=9c89540227221ee9001868542fa9f8e5bdceae53'/>
<id>urn:sha1:9c89540227221ee9001868542fa9f8e5bdceae53</id>
<content type='text'>
  Prevent overrunning a heap-allocated buffer if more than 1024
  parameters to a refcursor declaration are specified. This is a
  minimally-invasive fix for the buffer overrun.

Define LATEST_LINK to avoid package name clashes between the different
branches of PostgreSQL. [1] (Since postgresql-tcltk is hardwired to
branch 7.4, keep its LATEST_LINK to a generic value.)

Set UNIQUENAME and let it be the same for server &amp; client, so each
branch's ports will share the same options file. This adds some no-op
knobs to the -client port, but IMO it is better this way.

Add space inside paranthesis in OSVERSION conditional to work around
(ancient) make bug. [2]

Remove the Rendez-Vouz knob for 8.0 since I can't find the software
needed to even compile it on FreeBSD.

Bump portrevision (for -server only).

Noted by:	kris [1]
PR:		ports/77530 [2]
Security:	http://www.vuxml.org/freebsd/6b4b0b3f-8127-11d9-a9e7-0001020eed82.html
Approved by:	seanc (mentor)
</content>
</entry>
<entry>
<title>The postgresql_* knobs from /etc/rc.conf where read too late to</title>
<updated>2005-02-15T00:30:50Z</updated>
<author>
<name>Palle Girgensohn</name>
<email>girgen@FreeBSD.org</email>
</author>
<published>2005-02-15T00:30:50Z</published>
<link rel='alternate' type='text/html' href='https://cgit-dev.freebsd.org/ports/commit/?id=e2621de6a142d8847c3892e4ad32ad83300ea268'/>
<id>urn:sha1:e2621de6a142d8847c3892e4ad32ad83300ea268</id>
<content type='text'>
actually make a difference.

Noticed by:	Salvatore Montefusco, Brian B.
Approved by:	ade (mentor)
</content>
</entry>
<entry>
<title>Say hello to postgresql-8.0. Some of the highlights of the new version</title>
<updated>2005-01-31T00:36:16Z</updated>
<author>
<name>Palle Girgensohn</name>
<email>girgen@FreeBSD.org</email>
</author>
<published>2005-01-31T00:36:16Z</published>
<link rel='alternate' type='text/html' href='https://cgit-dev.freebsd.org/ports/commit/?id=dde08c696b7fdee8c17225a61fb9959886ae5d6d'/>
<id>urn:sha1:dde08c696b7fdee8c17225a61fb9959886ae5d6d</id>
<content type='text'>
are savepoints (within transactions), point-in-time recovery and
tablespaces. Check out the release notes and the shiny new
PostgreSQL.org website at:

http://www.PostgreSQL.org/docs/8.0/static/release.html#RELEASE-8-0

The port uses the new postgresql ports' layout and is split into a
server and a client part. The following knobs can be used by ports
depending on PostgreSQL:

# USE_PGSQL     - Add PostgreSQL client dependency.
#                 If no version is given (by the maintainer via the port or
#                 by the user via defined variable), try to find the
#                 currently installed version.  Fall back to default if
#                 necessary (PostgreSQL-7.4 = 74).
# DEFAULT_PGSQL_VER
#               - PostgreSQL default version. Can be overridden within a port.
#                 Default: 74.
# WANT_PGSQL_VER
#               - Maintainer can set an arbitrary version of PostgreSQL by
#                 using it.
# BROKEN_WITH_PGSQL
#               - This variable can be defined if the ports doesn't support
#                 one or more versions of PostgreSQL.

PR:		75344
Approved by:	portmgr@ (kris), ade &amp; sean (mentors)
</content>
</entry>
<entry>
<title>Another step along the road to the postgresql new world order.</title>
<updated>2004-11-23T19:15:12Z</updated>
<author>
<name>Ade Lovett</name>
<email>ade@FreeBSD.org</email>
</author>
<published>2004-11-23T19:15:12Z</published>
<link rel='alternate' type='text/html' href='https://cgit-dev.freebsd.org/ports/commit/?id=03e63e3bdbb7e407689c7729c740d54a32bfd7a3'/>
<id>urn:sha1:03e63e3bdbb7e407689c7729c740d54a32bfd7a3</id>
<content type='text'>
Note that none of these ports are (yet) hooked into the tree,
and will not compile unless you set a specific environmental
variable.  This should be warning enough to leave well alone
for now :)

Submitted by:	maintainer
</content>
</entry>
<entry>
<title>- Add note that the function "elog" has been removed from</title>
<updated>2004-02-01T15:05:44Z</updated>
<author>
<name>Kirill Ponomarev</name>
<email>krion@FreeBSD.org</email>
</author>
<published>2004-02-01T15:05:44Z</published>
<link rel='alternate' type='text/html' href='https://cgit-dev.freebsd.org/ports/commit/?id=cf746e92c2e752397b296eb552f020c60bf45e42'/>
<id>urn:sha1:cf746e92c2e752397b296eb552f020c60bf45e42</id>
<content type='text'>
  pg-7.4

PR:		ports/62167
Submitted by:	maintainer
</content>
</entry>
<entry>
<title>Maintainer update to PostgreSQL 7.4.1.  This release includes fixed ident</title>
<updated>2003-12-25T10:55:39Z</updated>
<author>
<name>Sean Chittenden</name>
<email>seanc@FreeBSD.org</email>
</author>
<published>2003-12-25T10:55:39Z</published>
<link rel='alternate' type='text/html' href='https://cgit-dev.freebsd.org/ports/commit/?id=b919b91069c1ba6836d4dff773524b7963f1a185'/>
<id>urn:sha1:b919b91069c1ba6836d4dff773524b7963f1a185</id>
<content type='text'>
authentication support for FreeBSD (been broken since 7.4).  Merry
Christmas to all, and to all a good night.

Release notes:
http://developer.postgresql.org/docs/postgres/release.html#RELEASE-7-4-1

Prompted by PR:	ports/60542
Obtained from:	maintainer
</content>
</entry>
</feed>
