| Commit message (Collapse) | Author | Age | Files | Lines |
|
|
|
| |
-> 2.62
|
|
|
|
|
| |
PR: ports/126773
Submitted by: Robert Schulze
|
|
|
|
| |
Tested by: exp build run (erwin)
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
Updates for all maintained versions of PostgreSQL are available today:
8.3.3, 8.2.9, 8.1.13, 8.0.17 and 7.4.21. These releases fix more than
two dozen minor issues reported and patched over the last few months.
All PostgreSQL users should plan to update at their earliest
convenience. People in affected time zones, in particular, should
upgrade as soon as possible.
Release Notes:
http://www.postgresql.org/docs/8.3/static/release.html
Also, fix umask error in periodic script [1].
PR: ports/124457 [1]
Submitted by: Alexandre Perrin
|
|
|
|
|
|
|
|
|
|
| |
The affected ports are the ones with gettext as a run-dependency
according to ports/INDEX-7 (5007 of them) and the ones with USE_GETTEXT
in Makefile (29 of them).
PR: ports/124340
Submitted by: edwin@
Approved by: portmgr (pav)
|
| |
|
| |
|
|
|
|
|
| |
HIER patch's web site has disappeared. Put the patches on freefall
until I can get hold of the author.
|
|
|
|
|
|
| |
The packages for 6.3R on sparc64 were actually built using this.
Hat: portmgr
|
| |
|
|
|
|
|
|
|
| |
This includes a bunch of security fixes: CVE-2007-6067, CVE-2007-4772,
CVE-2007-6601, CVE-2007-6600 and CVE-2007-4769.
Security: http://www.postgresql.org/about/news.905
|
|
|
|
|
| |
PR: 117086
Tested by: -exp runs
|
| |
|
|
|
|
|
| |
PR: ports/116639
Submitted by: aDe
|
|
|
|
| |
PR: ports/104075
|
|
|
|
|
| |
- Set X11BASE to ${LOCALBASE} for recent ${OSVERSION}.
- Bump PORTREVISION for ports intalling files in ${X11BASE}.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
The PostgreSQL Global Development Group has released updated versions
for PostgreSQL 8.2 and all back versions to patch a privilege
escalation exploit in SECURITY DEFINER functions. All users of this
feature are urged to update to the latest minor version and follow
instructions on securing these functions as soon as possible. This
minor release also contains other fixes, so all users should plan to
deploy it.
Once you have updated, additional steps are required to secure your
database against the exploit. Please read the release notes at
http://www.postgresql.org/docs/8.2/static/release.html and the
TechDocs article at http://www.postgresql.org/docs/techdocs.77 on how
to lock down your security definer functions, if you use them.
As always, application of a minor release does not require a dump and
reload of the database.
The frequency of security fixes recently is a result of increased
scrutiny of the PostgreSQL code by government agencies and
security-conscious companies. Rapid turnaround on security patches
is key to keeping PostgreSQL the most secure SQL database. Your work
and vigilance in applying the latest security updates ensures that
there will never be a PostgreSQL "worm".
http://www.postgresql.org/docs/8.2/static/release-8-2-4.html
http://www.postgresql.org/docs/8.1/static/release.html#RELEASE-8-1-9
http://www.postgresql.org/docs/8.0/static/release.html#RELEASE-8-0-13
http://www.postgresql.org/docs/7.4/static/release.html#RELEASE-7-4-17
http://www.postgresql.org/docs/techdocs.77
Security: http://cve.mitre.org/cgi-bin/cvename.cgi?name=CVE-2007-2138
|
|
|
|
| |
Approved by: maintainer timeout (1 month)
|
|
|
|
|
|
| |
The recent security release (8.0.11, 8.1.7, 8.2.2) has been withdrawn.
It contained an issue which causes error with custom data types, type
constraints and expression indexes. These upgrades fix the problem.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
A vulnerability allows suppressing the normal checks that a SQL
function returns the data type it's declared to do. These errors can
easily be exploited to cause a backend crash, and in principle might
be used to read database content that the user should not be able to
access. [CVE-2007-0555]
A vulnerability involving changing the data type of a table column
can easily be exploited to cause a backend crash, and in principle
might be used to read database content that the user should not be
able to access. [CVE-2007-0556]
The release includes a set of other fixes as well. Please see the
release information at
http://www.postgresql.org/docs/8.1/static/release.html#RELEASE-8-1-7
Security: http://cve.mitre.org/cgi-bin/cvename.cgi?name=CVE-2007-0555
Security: http://cve.mitre.org/cgi-bin/cvename.cgi?name=CVE-2007-0556
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
Release notes:
http://www.postgresql.org/docs/7.3/static/release.html#RELEASE-7-3-17
http://www.postgresql.org/docs/7.4/static/release.html#RELEASE-7-4-15
http://www.postgresql.org/docs/8.0/static/release.html#RELEASE-8-0-10
http://www.postgresql.org/docs/8.1/static/release.html#RELEASE-8-1-6
http://www.postgresql.org/docs/8.2/static/release-8-2-1.html
The server-side utilities of postgresql (initdb, initlocation,
ipcclean, pg_controldata, pg_ctl, pg_id and pg_resetxlog) are now
installed by the respective postgresql*-server port (previously they
where installed with the client). If you update the client, you should
also update the server to make sure you are not left without the
server-side tools. Do something like:
portupgrade postgresql-client postgresql-server
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
Release notes:
8.1.5 http://www.postgresql.org/docs/8.1/static/release.html#RELEASE-8-1-5
8.0.9 http://www.postgresql.org/docs/8.0/static/release.html#RELEASE-8-0-9
7.4.14 http://www.postgresql.org/docs/7.4/static/release.html#RELEASE-7-4-14
7.3.16 http://www.postgresql.org/docs/7.3/static/release.html#RELEASE-7-3-16
Change name of the rc script from '010.pgsql.sh' to 'postgresql'
Add optional hierachy patch added for 7.4 and 8.1 ports.
Chase heimdal libs update [reported by several]
For 8.1+ the port enables autovacuum in ~pgsql/postgresql.conf when
running initdb
Cleanup the ports, moving pkg-message-* to files/pkg-message-*.in and
files/pgsql.sh.tmpl to files/postgresql.in. [ports/97767]
PR: ports/97767, submitted by delphij@FreeBSD.org
|
|
|
|
| |
Update the patches to handle ICU version 3.6 and fall back to 3.4.
|
|
|
|
|
| |
Pointed out by: Penty Wenngren <penty.wenngren@dgc.se>
Pointy hat to: me
|
|
|
|
| |
It now links with icu-3.6 as well as the earlier versions.
|
|
|
|
|
| |
Otherwise there could be problems with the service not starting up in the
case when owner of the file has been changed.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
The PostgreSQL Global Development Group today released versions 8.1.4, 8.0.8,
7.4.13 and 7.3.15. This is an urgent update to close a security hole which
can permit a SQL injection attack on some applications running PostgreSQL.
Users are urged to apply the update as soon as reasonably possible. Since the
update affects client functionality, most driver projects will be updating
this week as well.
Because the security issue involved is complex, we have added a section in
Techdocs to explain it: http://www.postgresql.org/docs/techdocs.52. Please
read this first before applying the updates.
Also, fix rc_subr startup problems on FreeBSD-7.x.
Security: http://www.postgresql.org/docs/techdocs.50
PR: ports/95154
|
|
|
|
|
|
|
| |
We have not checked for this KEYWORD for a long time now, so this
is a complete noop, and thus no PORTREVISION bump. Removing it at
this point is mostly for pedantic reasons, and partly to avoid
perpetuating this anachronism by copy and paste to future scripts.
|
|
|
|
|
|
|
| |
Release Note: http://www.postgresql.org/docs/8.1/static/release.html#RELEASE-8-1-3
PR: ports/93440
Submitted by: Hirohisa Yamaguchi <umq@ueo.co.jp>
|
| |
|
|
|
|
|
| |
Approved by: krion@
PR: ports/88711 (related)
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
A critical fix repairs an error in ReadBuffer that can cause data loss
due to overwriting recently-added pages. This applies to the 8.1 and
8.0 branches on all platforms.
Note that this update might require a reindex of textual columns under
certain conditions; please see UPDATING.
Other fixes included are:
-- Character string locale comparison bug. This may require a REINDEX
on text column indexes in some locales, such as Hungarian.
-- Prevent accidental changes of locale by plperl
-- Two fixes for Japanese encodings
-- Two fixes for COPY CSV
-- Fixes for functions returning RECORD
-- Fixes to autovacuum, dblink and pgcrypto
|
|
|
|
|
|
| |
so as to fully install everything needed for pgxs to work correctly.
Approved by: maintainer
|
|
|
|
|
|
|
|
|
|
| |
"start" when booting, since there's no need waste time checking for
running processes when the OS is starting up.
Bumping portrevision.
PR: 90884
Submitted by: Victor Snezhko <snezhko@indorsoft.ru>
|
|
|
|
|
| |
Submitted by: Hirohisa Yamaguchi <umq@ueo.co.jp>
PR: 90443
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
in bsd.autotools.mk essentially makes this a no-op given that all the
old variables set a USE_AUTOTOOLS_COMPAT variable, which is parsed in
exactly the same way as USE_AUTOTOOLS itself.
Moreover, USE_AUTOTOOLS has already been extensively tested by the GNOME
team -- all GNOME 2.12.x ports use it.
Preliminary documentation can be found at:
http://people.FreeBSD.org/~ade/autotools.txt
which is in the process of being SGMLized before introduction into the
Porters Handbook.
Light blue touch-paper. Run.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
installed from ports. The base heimdal distribution installs libraries
that have no depenency information. While this is quite correct, it
means that each library that links with libpq.so must also know if
libpq.so is linked with libkrb.so et al. Problem is, there's no good
way to get this information (pg_config has a --libs option starting at
version 8.1) and all ports using postgresql must be changed to make it
possible to link with a libpq.so that was configured to use the
Kerberos implementation installed in /usr by default. Hence, we
require one of the ports (heimdal or krb5) if postgresql is to be
linked with Kerberos. At least for now, until we can fix this in some
better way.
Also, if MIT Kerberos (security/krb5) is installed, users should
ideally remove the base heimdal installation so linkers will not pick
it up in preference to the krb5 libs (base heimdal has higher version
numbers than krb5 port).
PR: 80869, 88098, 85178
|
|
|
|
| |
Pointed out by: Vivek Khera <vivek@khera.org>
|
|
|
|
|
|
| |
HIER option.
Pointed out by: Reko Turja <reko.turja@liukuma.net>
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
The new release includes performance improvements and advanced SQL
features which will support bigger data warehouses, higher-volume
transaction processing, and more complex distributed enterprise
software.
Major new features in this release include:
Roles:
PostgreSQL now supports database roles, which simplify the
management of large numbers of users with complex
overlapping database rights.
IN/OUT Parameters:
PostgreSQL functions now support IN, OUT and INOUT
parameters, which substantially improves support of complex
business logic for J2EE and .NET applications.
Two-Phase Commit (2PC):
Long in demand for WAN applications and heterogeneous data
centers using PostgreSQL, this feature allows
ACID-compliant transactions across widely separated
servers.
Some Performance Enhancements found in this release include:
Improved Multiprocessor (SMP) Performance:
The buffer manager for 8.1 has been enhanced to scale almost
linearly with the number of processors, leading to significant
performance gains on 8-way, 16-way, dual-core, and multi-core
CPU servers.
Bitmap Scan:
Indexes will be dynamically converted to bitmaps in memory when
appropriate, giving up to twenty times faster index performance
on complex queries against very large tables.
Table Partitioning:
The query planner is now able to avoid scanning whole sections
of a large table using a technique known as Constraint
Exclusion.
Shared Row Locking:
PostgreSQL's "better than row-level locking" now supports even
higher levels of concurrency through the addition of shared
row locks for foreign keys.
For a more complete listing of changes in this release, please see the
Release Notes visible at:
http://www.postgresql.org/docs/current/static/release.html#RELEASE-8-1
|
| |
|
|
|
|
|
|
|
| |
Update the ICU patch with a assert fix, courtesy of Magnus Hagander.
Pointed out by: Marcos Tischer Vallim [ports/84720]
PR: 80377, 84720
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
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)
|
| |
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
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)
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
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)
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
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)
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
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 & 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)
|
|
|
|
|
|
|
| |
actually make a difference.
Noticed by: Salvatore Montefusco, Brian B.
Approved by: ade (mentor)
|
|
|
|
|
| |
Submitted by: Nick Pavlica <linicks at gmail dot com>
Approved by: ade (mentor)
|
|
|
|
| |
Approved by: ade (mentor)
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
the "LOAD" option, the PostgreSQL Global Development Group is
announcing the release of new versions of PostgreSQL.
Update to 7.3.9, 7.4.7 & 8.0.1.
Take the opportunity to reset PORTREVISION of slave ports.
Back out name change of startup script. The new script uses rc.subr(8),
and as such also uses rcorder(8). But, rcorder does not exist in FreeBSD
4.x. Hence rename the script it back to the top of the directory
list. [1]
The periodic script should of course be executable. [2]
[1] Noted by Niels Chr. Bank-Pedersen <ncbp at bank-pedersen dot dk>
[2] Noted by Fritz Heinrichmeyer <fritz.heinrichmeyer at fernuni-hagen dot de>
|
|
|
|
| |
Approved by: seanc (mentor)
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
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 & sean (mentors)
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
stuffing the 8.0.0 release in here for the time being. Port epoch bumped
because 8.0.rc* is greater than 8.0.0. A note from UPDATING to people who
want to use 8.0.0 via -devel in production:
The -devel port has been updated to contain 8.0 release since
postgresql80-server can not be updated until 4.11 is released and the
changes in PR ports/75344 are committed. Users who need 8.0 now can
use the -devel port, however, once postgresql80-server has been
committed, -devel will begin tracking 8.1. Please be smart about
tracking ports and if used in production, update to
databases/postgresql80-server as soon as it becomes available. No
dump/reload will be required when changing from -devel to
postgresql80-server.
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
|
|
|
|
|
|
|
| |
build, so it will not be out the door before the ports freeze.
Meanwhile, modify BROKEN text to something more informative.
Approved by: ade (mentor)
|
|
|
|
| |
Approved by: ade (mentor)
|
|
|
|
|
|
|
|
|
| |
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
|
|
|
|
|
|
|
|
|
| |
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)
|
|
|
|
|
|
|
|
|
| |
* 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)
|
|
|
|
|
| |
PR: ports/68456
Submitted by: maintainer
|
|
|
|
|
| |
Submitted by: Palle Girgensohn <girgen@pingpong.net> (maintainer)
PR: 64933
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
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
|
|
|
|
|
|
| |
PR: 61836
Submitted by: Palle Girgensohn (maintainer)
Pointy hat to: me
|
|
|
|
|
| |
Submitted by: trevor
Tested by: bento
|
|
|
|
|
|
|
| |
pg-7.4
PR: ports/62167
Submitted by: maintainer
|
| |
|
|
|
|
|
|
|
| |
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.
|
|
|
|
|
|
|
|
|
|
|
| |
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
|
|
|
|
|
|
|
|
|
|
| |
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>
|
|
|
|
| |
This fixes INDEX build
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
regarded as a major release with features with interest to those with
large databases. The updates are extensive and the best source of info
is in the release notes. Enjoy and direct questions to database@!
Release notes:
http://www.postgresql.org/docs/7.4/static/release.html#RELEASE-7-4
PR: ports/59403, ports/59404, ports/59393, ports/59394,
ports/59395, ports/59397, ports/59398, ports/59402, &&
ports/59401
Submitted by: maintainer
Approved by: marcus (portmgr@ hat)
|
|
|
|
| |
master/slave clean)
|
|
|
|
| |
Prodded by: kris
|
| |
|
|
|
|
|
|
| |
into right place.
Notify from: Palle Girgensohn <girgen@pingpong.net>
|
|
|
|
|
|
|
|
|
|
|
| |
"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
|
|
|
|
| |
use USE_GETOPT_LONG instead.
|
|
|
|
|
| |
PR: 52867
Submitted by: Palle Girgensohn <girgen@pingpong.net> (maintainer)
|
|
|
|
|
|
|
|
|
|
|
| |
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)
|
|
|
|
|
|
|
| |
Submitted by: osa
Approved by: maintainer
PR: 50397
Approved by: fjoe (implicit)
|
|
|
|
| |
Submitted by: Mike Harding <mvh@ix.netcom.com>
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
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)
|
|
|
|
|
|
|
|
| |
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
|
|
|
|
|
|
|
| |
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>
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
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]
|
|
|
|
|
| |
PR: 47054
Submitted by: Palle Girgensohn <girgen@rambutan.pingpong.net>
|
|
|
|
|
| |
PR: ports/46749, ports/46748
Submitted by: "Sergey A.Osokin" <osa@FreeBSD.org.ru>,Rong-en Fan <rafan@infor.org>
|
|
|
|
|
|
| |
should ideally be downloaded as needed to save bandwidth.
Submitted by: Eric Hodel
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
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
|
|
|
|
|
| |
PR: ports/44983
Submitted by: girgen@pingpong.net
|
|
|
|
|
|
|
| |
to this version as soon as possible. Check PR description.
PR: ports/43676
Submitted by: maintainer
|
|
|
|
| |
Submitted by: fenner's distfiles survey
|
|
|
|
|
|
|
| |
documentation--it will be in a separate port.
PR: 42009
Submitted by: Palle Girgensohn (maintainer)
|
|
|
|
|
|
|
|
|
|
| |
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
|
|
|
|
|
| |
Submitted by: lots and lots
Pointy hat to: ade
|
|
|
|
|
|
|
|
|
|
| |
* 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.
|
|
|
|
|
|
|
|
|
|
| |
- 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
|
|
|
|
|
| |
PR: 36975
Submitted by: maintainer
|
|
|
|
|
|
|
| |
on -lintl instead of build-depending on msgfmt and make sure -lintl is
linked into the shared -lpq.
Approved by: maintainer
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
| |
Move gettext (0.10.35) with gettext-old
Update gettext from gettext-devel (0.10.40)
Remove gettext-devel
Fix dependencies
Stage 2 will involve upgraded gettext to 0.11 and fixing issues
Stage 3 involves a de-orbit burn sequence for gettext-old
Reviewed by: portmgr
|
|
|
|
|
|
|
|
| |
The MAINTAINER has approved this (see ports/35161).
PR: ports/35160
Submitted by: Sean Chittenden <sean@chittenden.org>
Reviewed by: maintainer
|
|
|
|
|
|
| |
PR: 35143
Submitted by: maintainer
Reported & fixed by: olgeni
|
|
|
|
|
| |
PR: ports/34855
Submitted by: maintainer.
|
|
|
|
|
| |
PR: 32755
Submitted by: Palle Girgensohn <girgen@partitur.se>
|
|
|
|
| |
the later case
|
|
|
|
|
| |
PR: 30805
Submitted by: maintainer
|
|
|
|
|
| |
PR: 30022
Submitted by: maintainer
|
|
|
|
|
|
|
|
| |
A note about how to install languages into a PostgreSQL database is added.
PR: ports/29916
Submitted by: Palle Girgensohn <girgen@partitur.se> (MAINTAINER)
Michal Pasternak <doc@lublin.t1.pl> (the note)
|
|
|
|
|
|
|
|
|
|
| |
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.
Remove trailing whitespace and an extraneous LDCONFIG_DIRS.
Submitted by: maintainer
|
|
|
|
|
|
|
|
| |
* Take a stab at removing the pgsql user's home directory on deinstall.
* Only remove man/manl and others when PG_PREFIX is set.
Submitted by: maintainer
|
|
|
|
|
| |
PR: 28120
Submitted by: Palle Girgensohn <girgen@partitur.se>
|
|
|
|
|
|
|
|
|
|
|
| |
checked in the fetch target. Before the patch below, make install will
fail to depend on Tcl/Tk, for instance.
Synchronize the batch and default interactive selections for optional
parts of the port.
PR: ports/27949
Submitted by: Palle Girgensohn <girgen@partitur.se> (MAINTAINER)
|
|
|
|
|
|
|
| |
Add character sets to the server
PR: 27846
Submitted by: Palle Girgensohn <girgen@partitur.se>
|
|
|
|
|
| |
PR: 27846
Submitted by: Palle Girgensohn <girgen@partitur.se>
|
| |
|
|
|
|
|
| |
PR: 27676
Submitted by: Palle Girgensohn <girgen@partitur.se>
|
| |
|
|
|
|
|
| |
PR: 27676
Submitted by: maintainer
|
|
|
|
|
|
|
|
|
| |
to make dependencies work.
Call the script pre-fetch and include Makefile.inc AFTER it has been
created.
Reported by: Disturbed FreeBSD newbie who couldn't figure out
why this didn't work as expected.
|
|
|
|
|
| |
PR: ports/27416
Submitted by: girgen@partitur.se (the maintainer)
|
|
|
|
|
| |
PR: ports/27220
Submitted by: maintainer
|
|
|
|
|
|
|
|
|
| |
* Pass the -s option to pg_ctl, to avoid clobbering the display.
It will show error messages only.
* Echo the port name after shutdown.
No functional changes, no PORTREVISION.
|
|
|
|
|
|
|
| |
it won't be confused with the "ant" screensaver (in /usr/X11R6/bin).
PR: 26841
Submitted by: Palle Girgensohn <girgen@partitur.se>
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
* Move the call to configure.postgresql7 from pre-fetch to pre-extract, so it
won't hang while performing batch fetch operations (like portupgrade -F)
* Add some TCL related files to pkg-plist.tcl, and add a PLIST_SUB in the
Makefile to register the correct tcl version in the plist.
* Do not start postgresql if the database directory does not exist: the
startup sequence could hang because of this.
* Use the "-s" option when starting postgresql with pg_ctl, so it won't
display informational messages. Display only the port name, as do other
packages startup scripts.
Approved by: Palle Girgensohn <girgen@partitur.se>
|
| |
|
| |
|
|
|
|
|
| |
PR: ports/26761
Submitted by: maintainer
|
|
|
|
|
| |
PR: ports/26741
Submitted by: maintainer
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
This would cure headache like apache module linking against libpq
fail to work after rebooting.
Originally, maintainer and I want this commit to go with the
PostgreSQL updating. But we both think that the latest PostgreSQL
would not be released before FreeBSD 4.3-RELEASE ports freeze.
As a conclusion, PORTREVISION bumped.
Discussed with/Submitted by: MAINTAINER
|
|
|
|
|
|
|
|
|
|
|
|
| |
- 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
PR: ports/25817
Submitted by: MAINTAINER
|
|
|
|
|
| |
PR: 25247
Submitted by: maintainer
|
|
|
|
|
|
| |
default database location.
Approved by: maintainer
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
Do not call initdb from Makefile's post-install. Users are required to
manually run initdb, maybe after configuring their preferred database
location in pgsql's user .profile. pkg_add used to simply replace some
existing data files.
Add pkg-message to tell the user about initdb.
Remove 2 empty directories from pkg-plist (pgsql/include/port/freebsd,
pgsql/include/port), since they are not included in "make package" anyway
and cause pkg_deinstall to complain about the plist.
Remove all pgsql/data contents from pkg-plist, so "make deinstall" and
pkg_delete won't clobber existing databases. Minor version upgrades can now be
performed by means of pkg_delete and "make install", without using pg_dump.
Chown %D/pgsql/lib to root:wheel to satisfy ldconfig's recent security
requirements.
Change @dirrm of pgsql to "@unexec rmdir": pkg_deinstall won't complain if
data still exists in that directory at deinstall time.
Approved by: maintainer
|
|
|
|
|
| |
PR: ports/23861
Submitted by: David W. Chapman Jr. <dwcjr@inethouston.net>
|
|
|
|
|
|
|
|
| |
time: this breaks the rc.d script. Default to `/bin/sh' as a `make install'
would do.
PR: ports/23534
Submitted by: Nick Sayer
|
|
|
|
| |
Approved by: asami
|
|
|
|
|
| |
PR: 23371
Submitted by: maintainer
|
|
|
|
| |
would like to maintain this port.
|
|
|
|
|
| |
due to lack of time for maintaining and testing. Maybe
somebody other can do better than I.
|
| |
|
|
|
|
| |
Submitted by: Nadav Eiron <nadav@cs.technion.ac.il>
|
|
|
|
|
|
|
| |
ldconfig: /usr/local/pgsql/lib: ignoring directory not owned by root
during startup.
Submitted by: tobez@tobez.org
|
| |
|
|
|
|
|
|
|
| |
The DB is 64-bit capable so really only a few
bits of configuration for FreeBSD were needed.
Submitted by: Thomas Valentino Crimi <tcrimi+@andrew.cmu.edu>
|
|
|
|
|
|
| |
+LDCONFIG_DIRS= %%PREFIX%%/pgsql/lib
Submitted by: "Chris D. Faulhaber" <jedgar@fxp.org>
|
| |
|
|
|
|
|
|
| |
Fix NOPORTDOCS support.
Fix PLIST in many respects, especially for pgacess.
|
|
|
|
|
|
|
|
|
| |
default encoding.
Still the "default" default encoding is singlebyte, so this shouldn't hurt
anything but a little code increase.
Approved by: andreas (the maintainer)
|
|
|
|
| |
Obtained from: Palle Girgensohn <girgen@partitur.se>
|
|
|
|
|
|
|
|
| |
thanks for complete diffs ;-)
closed PR
PR: 18699
Obtained from: Palle Girgensohn <girgen@partitur.se>
|
| |
|
|
|
|
|
|
| |
closes PR
PR: 17736
|
|
|
|
|
|
|
| |
WITHOUT_FOO. Begin the process of reserving these prefixes for user defined
options.
No comment by: ports
|
|
|
|
|
|
|
|
| |
Postgresql port now can be packaged.
User and group will be created automatically
PR: 17744
Submitted by: Adrian Filipi-Martin <adrian@ubergeeks.com>
|
| |
|
|
|
|
|
|
| |
Upgrade to pgaccess 0.98 follows
PR: 15708 15034
|
| |
|
|
|
|
| |
Submitted by: Donald Chan <donald@batti.com>
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
and..
<quote>
This is a really small fix:
- When compiling postgresql-jdbc, the compilation process presents a
bad path to the installed jar-file.
</quote>
PR: 13838
PR: 13865
Submitted by: Palle Girgensohn <girgen@partitur.se>
|
|
|
|
|
| |
Prompted by PR: 13476, 13477
Submitted by: KATO Tsuguru
|
| |
|
| |
|
|
|
|
| |
chown -> ${CHOWN}
|
|
|
|
|
|
|
| |
maintenance release with bugfixes
Thanks for the complete submission !
Submitted by: Palle Girgensohn <girgen@partitur.se>
|
|
|
|
| |
Submitted by: Gaute Nessan <gaute@Norway.EU.net>
|
| |
|
| |
|
|
|
|
|
|
| |
did some small modifications
Obtained from: "Palle Girgensohn" <girgen@partitur.se>
|
| |
|
|
|
|
|
| |
permitted. Note that, given current numeric motif of PW, this is done
in four equally-sized commits of 393 files each.
|
| |
|
|
|
|
|
| |
upgrades this to the allegedly fantastic 6.5. However, it's the thought
that counts, right?
|
| |
|
| |
|
| |
|
|
|
|
|
|
| |
options "SYSVSHM, SYSVSEM, SYSVMSG"
PR: 6321
|
| |
|
| |
|
| |
|
|
|
|
| |
PR: 9685
|
|
|
|
|
| |
Reviewed by: me
Submitted by: David Kelly <dkelly@nebula.tbe.com>
|
|
|
|
|
|
| |
Start up a /usr/ports/YEAR2000 file to provide a central location for all
software. Will be buildling a nightly run shell script to pull all the Y2K
variables from ports, so that the central list remains reasonably up to date...
|
|
|
|
|
|
| |
PR: ports/8803 (sorta)
Reviewed by: Scrappy (sorta)
Submitted by: billf
|
|
|
|
|
| |
the right place so they will actually be run on the libraries, not some
text files.
|
| |
|
|
|
|
| |
From: Cyrus Rahman <cr@jcmax.com>
|
|
|
|
| |
Submitted by: steve
|
|
|
|
|
|
|
|
|
|
| |
ld -x -Bshareable -Bforcearchive -o libpq.so.1.1 fe-auth.o fe-connect.o fe-exec.o fe-misc.o fe-lobj.o dllist.o pqsignal.o pqcomprim.o
/usr/libexec/elf/ld: unrecognized option `-Bforcearchive'
gmake[2]: *** [libpq.so.1.1] Error 1
gmake[2]: Leaving directory `/usr/ports/databases/postgresql/work/postgresql-6.3.2/src/interfaces/libpq'
gmake[1]: *** [all] Error 2
gmake[1]: Leaving directory `/usr/ports/databases/postgresql/work/postgresql-6.3.2/src/interfaces'
gmake: *** [all] Error 2
|
| |
|
| |
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
Many bugfixes and cosmetic changes
Changes by Scrappy and me
My additional changes:
- had to link libpgtcl.so with the crypt library to get rid of the
pgaccess error message, that crypt is missing
- had to add -i option in the startup script, so that pgaccess is
able to connect to the postmaster process
- removed all unnecessary patches
- updated PLIST
Thanks to the postgresql developement team, who did a great job to
simplify the postgresql port, by applying the patches and making
the autoconf mechanism more consistent.
Submitted by: The Hermit Hacker <scrappy@hub.org>
|
|
|
|
|
| |
I think this is ok'd by Satoshi.
Submitted by: jseger@freebsd.scds.com
|
|
|
|
| |
Please test.
|
| |
|
|
|
|
|
| |
-- we are obviously not interested in keeping the old versions around
in that case.
|
| |
|
| |
|
|
|
|
|
| |
thanks John, for testing the port
Submitted by: John Fiber
|
|
|
|
|
|
|
|
|
| |
background because of the -S option.
- remove the -D datadir option, it's meaningless, because the pgsql
user environment overwrites it with the PGDATA env variable.
Since this is important and might cause some headache, I mentioned
this in ~pgsql/.profile and the startup script.
Submitted by: John Fiber
|
| |
|
|
|
|
|
|
|
| |
Fixed the wrong libpq symlink after "make install".
Updated PLIST.
Have to change pgaccess port now, to load the correct lib after
major minor change.
|
|
|
|
|
|
|
|
|
| |
- in order to access the template1 database as pgsql user, the
environment needs the DISPLAY variable set to at least ":0"
- pgaccess loads dynamically the libpgtcl.1, some symbols from
another dynamic lib are needed as well -> libpq.so.1.0
Makefile (patch-af) modified (copied from the Linux clause),
so that shared lib libpgtcl is created with proper loader flags.
|
|
|
|
|
|
|
| |
for building the tcl/tk based database frontend pgaccess.
For an updated version of this tool a separate port will
follow. Please test these changes well, so that we get a
nice PostgreSQL 6.2 version up and running "b4" port freeze ;-)
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
Please note: when performing a migration to 6.2 and you have an existing db,
then you have to use the *new* pg_dumpall script that comes with this new
postgresql release. The INSTALL file points this out explicitely !!!
Changes:
- startup script resides in FILESDIR
- renamed it to be in sync with INSTALL file from sources
- always install this startup script over an existing, because
of the nature of the rc.d directory I can't install it
to pgsql.sh-dist, if a pgsql.sh is already presend ...
- portlint detected trailing whitespace, usage of perl with absolute
path, usage of echo instead of ECHO and plenty things of this kind
- post installation notes updated, mentioned the mailing list
- copies the html pages as well to the share/doc directory (new manual dir)
- had to update PLIST
- shortened DESCR file, to match the 24 lines
- added post build target, that reminds the admin how to proceed when
already having a database -> INSTALL file describes migration
- updated manpages
|
| |
|
| |
|
|
|
|
|
|
|
|
|
|
| |
- Added missing ldconfig -m in startup file
- Modified pgsql user environment
- Make port NOPORTDOCS aware
- Add additional port docs to post-install target and updated PLIST
- recursively change owner of pgsql directory after creating .profile,
so that .profile can be modified by the pgsql user.
Hope everything is fine now.
|
|
|
|
|
| |
Enabled locale support, please tell me, if this ok or causes trouble.
Thanks.
|
| |
|
| |
|
|
|
|
| |
port, which is going to be removed
|
| |
|
|
|
|
|
|
|
|
|
| |
Clean up newly imported PostgreSQL port:
- variable reorganization and cleanup
- remove NOMANCOMPRESS conditional in favour of MAN?=
- prevent import of installing user's $PATH into ${PREFIX}/pgsql/.profile
- change package name to remove 'v'
- remove some of the latent bugs left over from the postgres95 port.
|
| |
|
|
|
|
|
|
|
|
|
|
| |
to boot.
Have updated the Master Sites listing to reflect where the current port
actually resides, as well as added a few of the mirrors. Will work on
bringing the port up to date as I figure out how ports work :(
This should at least allow this port to be compiled using v1.08 now
|
| |
|
| |
|
|
|
|
|
| |
Perl ports now use MASTER_SITE_PERL_CPAN
Misc cleanup
|
|
|
|
|
| |
Reviewed by: jfitz@FreeBSD.ORG
Submitted by: matt@bdd.net
|
|
|
|
|
| |
Reviewed by: jfitz@FreeBSD.ORG
Submitted by: matt@bdd.net
|
|
Reviewed by: jfitz@FreeBSD.ORG
Submitted by: Matthew Stein <matt@bdd.net>
|