[csw-devel] SF.net SVN: gar:[7506] csw/mgar/pkg/postgresql/trunk
wahwah at users.sourceforge.net
wahwah at users.sourceforge.net
Mon Nov 30 01:35:28 CET 2009
Revision: 7506
http://gar.svn.sourceforge.net/gar/?rev=7506&view=rev
Author: wahwah
Date: 2009-11-30 00:35:28 +0000 (Mon, 30 Nov 2009)
Log Message:
-----------
postgresql: Seems to be working with versioned directories.
Modified Paths:
--------------
csw/mgar/pkg/postgresql/trunk/Makefile
csw/mgar/pkg/postgresql/trunk/checksums
Added Paths:
-----------
csw/mgar/pkg/postgresql/trunk/files/cswpostgres.tmpl
csw/mgar/pkg/postgresql/trunk/files/cswusergroup.tmpl
csw/mgar/pkg/postgresql/trunk/files/postgresql.conf.tmpl
Removed Paths:
-------------
csw/mgar/pkg/postgresql/trunk/files/cswpostgres
csw/mgar/pkg/postgresql/trunk/files/cswusergroup
csw/mgar/pkg/postgresql/trunk/files/postgresql.conf
Property Changed:
----------------
csw/mgar/pkg/postgresql/trunk/Makefile
Modified: csw/mgar/pkg/postgresql/trunk/Makefile
===================================================================
--- csw/mgar/pkg/postgresql/trunk/Makefile 2009-11-29 18:44:36 UTC (rev 7505)
+++ csw/mgar/pkg/postgresql/trunk/Makefile 2009-11-30 00:35:28 UTC (rev 7506)
@@ -1,3 +1,7 @@
+# Copyright 2009 OpenCSW
+# Distributed under the terms of the GNU General Public License v2
+# $Id$
+
GARNAME = postgresql
BASE_VERSION = 8.4
PATCHLEVEL = 1
@@ -4,7 +8,12 @@
GARVERSION = $(BASE_VERSION).$(PATCHLEVEL)
CATEGORIES = apps
+# Useful when making a series of builds on the same day
+GARFLAVOR = DBG
+
DESCRIPTION = An advanced open source database
+SPKG_SOURCEURL = http://www.postgresql.org/
+
define BLURB
endef
@@ -16,18 +25,21 @@
libdir_install =$(prefix)/lib/$(GARNAME)/$(BASE_VERSION)
libexecdir_install =$(prefix)/libexec/$(GARNAME)/$(BASE_VERSION)
lispdir=$(prefix)/share/$(GARNAME)/$(BASE_VERSION)/emacs/site-lisp
-localstatedir = /var/opt/csw/$(GARNAME)/$(BASE_VERSION)
+localstatedir = /var$(prefix)/$(GARNAME)/$(BASE_VERSION)
mandir=$(prefix)/share/$(GARNAME)/$(BASE_VERSION)/man
sbindir_install = $(prefix)/sbin/$(GARNAME)/$(BASE_VERSION)
sharedstatedir=$(prefix)/share/$(GARNAME)/$(BASE_VERSION)
sourcedir=$(prefix)/src/$(GARNAME)/$(BASE_VERSION)
-sysconfdir = /etc/opt/csw/$(GARNAME)/$(BASE_VERSION)
+sysconfdir = /etc$(prefix)/$(GARNAME)/$(BASE_VERSION)
+MIGRATE_FILES = postgresql.conf
+MIGRATE_DEST_DIR = $(sysconfdir)
+
MASTER_SITES = http://wwwmaster.postgresql.org/redir/53/h/source/v$(GARVERSION)/
DISTFILES = $(GARNAME)-$(GARVERSION).tar.bz2
-DISTFILES += cswpostgres
-DISTFILES += cswusergroup
-DISTFILES += postgresql.conf
+DISTFILES += cswpostgres.tmpl
+DISTFILES += cswusergroup.tmpl
+DISTFILES += postgresql.conf.tmpl
DISTFILES += README-CSW.txt
PACKAGES = CSWpostgresql CSWpostgresqldoc CSWpostgresqldevel CSWlibpq
@@ -42,20 +54,32 @@
SPKG_DESC_CSWpostgresqldevel = PostgreSQL Developer Files
SPKG_DESC_CSWlibpq = PostgreSQL Libraries
-SPKG_SOURCEURL = http://www.postgresql.org/
-
REQUIRED_PKGS_CSWpostgresql = CSWreadline CSWzlib CSWlibpq
REQUIRED_PKGS_CSWpostgresqldevel = CSWpostgresql
LICENSE = COPYRIGHT
-# prefix = $(BUILD_PREFIX)/postgresql
-# docdir = $(BUILD_PREFIX)/share/doc
-
EXTRA_INC = $(BUILD_PREFIX)/include
EXTRA_LIB = $(BUILD_PREFIX)/lib
+EXTRA_LD_OPTIONS = -R$(prefix)/lib/\$$ISALIST
+
BUILD64 = 1
+
+# There was a discussion about whether to use ISAEXEC by default. The argument
+# is that enabling 64-bit by default where possible (using isaexec) is a waste.
+# I'm not completely convinced. Leaving this line commented out for future
+# consideration.
+#
+# References:
+# - http://lists.opencsw.org/pipermail/maintainers/2009-November/004903.html
+#
+# I'd like to get some hard data though. What is the difference in the memory
+# footprint, and what is the difference in execution speed between 32 and
+# 64-bit versions?
+#
+# NO_ISAEXEC = 1
+
CONFIGURE_ARGS = $(DIRPATHS)
TEST_TARGET = check
@@ -63,33 +87,66 @@
EXTRA_PAX_ARGS = -s ",^\./opt/csw/postgresql/share/doc,./opt/csw/share/doc/postgresql,p"
PKGFILES_CSWpostgresqldoc = $(PKGFILES_DOC)
-PKGFILES_CSWpostgresqldevel = $(PKGFILES_DEVEL)
-PKGFILES_CSWlibpq = $(PKGFILES_RT)
+PKGFILES_CSWpostgresqldevel = $(PKGFILES_DEVEL)
+PKGFILES_CSWpostgresqldevel += $(prefix)/share/doc/postgresql/html.*
+PKGFILES_CSWlibpq = $(PKGFILES_RT)
+PKGFILES_CSWlibpq += $(libdir)/64
# -> TODO: start in rc3.d S10, Stop everywhere else in K90
-INITSMF = /etc/opt/csw/init\.d/cswpostgres-$(BASE_VERSION)
+INITSMF = /etc$(prefix)/init\.d/cswpostgres-$(BASE_VERSION)
-# -> TODO: Migrate /opt/csw/var/pgdata to /var/opt/csw/postgresql/pgdata
-USERGROUP = /etc/opt/csw/pkg/postgresql-$(BASE_VERSION)
+# -> TODO: Migrate $(prefix)/var/pgdata to /var$(prefix)/postgresql/pgdata
+USERGROUP = /etc$(prefix)/pkg/postgresql-$(BASE_VERSION)
-# -> TODO: Migrate /opt/csw/etc/postgresql.conf to /etc/opt/csw/postgresql.conf
-PRESERVECONF = /opt/csw/etc/postgresql\.conf
+# -> TODO: Migrate $(prefix)/etc/postgresql.conf to /etc$(prefix)/postgresql.conf
+PRESERVECONF = $(sysconfdir)/postgresql\.conf
+BIN_NAMES = clusterdb createdb createlang createuser dropdb droplang dropuser
+BIN_NAMES += ecpg initdb pg_config pg_controldata pg_ctl pg_dump pg_dumpall
+BIN_NAMES += pg_resetxlog pg_restore postgres postmaster psql reindexdb
+
+PGDATA = $(localstatedir)/pgdata
+
+PROTOTYPE_MODIFIERS = pgdata
+PROTOTYPE_FILES_pgdata = $(PGDATA)
+PROTOTYPE_USER_pgdata = postgres
+PROTOTYPE_GROUP_pgdata = postgres
+PROTOTYPE_PERMS_pgdata = 0700
+PROTOTYPE_CLASS_pgdata = ugfiles
+
+SPKG_CLASSES = none ugfiles
+
include gar/category.mk
CFLAGS := $(filter-out -I%,$(CFLAGS))
post-merge:
- ginstall -d $(PKGROOT)/etc/opt/csw/init.d
+ ginstall -d $(PKGROOT)/etc$(prefix)/init.d
+ sed -e 's+ at PGDATA@+$(PGDATA)+' \
+ -e 's+ at sysconfdir@+$(sysconfdir)+' \
+ -e 's+ at bindir@+$(bindir)+' \
+ < $(FILEDIR)/cswpostgres.tmpl \
+ > $(WORKDIR)/cswpostgres
ginstall \
$(WORKDIR)/cswpostgres \
- $(PKGROOT)/etc/opt/csw/init.d/cswpostgres-$(BASE_VERSION)
- ginstall -d $(PKGROOT)/etc/opt/csw/pkg/$(GARNAME)
+ $(PKGROOT)/etc$(prefix)/init.d/cswpostgres-$(BASE_VERSION)
+ ginstall -d $(PKGROOT)/etc$(prefix)/pkg/$(GARNAME)
+ sed -e 's+ at PGDATA@+$(PGDATA)+' \
+ < $(FILEDIR)/cswusergroup.tmpl \
+ > $(WORKDIR)/cswusergroup
ginstall $(WORKDIR)/cswusergroup \
- $(PKGROOT)/etc/opt/csw/pkg/postgresql/$(GARNAME)-$(BASE_VERSION)
- ginstall -d $(PKGROOT)/etc/opt/csw/$(GARNAME)-$(BASE_VERSION)
+ $(PKGROOT)/etc$(prefix)/pkg/$(GARNAME)/cswusergroup-$(BASE_VERSION)
+ ginstall -d $(PKGROOT)$(sysconfdir)
+ sed -e 's+ at PGDATA@+$(PGDATA)+' \
+ < $(FILEDIR)/postgresql.conf.tmpl \
+ > $(WORKDIR)/postgresql.conf
ginstall $(WORKDIR)/postgresql.conf \
- $(PKGROOT)/etc/opt/csw/$(GARNAME)-$(BASE_VERSION)
- ginstall -d $(PKGROOT)$(docdir)/$(GARNAME)
- ginstall $(WORKDIR)/README-CSW.txt $(PKGROOT)$(docdir)/$(GARNAME)/
+ $(PKGROOT)$(sysconfdir)
+ ginstall -d $(PKGROOT)$(docdir)
+ ginstall $(WORKDIR)/README-CSW.txt $(PKGROOT)$(docdir)
+ for b in $(BIN_NAMES); do \
+ gln -s $(GARNAME)/$(BASE_VERSION)/$${b} $(PKGROOT)$(prefix)/bin/$${b}; \
+ done
+ ginstall -d $(PKGROOT)$(PGDATA)
+ gln -s $(ISA_DEFAULT64) $(PKGROOT)$(libdir)/64
@$(MAKECOOKIE)
Property changes on: csw/mgar/pkg/postgresql/trunk/Makefile
___________________________________________________________________
Added: svn:keywords
+ Id
Modified: csw/mgar/pkg/postgresql/trunk/checksums
===================================================================
--- csw/mgar/pkg/postgresql/trunk/checksums 2009-11-29 18:44:36 UTC (rev 7505)
+++ csw/mgar/pkg/postgresql/trunk/checksums 2009-11-30 00:35:28 UTC (rev 7506)
@@ -1,5 +1,5 @@
6e4e2a7755acf94bc83200a308e21ef3 README-CSW.txt
-73f96aa85c8f99caf4d708c874e23dab cswpostgres
-443171cc5303a8ea0f0a13cbb5e32189 cswusergroup
+922febb720931220e272c2872ebf47e4 cswpostgres.tmpl
+9e1e49d76fee70cb8e2d49304695ec89 cswusergroup.tmpl
f2015af17bacbbfe140daf0d1067f9c9 postgresql-8.4.1.tar.bz2
-20c32ebdca7d585728b6078798fa1f50 postgresql.conf
+8237c74666058f607f5418e3b57c74a9 postgresql.conf.tmpl
Deleted: csw/mgar/pkg/postgresql/trunk/files/cswpostgres
===================================================================
--- csw/mgar/pkg/postgresql/trunk/files/cswpostgres 2009-11-29 18:44:36 UTC (rev 7505)
+++ csw/mgar/pkg/postgresql/trunk/files/cswpostgres 2009-11-30 00:35:28 UTC (rev 7506)
@@ -1,97 +0,0 @@
-#!/bin/sh
-# PostgreSQL startup script - part of the CSWpostgresql package
-# mark at blastwave.org
-
-# Read in the user configuration file
-[ -s /opt/csw/etc/postgresql.conf ] && . /opt/csw/etc/postgresql.conf
-[ -s /etc/opt/csw/postgresql.conf ] && . /etc/opt/csw/postgresql.conf
-
-# Defaults
-[ -z "$PGDATA" ] && PGDATA=/opt/csw/var/pgdata
-[ -z "$PGCTL" ] && PGCTL=/opt/csw/postgresql/bin/sparcv8/pg_ctl
-[ -z "$PGINIT" ] && PGINIT=/opt/csw/postgresql/bin/sparcv8/initdb
-
-
-# The following attempts to catch any mistakes in the server
-# version - it checks if the 64-bit server was last run. If so,
-# it forces the 64-bit server, otherwise it won't start up!
-# And vice-versa for the 32-bit server...
-if [ -f $PGDATA/postmaster.opts ]; then
- grep 'sparcv9' $PGDATA/postmaster.opts > /dev/null
- if [ $? -eq 0 ]; then
- echo $PGCTL | grep "sparcv8" > /dev/null
- if [ $? -eq 0 ]; then
- echo "Warning: 32-bit server was specified in /etc/init.d/cswpostgres,"
- echo " but 64-bit version was last run. Using 64-bit server..."
- fi
- PGCTL=/opt/csw/postgresql/bin/sparcv9/pg_ctl
- PGINIT=/opt/csw/postgresql/bin/sparcv9/initdb
- else
- # Did not detect 64-bit server last used
- echo $PGCTL | grep "sparcv8" > /dev/null
- if [ $? -ne 0 ]; then
- echo "Warning: 64-bit server was specified in /etc/init.d/cswpostgres,"
- echo " but 32-bit version was last run. Using 32-bit server..."
- fi
- PGCTL=/opt/csw/postgresql/bin/sparcv8/pg_ctl
- PGINIT=/opt/csw/postgresql/bin/sparcv8/initdb
- fi
-fi
-
-# Exit if postgres user hasn't been created.
-grep '^postgres:' /etc/passwd >/dev/null
-if [ $? -ne 0 ] ; then
- getent passwd postgres >/dev/null
- if [ $? -ne 0 ] ; then
- exit 0
- fi
-fi
-
-# Change to /var/tmp, as pgctl etc. need to be started from
-# a directory that they can read
-cd /var/tmp
-
-case "$1" in
-start)
- if [ -d $PGDATA -a `ls -l $PGDATA 2> /dev/null | wc -l` -gt 1 ]; then
- # PostgreSQL data directory exists and is populated
- echo "Starting PostgreSQL..."
- su postgres -c "$PGCTL -D $PGDATA -l $PGDATA/postgresql.log start $SERVEROPTS"
- fi
- ;;
-
-stop)
- echo "Stopping PostgreSQL database..."
- su postgres -c "$PGCTL -D $PGDATA -l $PGDATA/postgresql.log stop"
- ;;
-
-restart)
- echo "Restarting PostgreSQL database..."
- su postgres -c "$PGCTL -D $PGDATA -l $PGDATA/postgresql.log restart $SERVEROPTS"
- ;;
-
-reload)
- echo "Reloading PostgreSQL database..."
- su postgres -c "$PGCTL -D $PGDATA -l $PGDATA/postgresql.log reload $SERVEROPTS"
- ;;
-
-status)
- su postgres -c "$PGCTL -D $PGDATA status"
- ;;
-
-init)
- # create and initialise data directory
- echo "Creating PostgreSQL data directory at $PGDATA..."
- # Create it, unless it's already there and empty
- [ -d $PGDATA -a `ls -l $PGDATA 2> /dev/null | wc -l` -eq 1 ] || mkdir -p $PGDATA
- chown postgres $PGDATA
- echo "Initialising PostgreSQL database..."
- su postgres -c "$PGINIT -D $PGDATA > /dev/null"
- ;;
-
-*)
- echo "Usage: $0 (init|start|stop|restart|reload|status)"
- ;;
-
-esac
-
Copied: csw/mgar/pkg/postgresql/trunk/files/cswpostgres.tmpl (from rev 7363, csw/mgar/pkg/postgresql/trunk/files/cswpostgres)
===================================================================
--- csw/mgar/pkg/postgresql/trunk/files/cswpostgres.tmpl (rev 0)
+++ csw/mgar/pkg/postgresql/trunk/files/cswpostgres.tmpl 2009-11-30 00:35:28 UTC (rev 7506)
@@ -0,0 +1,113 @@
+#!/bin/sh
+# $Id$
+#
+# PostgreSQL startup script - part of the CSWpostgresql package
+# mark at blastwave.org
+#
+# 2009-11-29: Parametrized file locations
+# Maciej Blizinski (maciej at opencsw.org)
+#
+# Variables to substitute:
+# - PGDATA
+# - bindir
+# - sysconfdir
+
+
+# Read in the user configuration file
+[ -s /opt/csw/etc/postgresql.conf ] && . /opt/csw/etc/postgresql.conf
+[ -s @sysconfdir@/postgresql.conf ] && . @sysconfdir@/postgresql.conf
+
+# Defaults
+[ -z "${PGDATA}" ] && PGDATA=@PGDATA@
+[ -z "${PGCTL}" ] && PGCTL=@bindir@/sparcv8/pg_ctl
+[ -z "${PGINIT}" ] && PGINIT=@bindir@/sparcv8/initdb
+
+
+# The following attempts to catch any mistakes in the server
+# version - it checks if the 64-bit server was last run. If so,
+# it forces the 64-bit server, otherwise it won't start up!
+# And vice-versa for the 32-bit server...
+if [ -f "${PGDATA}/postmaster.opts" ]; then
+ if grep 'sparcv9' ${PGDATA}/postmaster.opts > /dev/null; then
+ echo ${PGCTL} | grep "sparcv8" > /dev/null
+ if [ $? -eq 0 ]; then
+ echo "Warning: 32-bit server was specified in /etc/init.d/cswpostgres,"
+ echo " but 64-bit version was last run. Using 64-bit server..."
+ fi
+ PGCTL=@bindir@/sparcv9/pg_ctl
+ PGINIT=@bindir@/sparcv9/initdb
+ elif grep 'sparcv8' ${PGDATA}/postmaster.opts > /dev/null; then
+ # Detected 32-bit server last used
+ echo "${PGCTL}" | grep "sparcv8" > /dev/null
+ if [ $? -ne 0 ]; then
+ echo "Warning: 64-bit server was specified in /etc/init.d/cswpostgres,"
+ echo " but 32-bit version was last run. Using 32-bit server..."
+ fi
+ PGCTL=@bindir@/sparcv8/pg_ctl
+ PGINIT=@bindir@/sparcv8/initdb
+ else
+ echo "Couldn't detect whether the previously run version was 32 or 64-bit."
+ PGCTL=@bindir@/pg_ctl
+ PGINIT=@bindir@/initdb
+ fi
+fi
+
+# Exit if postgres user hasn't been created.
+grep '^postgres:' /etc/passwd >/dev/null
+if [ $? -ne 0 ] ; then
+ getent passwd postgres >/dev/null
+ if [ $? -ne 0 ] ; then
+ exit 0
+ fi
+fi
+
+# Change to /var/tmp, as pgctl etc. need to be started from
+# a directory that they can read
+cd /var/tmp
+
+case "${1}" in
+start)
+ if [ -d ${PGDATA} -a `ls -l ${PGDATA} 2> /dev/null | wc -l` -gt 1 ]; then
+ # PostgreSQL data directory exists and is populated
+ echo "Starting PostgreSQL..."
+ su postgres -c "${PGCTL} -D ${PGDATA} -l ${PGDATA}/postgresql.log start ${SERVEROPTS}"
+ fi
+ ;;
+
+stop)
+ echo "Stopping PostgreSQL database..."
+ su postgres -c "${PGCTL} -D ${PGDATA} -l ${PGDATA}/postgresql.log stop"
+ ;;
+
+restart)
+ echo "Restarting PostgreSQL database..."
+ su postgres -c "${PGCTL} -D ${PGDATA} -l ${PGDATA}/postgresql.log restart ${SERVEROPTS}"
+ ;;
+
+reload)
+ echo "Reloading PostgreSQL database..."
+ su postgres -c "${PGCTL} -D ${PGDATA} -l ${PGDATA}/postgresql.log reload ${SERVEROPTS}"
+ ;;
+
+status)
+ su postgres -c "${PGCTL} -D ${PGDATA} status"
+ ;;
+
+init)
+ # create and initialise data directory
+ echo "Creating PostgreSQL data directory at ${PGDATA}..."
+ # Create it, unless it's already there and empty
+ [ -d ${PGDATA} -a `ls -l ${PGDATA} 2> /dev/null | wc -l` -eq 1 ] || mkdir -p "${PGDATA}"
+ chown postgres "${PGDATA}"
+ chmod 0700 "${PGDATA}"
+ echo "Initialising PostgreSQL database..."
+ su postgres -c "${PGINIT} -D ${PGDATA} -E utf-8"
+ ;;
+
+*)
+ echo "Usage: ${0} (init|start|stop|restart|reload|status)"
+ ;;
+
+esac
+
+# vim:set sw=2 ts=2 sts=2 expandtab:
Deleted: csw/mgar/pkg/postgresql/trunk/files/cswusergroup
===================================================================
--- csw/mgar/pkg/postgresql/trunk/files/cswusergroup 2009-11-29 18:44:36 UTC (rev 7505)
+++ csw/mgar/pkg/postgresql/trunk/files/cswusergroup 2009-11-30 00:35:28 UTC (rev 7506)
@@ -1 +0,0 @@
-postgres::CSW Postgres:/opt/csw/var/pgdata:/bin/sh::
Copied: csw/mgar/pkg/postgresql/trunk/files/cswusergroup.tmpl (from rev 7363, csw/mgar/pkg/postgresql/trunk/files/cswusergroup)
===================================================================
--- csw/mgar/pkg/postgresql/trunk/files/cswusergroup.tmpl (rev 0)
+++ csw/mgar/pkg/postgresql/trunk/files/cswusergroup.tmpl 2009-11-30 00:35:28 UTC (rev 7506)
@@ -0,0 +1 @@
+postgres::CSW Postgres:@PGDATA@:/bin/sh::
Deleted: csw/mgar/pkg/postgresql/trunk/files/postgresql.conf
===================================================================
--- csw/mgar/pkg/postgresql/trunk/files/postgresql.conf 2009-11-29 18:44:36 UTC (rev 7505)
+++ csw/mgar/pkg/postgresql/trunk/files/postgresql.conf 2009-11-30 00:35:28 UTC (rev 7506)
@@ -1,34 +0,0 @@
-# Example PostgreSQL server configuration file.
-# Provided by the Blastwave package of PostgreSQL.
-# This file is read by the /etc/init.d/cswpostgres startup script,
-# and can be used to override the defaults.
-
-# The location of the data directory.
-# Default : /opt/csw/var/pgdata
-PGDATA=/opt/csw/var/pgdata
-
-
-# Which binaries to use, 32- or 64-bit.
-# Only use the 64-bit server if you're sure you need it.
-# Make sure you have read /opt/csw/postgresql/share/doc/README-CSW.txt
-# before changing these, as your databases may not work without
-# a 'dump and restore' cycle !
-
-# 32-bit server - default, and fine for most uses
-PGCTL=/opt/csw/postgresql/bin/sparcv8/pg_ctl
-PGINIT=/opt/csw/postgresql/bin/sparcv8/initdb
-
-# 64-bit server - uncomment these lines only if you really need them.
-#PGCTL=/opt/csw/postgresql/bin/sparcv9/pg_ctl
-#PGINIT=/opt/csw/postgresql/bin/sparcv9/initdb
-
-
-# Additional options to pass to postmaster.
-# These options will be passed to the postmaster program. The most common use of
-# these is to allow network access to PostgreSQL from other hosts over TCP/IP.
-# This is done by using the flags "-o -i", as in the example below.
-# Uncomment this line to enable network access to PostgreSQL.
-# Note that you will still need to configure authentication in the pg_hba.conf
-# in your data directory.
-# SERVEROPTS="-o -i"
-
Copied: csw/mgar/pkg/postgresql/trunk/files/postgresql.conf.tmpl (from rev 7363, csw/mgar/pkg/postgresql/trunk/files/postgresql.conf)
===================================================================
--- csw/mgar/pkg/postgresql/trunk/files/postgresql.conf.tmpl (rev 0)
+++ csw/mgar/pkg/postgresql/trunk/files/postgresql.conf.tmpl 2009-11-30 00:35:28 UTC (rev 7506)
@@ -0,0 +1,37 @@
+# Example PostgreSQL server configuration file.
+#
+# Provided by the OpenCSW package of PostgreSQL. This file is read by the
+# /etc/opt/csw/init.d/cswpostgres startup script, and can be used to override
+# the defaults.
+
+# The location of the data directory.
+# Default : /opt/csw/var/pgdata
+PGDATA=@PGDATA@
+
+# Which binaries to use, 32- or 64-bit. Only use the 64-bit server if you're
+# sure you need it. Make sure you have read
+# /opt/csw/postgresql/share/doc/README-CSW.txt before changing these, as your
+# databases may not work without a 'dump and restore' cycle!
+
+# 32-bit server - default, and fine for most uses
+#
+# PGCTL=/opt/csw/postgresql/bin/sparcv8/pg_ctl
+# PGINIT=/opt/csw/postgresql/bin/sparcv8/initdb
+
+# 64-bit server - uncomment these lines only if you really need them.
+#
+# PGCTL=/opt/csw/postgresql/bin/sparcv9/pg_ctl
+# PGINIT=/opt/csw/postgresql/bin/sparcv9/initdb
+
+
+# Additional options to pass to postmaster.
+#
+# These options will be passed to the postmaster program. The most common use
+# of these is to allow network access to PostgreSQL from other hosts over
+# TCP/IP. This is done by using the flags "-o -i", as in the example below.
+# Uncomment this line to enable network access to PostgreSQL. Note that you
+# will still need to configure authentication in the pg_hba.conf in your data
+# directory.
+#
+# SERVEROPTS="-o -i"
+
This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.
More information about the devel
mailing list