summaryrefslogtreecommitdiff
path: root/databases/postgresql81-server/files (follow)
Commit message (Collapse)AuthorAgeFilesLines
* Handle a change in rc.subr. nowadays, "faststart" is used instead ofPalle Girgensohn2005-12-251-2/+2
| | | | | | | | | | | | | "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> Notes: svn path=/head/; revision=152024
* Welcome to PostgreSQL 8.1.Palle Girgensohn2005-11-102-21/+12
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | 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 Notes: svn path=/head/; revision=147772
* Upgrade PostgreSQL to 8.0.2. Here's the brief release note:Palle Girgensohn2005-04-132-171/+0
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | 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) Notes: svn path=/head/; revision=133287
* Modify 8.0's startup script to simulate a full login (su -l) [1]. AlsoPalle Girgensohn2005-03-191-2/+3
| | | | | | | | | | | | | | | | 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) Notes: svn path=/head/; revision=131605
* Fixing problems with the recent security patch: When bison was notPalle Girgensohn2005-02-201-0/+91
| | | | | | | | | | | | | | | | | | | | 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) Notes: svn path=/head/; revision=129331
* Fix security alert using a patch from PostgreSQL's CVS repository:Palle Girgensohn2005-02-191-0/+80
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | 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) Notes: svn path=/head/; revision=129277
* The postgresql_* knobs from /etc/rc.conf where read too late toPalle Girgensohn2005-02-151-1/+1
| | | | | | | | | | actually make a difference. Noticed by: Salvatore Montefusco, Brian B. Approved by: ade (mentor) Notes: svn path=/head/; revision=128877
* Say hello to postgresql-8.0. Some of the highlights of the new versionPalle Girgensohn2005-01-319-157/+97
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | 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) Notes: svn path=/head/; revision=127738
* Another step along the road to the postgresql new world order.Ade Lovett2004-11-239-165/+115
| | | | | | | | | | | | 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 Notes: svn path=/head/; revision=122238
* - Add note that the function "elog" has been removed fromKirill Ponomarev2004-02-011-3/+9
| | | | | | | | | | pg-7.4 PR: ports/62167 Submitted by: maintainer Notes: svn path=/head/; revision=99702
* Maintainer update to PostgreSQL 7.4.1. This release includes fixed identSean Chittenden2003-12-252-2/+17
| | | | | | | | | | | | | | 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 Notes: svn path=/head/; revision=96563
* Remove the PORTNAME from postgreql-client. PORTNAME is set bySean Chittenden2003-12-051-0/+24
| | | | | | | | | | | | | 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> Notes: svn path=/head/; revision=95163
* Introduce the world to PostgreSQL 7.4! By and large this release isSean Chittenden2003-12-042-9/+15
| | | | | | | | | | | | | | | | | | 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) Notes: svn path=/head/; revision=94977
* Fix my fault in previous commit: put a pkg-messageSergey A. Osokin2003-08-121-0/+17
| | | | | | | | | into right place. Notify from: Palle Girgensohn <girgen@pingpong.net> Notes: svn path=/head/; revision=86812
* The control script that ships with the postgresSergey A. Osokin2003-06-111-1/+1
| | | | | | | | | | | | | | 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) Notes: svn path=/head/; revision=82824
* Remove a patch file which is no need for 7.3.3.Norikatsu Shigemura2003-06-021-38/+0
| | | | | | | Submitted by: Mike Harding <mvh@ix.netcom.com> Notes: svn path=/head/; revision=81965
* Update to 7.3.3.Norikatsu Shigemura2003-06-021-29/+0
| | | | | | | | | | | | | | | | 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) Notes: svn path=/head/; revision=81964
* Add patch for a fix for braindead applications that were depending onSean Chittenden2003-02-201-0/+29
| | | | | | | | | | | 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 Notes: svn path=/head/; revision=75919
* Add a patch fix a long standing bug in PostgreSQL with LISTEN/NOTIFYSean Chittenden2003-02-191-0/+38
| | | | | | | | | | 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> Notes: svn path=/head/; revision=75907
* Update PostgreSQL to the maintenance release 7.3.2.Sean Chittenden2003-02-061-10/+0
| | | | | | | | | | | | | | | | | | 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] Notes: svn path=/head/; revision=74993
* Update PostgreSQL to 7.3.1[1]. Fixes builds for spac64. Many speed,Sean Chittenden2003-01-046-132/+46
| | | | | | | | | | | | | | | | 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 Notes: svn path=/head/; revision=72481
* Port update submitted by maintainerNick Sayer2002-11-061-1/+3
| | | | | | | | PR: ports/44983 Submitted by: girgen@pingpong.net Notes: svn path=/head/; revision=69555
* Update to 7.2.2, which fixes several security bugs. Do not installTrevor Johnson2002-08-262-24/+20
| | | | | | | | | | documentation--it will be in a separate port. PR: 42009 Submitted by: Palle Girgensohn (maintainer) Notes: svn path=/head/; revision=65022
* Fix build on -CURRENT:Sheldon Hearn2002-06-261-0/+59
| | | | | | | | | | | | | * 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. Notes: svn path=/head/; revision=62050
* upgrade to 7.2.1Ying-Chieh Liao2002-04-116-54/+62
| | | | | | | | PR: 36975 Submitted by: maintainer Notes: svn path=/head/; revision=57555
* Upgrade to 7.2, and spilit into several ports.Vanilla I. Shu2002-02-1910-191/+128
| | | | | | | | PR: ports/34855 Submitted by: maintainer. Notes: svn path=/head/; revision=54887
* Update the PostgreSQL port to 7.1.3.Clive Lin2001-08-211-0/+3
| | | | | | | | | | | 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) Notes: svn path=/head/; revision=46573
* Forgotten file.James E. Housley2001-06-041-0/+51
| | | | | | | | | | Add character sets to the server PR: 27846 Submitted by: Palle Girgensohn <girgen@partitur.se> Notes: svn path=/head/; revision=43486
* forget to remove patchYing-Chieh Liao2001-05-281-13/+0
| | | | | | | | PR: 27676 Submitted by: Palle Girgensohn <girgen@partitur.se> Notes: svn path=/head/; revision=43171
* upgrade to 7.1.2Ying-Chieh Liao2001-05-271-7/+34
| | | | | | | | PR: 27676 Submitted by: maintainer Notes: svn path=/head/; revision=43125
* Upgrade to 7.1.1Vanilla I. Shu2001-05-091-0/+34
| | | | | | | | PR: ports/27220 Submitted by: maintainer Notes: svn path=/head/; revision=42436
* Cosmetic changes for the shutdown procedure.Jimmy Olgeni2001-05-021-1/+2
| | | | | | | | | | | | * 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. Notes: svn path=/head/; revision=42166
* Misc. changes and cleanups.Jimmy Olgeni2001-04-251-1/+1
| | | | | | | | | | | | | | | | | | | | * 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> Notes: svn path=/head/; revision=41897
* Upgrade to 7.1, change to new layout style.Vanilla I. Shu2001-04-2120-271/+211
| | | | | | | | PR: ports/26741 Submitted by: maintainer Notes: svn path=/head/; revision=41758
* ldconfig PostgreSQL's lib should happen before starting *ANY* ports.Clive Lin2001-03-151-1/+1
| | | | | | | | | | | | | | | | 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 Notes: svn path=/head/; revision=39895
* Fix problems when installing postgresql7 with pkg_add:Clive Lin2001-03-151-2/+2
| | | | | | | | | | | | | | | - 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 Notes: svn path=/head/; revision=39873
* Update to version 7.0.3.Steve Price2000-12-119-16/+124
| | | | | | | | PR: 23371 Submitted by: maintainer Notes: svn path=/head/; revision=35882
* allow PostgreSQL to compile and run on Alpha.Andreas Klemm2000-08-311-0/+42
| | | | | | | | | | 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> Notes: svn path=/head/; revision=32148
* Update to 7.0.2.Akinori MUSHA2000-06-202-1/+3
| | | | | | | | | Fix NOPORTDOCS support. Fix PLIST in many respects, especially for pgacess. Notes: svn path=/head/; revision=29698
* make startup script work (start/stop)Andreas Klemm2000-05-252-20/+23
| | | | | | | Obtained from: Palle Girgensohn <girgen@partitur.se> Notes: svn path=/head/; revision=28745
* upgrade postgresql to v 7.0 releaseAndreas Klemm2000-05-243-23/+47
| | | | | | | | | | | thanks for complete diffs ;-) closed PR PR: 18699 Obtained from: Palle Girgensohn <girgen@partitur.se> Notes: svn path=/head/; revision=28731
* Update to postgresql 7 beta 5Andreas Klemm2000-04-171-17/+10
| | | | | | | | | closes PR PR: 17736 Notes: svn path=/head/; revision=27703
* Update to version 6.5.2.Chris Piazza1999-10-103-11/+12
| | | | | | | | | | | | | | | | | 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> Notes: svn path=/head/; revision=22314
* $Id$ -> $FreeBSD$Peter Wemm1999-08-291-1/+1
| | | | Notes: svn path=/head/; revision=21083
* Update postgresql to 6.5.1Andreas Klemm1999-07-211-2/+2
| | | | | | | | | | maintenance release with bugfixes Thanks for the complete submission ! Submitted by: Palle Girgensohn <girgen@partitur.se> Notes: svn path=/head/; revision=20294
* These were missing as wellAndreas Klemm1999-06-292-0/+22
| | | | Notes: svn path=/head/; revision=19903
* Forgot to add this patchAndreas Klemm1999-06-291-0/+32
| | | | Notes: svn path=/head/; revision=19902
* upgrade to postgresql 6.5Andreas Klemm1999-06-292-37/+30
| | | | | | | | | did some small modifications Obtained from: "Palle Girgensohn" <girgen@partitur.se> Notes: svn path=/head/; revision=19901
* Fix build for ELF and update PLIST to match the current state of affairs.Steve Price1999-02-041-0/+16
| | | | | | | PR: 9685 Notes: svn path=/head/; revision=16531
* Upgrade postgresql to version 6.3.2Andreas Klemm1998-04-211-3/+3
| | | | | | | | | | | | | | | | | | | 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> Notes: svn path=/head/; revision=10625
generated by cgit v1.2.3 (git 2.25.1) at 2025-05-11 09:13:12 +0000