summaryrefslogtreecommitdiff
path: root/databases/postgresql-server
AgeCommit message (Collapse)AuthorFilesLines
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.
2001-06-10Remove dependency on ${BUILDLINK_TARGETS} in pre-configure and pre-buildjlam1-3/+1
targets as the buildlink.mk files now add the dependency automatically. Remove any NO_CONFIGURE definitions as they seem to be useless.
2001-05-24Standardize name of file to include for build-links to be "buildlink.mk".jlam1-3/+3
Use BUILDLINK_INCDIR, BUILDLINK_LIBDIR for locations of linked headers and libraries. Create a variable BUILDLINK_TARGETS whose value is the list of build-link targets to execute.
2001-05-21Use useradd and groupadd on Linux as well as SunOSabs1-2/+2
2001-05-18Move the message that informs the user of the possible need to dump thejlam3-10/+17
databases prior to installing a new version of PostgreSQL from PRE-INSTALL time to DEINSTALL time. Remove ${CAT} from the INSTALL file as it's no longer needed in the script.
2001-05-16Cosmetic change: sort Makefile includesjlam1-2/+2
2001-05-16Update for moved Makefile.getoptabs1-2/+2
2001-05-14Surround possible empty string in quotes so [ sees an argument.jlam1-2/+2
2001-05-14Generalize some of the code a bit to make it easier to cut-and-paste intojlam1-2/+2
other scripts.
2001-05-14Move database initialization step from the INSTALL script to ajlam2-18/+51
start_precmd in the pgsql rc.d script. This is more correct, since if postgresql-server is installed but never used, then no database really needs to be initialized. As a side-effect, the bulk-builds of postgresql should now leave less crud in the aftermath of deinstalling postgresql.
2001-05-14postgresql-server: PostgreSQL database backend server programsjlam8-0/+354
This package also has an enhanced rc.d-style startup script that respects rc.conf settings. If you are running NetBSD>=1.5, then add pgsql=YES to /etc/rc.conf, and set pgsql_flags to any options you wish to pass to the postmaster.