summaryrefslogtreecommitdiff
path: root/databases/postgresql-server
AgeCommit message (Collapse)AuthorFilesLines
2004-01-20Remove USE_BUILDLINK2 from Makefile.common and distribute the setting tojlam1-1/+3
all of the package Makefiles that include Makefile.common.
2003-11-14Add 'ulimit -n 4096' to increase the number of FDs postgresql can use. This ↵explorer2-3/+5
is what we do for mysql-server as well. Bump to nb3.
2003-11-12PKGREVISION++ after openssl update.jschauma1-2/+2
2003-10-11only test for existance of data directory, rather than the templategrant1-3/+3
databases to determine whether the dbdir has been initialised. fixes PR pkg/21133 from Thomas T. Thai.
2003-09-18Specify the category when including other files and when depending on otherjmmv1-3/+3
packages. From PR pkg/21864 by ccatrian at eml.cc.
2003-08-30Add definitions for DEINSTALL_EXTRA_TMPL and INSTALL_EXTRA_TMPL ifjlam1-1/+3
USE_PKGINSTALL is "YES". bsd.pkg.install.mk will no longer automatically pick up a INSTALL/DEINSTALL script in the package directory and assume that you want it for the corresponding *_EXTRA_TMPL variable.
2003-07-16Update to postgresql-server-7.3.3nb1abs2-6/+4
In rc.d/pgsql call pgsql_initdb directly for initial database setup, rather than trying to determine the script location from $0 and calling '$rcd_dir/pgsql initdb'. The previous form broke when called from /etc/rc.
2003-05-06Drop trailing whitespace. Ok'ed by wiz.jmmv1-4/+4
2003-03-25Add in SVR4 pkg names.cjep1-1/+2
2003-02-21Update postgresql-* to 7.3.2. Contains numerous bug fixes, including remotemycroft1-2/+2
holes. Restore creation of OID column in CREATE TABLE AS / SELECT INTO Fix pg_dump core dump when dumping views having comments Dump DEFERRABLE/INITIALLY DEFERRED constraints properly Fix UPDATE when child table's column numbering differs from parent Increase default value of max_fsm_relations Fix problem when fetching backwards in a cursor for a single-row query Make backward fetch work properly with cursor on SELECT DISTINCT query Fix problems with loading pg_dump files containing contrib/lo usage Fix problem with all-numeric user names Fix possible memory leak and core dump during disconnect in libpgtcl Make plpython's spi_execute command handle nulls properly (Andrew Bosma) Adjust plpython error reporting so that its regression test passes again Work with bison 1.875 Handle mixed-case names properly in plpgsql's %type (Neil) Fix core dump in pltcl when executing a query rewritten by a rule Repair array subscript overruns (per report from Yichen Xie) Reduce MAX_TIME_PRECISION from 13 to 10 in floating-point case Correctly case-fold variable names in per-database and per-user settings Fix coredump in plpgsql's RETURN NEXT when SELECT into record returns no rows Fix outdated use of pg_type.typprtlen in python client interface Correctly handle fractional seconds in timestamps in JDBC driver Improve performance of getImportedKeys() in JDBC Make shared-library symlinks work standardly on HPUX (Giles) Repair inconsistent rounding behavior for timestamp, time, interval SSL negotiation fixes (Nathan Mueller) Make libpq's ~/.pgpass feature work when connecting with PQconnectDB Update my2pg, ora2pg Translation updates Add casts between types lo and oid in contrib/lo fastpath code now checks for privilege to call function
2003-01-28Instead of including bsd.pkg.install.mk directly in a package Makefile,jlam1-2/+2
have it be automatically included by bsd.pkg.mk if USE_PKGINSTALL is set to "YES". This enforces the requirement that bsd.pkg.install.mk be included at the end of a package Makefile. Idea suggested by Julio M. Merino Vidal <jmmv at menta.net>.
2003-01-20fix typolukem1-2/+2
2003-01-11Install the conversion modules and SQL script for postgresql. Bump thejlam2-2/+31
PKGREVISION of databases/postgresql-server to 1.
2003-01-05Updated databases/postgresql to 7.3.1.jlam1-5/+3
================================================================== | NOTE: A dump-and-restore is required to update your databases | | if you wish to update postgresql-server. If your | | application examines the system catalogs, additional | | changes will be required due to the introduction of | | schemas in 7.3; for more information, see: | | | | http://www.ca.postgresql.org/docs/momjian/upgrade_tips_7.3 | ================================================================== Major changes from version 7.2.3 include: Schemas Schemas allow users to create objects in separate namespaces, so two people or applications can have tables with the same name. There is also a public schema for shared tables. Table/index creation can be restricted by removing permissions on the public schema. Drop Column PostgreSQL now supports the ALTER TABLE ... DROP COLUMN functionality. Table Functions Functions returning multiple rows and/or multiple columns are now much easier to use than before. You can call such a "table function" in the SELECT FROM clause, treating its output like a table. Also, PL/pgSQL functions can now return sets. Prepared Queries PostgreSQL now supports prepared queries, for improved performance. Dependency Tracking PostgreSQL now records object dependencies, which allows improvements in many areas. "DROP" statements now take either CASCADE or RESTRICT to control whether dependent objects are also dropped. Privileges Functions and procedural languages now have privileges, and functions can be defined to run with the privileges of their creator. Internationalization Both multibyte and locale support are now always enabled. Logging A variety of logging options have been enhanced. Interfaces A large number of interfaces have been moved to http://gborg.postgresql.org where they can be developed and released independently. Functions/Identifiers By default, functions can now take up to 32 parameters, and identifiers can be up to 63 bytes long. Also, OPAQUE is now deprecated: there are specific "pseudo-datatypes" to represent each of the former meanings of OPAQUE in function argument and result types.
2002-10-19Fix case where pgsql_flags contains more that one option.jlam1-3/+3
2002-10-19Forgot to fix quoting for pgsql_flags.jlam1-2/+2
2002-10-19Alter quoting so that command_args can be set to something like:jlam1-3/+7
command_args="> /var/log/pgsql.log"
2002-10-19Don't create ${PGHOME} at install time, as the rc.d script will do it forjlam1-2/+2
us the first time that pgsql is run.
2002-10-19Allow for different "home" directory for storing PostgreSQL databases.jlam1-28/+38
This is specified at run-time by setting pgsql_home=/path/to/home in /etc/rc.conf. Ensure that ${pgsql_home} has the correct permissions (o=${pgsql_user}, g=${pgsql_group}, m=0750) before initializing the database.
2002-10-19You don't need to run "/etc/rc.d/pgsql start" at boot time only.jlam1-3/+3
2002-10-19Don't default to pgsql=NO anymore, as rc.d scripts aren't copied intojlam1-2/+1
/etc/rc.d by default any longer. This causes the usual warning to be emitted when the script is executed.
2002-10-19Update databases/postgresql to version 7.2.3.jlam2-18/+8
This has a variety of fixes from 7.2.2, including fixes to prevent possible data loss. A dump/restore is *not* required for those running 7.2.X. Changes from version 7.2.2 include: Prevent possible compressed transaction log loss (Tom) Prevent non-superuser from increasing most recent vacuum info (Tom) Handle pre-1970 date values in newer versions of glibc (Tom) Fix possible hang during server shutdown Prevent spinlock hangs on SMP PPC machines (Tomoyuki Niijima) Fix pg_dump to properly dump FULL JOIN USING (Tom)
2002-09-20Make these scripts more portable by taking advantage of automatic rc.dgrant1-2/+2
script handling and using @RCD_SCRIPTS_SHELL@. as discussed with jlam.
2002-09-19Take advantage of the auto-generation and installation of rc.d scripts.jlam1-3/+1
2002-09-18When using bsd.pkg.install.mk, if a DEINSTALL or INSTALL file alreadyjlam1-3/+1
exists, then use it as the default value of DEINSTALL_EXTRA_TMPL or INSTALL_EXTRA_TMPL.
2002-09-10Use a stricter test for a true rc.d system and default to pgsql=NO if notjlam1-2/+3
supplied in /etc/rc.conf.
2002-08-30Add comment character before line continuation.wiz1-2/+2
2002-08-30Hint on what's need for SSLhubertf1-2/+3
2002-08-25Merge packages from the buildlink2 branch back into the main trunk thatjlam3-7/+7
have been converted to USE_BUILDLINK2.
2002-08-22Replace all these URLs with some real informationhubertf1-15/+8
2002-08-07Copy crypt.h handling on SunOS from the postgresql-lib package. Thisjlam1-1/+8
addresses pkg/17781 submitted by Julien T. Letessier <julien.letessier at sun dot com>.
2002-07-18Don't hard-code PGHOME; get it from the passwd file.cjs1-3/+3
2002-04-05Add a few error checks for whether the commands we want to execute actuallyjlam1-2/+13
exist.
2002-04-05If we do not have /etc/rc.subr, but we do have /etc/rc.conf, still source it.abs1-1/+5
2002-04-04Update postgresql and related packages to 7.2. Thanks to Michael Graffjlam2-17/+17
<explorer@flame.org> for most of the work on this update. Pkgsrc changes from the previous version include removing Makefile.ssl and some patches that have been integrated into this release of PostgreSQL. We leave open the question of when to byte-compile the Python modules for the PyGreSQL interface and just do it as before, although we should consider doing the compilation as a post-install step to ensure that the timestamps are correct. We also reorder some lines in the Makefile to include Makefile.common below certain definitions (GNU_CONFIGURE, USE_BUILDLINK_ONLY) as they may possibly trigger different portions of Makefile.common. *** Please note that a dump/restore is required to migrate an existing *** *** PostgreSQL installation to 7.2. *** Major changes from version 7.1.3 are geared toward improving use in high-volume applications and include: VACUUM Vacuuming no longer locks tables, thus allowing normal user access during the vacuum. A new "VACUUM FULL" command does old-style vacuum by locking the table and shrinking the on-disk copy of the table. Transactions There is no longer a problem with installations that exceed four billion transactions. OID's OID's are now optional. Users can now create tables without OID's for cases where OID usage is excessive. Optimizer The system now computes histogram column statistics during "ANALYZE", allowing much better optimizer choices. Security A new MD5 encryption option allows more secure storage and transfer of passwords. A new Unix-domain socket authentication option is available on Linux and BSD systems. PAM authentication is also available. Statistics Administrators can use the new table access statistics module to get fine-grained information about table and index usage.
2002-04-04Fix bug in in "/etc/rc.d/pgsql stop": we need to use "fast" mode ratherjlam1-76/+74
than "smart" mode so that the the database will always cleanly shutdown. Previously, postgres would wait for clients to disconnect before stopping the database process, which sometimes resulted in unclean shutdowns. Problem noted by Curt Sampson <cjs@cynic.net> in private email. I also convert this to use /etc/rc.subr if it is present.
2002-02-15mkdir -> ${MKDIR}skrll1-2/+2
rmdir -> ${RMDIR} rm -> ${RM} (${RM} added to PLIST_SUBST) chmod -> ${CHMOD} chown -> ${CHOWN}
2001-12-31Remove dependency on libgetopt. Systems without libgetopt in the basejlam1-2/+1
install will simply use the PostgreSQL getopt implementation instead.
2001-12-03Use PKGREVISION to manage the package-specific version number when itjlam1-3/+2
differs from the distfile version number. G/C some the unused variables in postgresql/Makefile.common related to the old way of handling version numbers.
2001-12-02bsd.pkg.install.mk calls the INSTALL script at the right timesjlam1-4/+1
automatically, so no need to do it ourselves.
2001-11-26Use PKG_{USERS,GROUPS} instead of PKG_{USER,GROUP}.jlam2-9/+8
2001-11-21RCD_SCRIPTS now just lists the filenames (see bsd.pkg.install.mk).jlam1-2/+2
2001-11-19Adapt to use shared INSTALL/DEINSTALL scripts by using the logic injlam4-147/+17
bsd.pkg.install.mk: * Remove old DEINSTALL/INSTALL scripts. * Move some text printed at POST-INSTALL time into the MESSAGE file. * Adjust rc.d scripts to respect rc.conf settings, so that the script may be directly copied into /etc/rc.d.
2001-11-01Move pkg/ files into package's toplevel directoryzuntum5-4/+4
2001-08-20Manually add LIBS+=${LIBGETOPT} to the package Makefile as it's no longerjlam1-1/+3
automatically added by libgetopt/buildlink.mk.
2001-08-14grep isn't used anymore, so don't substitute for @GREP@ in the INSTALLjlam2-5/+5
files. Substitute for @ID@ instead of directly using 'id', and use the value of ${ID} already set in defs.*.mk.
2001-08-12Fix same problems with the user check:veego1-5/+5
- use 'id' instead of 'finger'. this is not a real problem, but it is enough and fixing the next problem makes it possible to use it. - grep -q doesn't work on solaris, so use a different way to suppress the output from the user check. - the return code check for the user was reversed.
2001-06-23Generalize how the dependency pattern may be specified. Instead of justjlam1-6/+5
FOO_REQD=1.0 being converted to foo>=1.0, one can now directly specify the dependency pattern as FOO_DEPENDS=foo>=1.0. This allows things like JPEG_DEPENDS=jpeg-6b, or fancier expressions like for postgresql-lib. Change existing FOO_REQD definitions in Makefiles to FOO_DEPENDS.
2001-06-21Convert to use buildlink.mk files and mark as USE_BUILDLINK_ONLY.jlam1-33/+28
2001-06-11The buildlink include and lib directories are added to CFLAGS, CPPFLAGS,jlam1-1/+8
CXXFLAGS, and LDFLAGS by the buildlink.mk files so remove the extra definitions to add them from the package Makefiles. As advised by the bsd.buildlink.mk file, also ensure that the buildlink.mk files are included prior to defining any package-specific CFLAGS/LDFLAGS to ensure that the buildlink directories are at the head of the compiler search paths.
generated by cgit v1.2.3 (git 2.39.1) at 2024-08-02 00:29:27 +0000