Date: Tue, 18 Nov 2003 05:31:21 +0100 (CET) From: Palle Girgensohn <girgen@pingpong.net> To: FreeBSD-gnats-submit@FreeBSD.org Subject: ports/59402: [MAINTAINER] databases/postgresql: update to 7.4 Message-ID: <200311180431.hAI4VLbJ040204@palle.girgensohn.se> Resent-Message-ID: <200311180440.hAI4eGrG093357@freefall.freebsd.org>
next in thread | raw e-mail | index | archive | help
>Number: 59402
>Category: ports
>Synopsis: [MAINTAINER] databases/postgresql: update to 7.4
>Confidential: no
>Severity: serious
>Priority: high
>Responsible: freebsd-ports-bugs
>State: open
>Quarter:
>Keywords:
>Date-Required:
>Class: maintainer-update
>Submitter-Id: current-users
>Arrival-Date: Mon Nov 17 20:40:16 PST 2003
>Closed-Date:
>Last-Modified:
>Originator: Palle Girgensohn
>Release: FreeBSD 4.9-RELEASE i386
>Organization:
Ping Pong AB
>Environment:
System: FreeBSD palle.girgensohn.se 4.9-RELEASE FreeBSD 4.9-RELEASE #6: Tue Nov 4 22:56:29 CET
>Description:
- Update to 7.4
- Add WITH_PAM knob
- Make postgresql log to syslog by default, and remove the logfile
juggling from the startup script
Please also commit the slave ports sent separately at the same
time. Some of them will break otherwise.
And don't forget to cvs add
files/patch-src:backend:utils:misc:postgresql.conf.sample
Generated with FreeBSD Port Tools 0.50
>How-To-Repeat:
>Fix:
--- postgresql-7.4.patch begins here ---
Index: Makefile
===================================================================
RCS file: /home/ncvs/ports/databases/postgresql7/Makefile,v
retrieving revision 1.115
diff -u -u -r1.115 Makefile
--- Makefile 13 Oct 2003 09:54:16 -0000 1.115
+++ Makefile 18 Nov 2003 04:24:05 -0000
@@ -5,9 +5,9 @@
# $FreeBSD: ports/databases/postgresql7/Makefile,v 1.115 2003/10/13 09:54:16 edwin Exp $
#
-PORTNAME?= postgresql
-PORTVERSION?= 7.3.4
-PORTREVISION= 1
+PORTNAME= postgresql
+PORTVERSION?= 7.4
+PORTREVISION?= 0
CATEGORIES?= databases
MASTER_SITES= ${MASTER_SITE_PGSQL}
MASTER_SITE_SUBDIR= source/v${PORTVERSION}
@@ -20,6 +20,7 @@
WRKSRC= ${WRKDIR}/postgresql-${PORTVERSION}
DIST_SUBDIR= postgresql
+USE_BZIP2= YES
USE_GMAKE= YES
GNU_CONFIGURE= YES
@@ -36,6 +37,10 @@
--with-includes=${LOCALBASE}/include
CONFIGURE_ENV= LDFLAGS="${LDFLAGS}"
+.if defined(WITH_PAM)
+CONFIGURE_ARGS+= --with-pam
+.endif
+
.if !defined(WITHOUT_GNUGETOPT)
USE_GETOPT_LONG=yes
.endif
@@ -50,7 +55,7 @@
.endif
.if defined(WITH_OPTIMIZED_CFLAGS)
-CFLAGS+= -O3 -funroll-loops
+CFLAGS+= -O3 -funroll-loops
.endif
.if defined(WITH_DEBUG)
@@ -62,18 +67,20 @@
.if !defined(WITHOUT_SSL)
USE_OPENSSL= yes
-CONFIGURE_ARGS+= "--with-openssl=${OPENSSLBASE}"
+CONFIGURE_ARGS+= "--with-openssl=${OPENSSLBASE}"
.endif
.if defined(WITHOUT_SERVER)
PLIST_SUB+= SERVER="@comment "
PKGNAMESUFFIX= -client
PKGMSG= ""
+CONFLICTS= postgresql-7*
.else
PKGMESSAGE= ${FILESDIR}/pkg-message.server
PKGMSG= ${PKGMESSAGE}
+CONFLICTS= postgresql-7*client
PLIST_SUB+= SERVER=""
-INSTALL_TARGET+= install-all-headers
+INSTALL_TARGET+= install-all-headers
MAKEFILE= GNUmakefile
.endif
@@ -92,7 +99,7 @@
.if defined(WITH_KRB5)
CONFIGURE_ARGS+= --with-krb5="`${KRB5CONF} --prefix krb5`"
LDFLAGS+= `${KRB5CONF} --libs krb5`
-CONFIGURE_ENV= LDFLAGS="${LDFLAGS}"
+CONFIGURE_ENV= LDFLAGS="${LDFLAGS}"
.endif
.if defined(WITH_TESTS)
@@ -142,9 +149,10 @@
@${ECHO} " WITHOUT_GETTEXT Skips building with support for"
@${ECHO} " internationalized error messages"
@${ECHO} " WITHOUT_SERVER Don't install the server,"
- @${ECHO} " only install binaries, headers and libs"
+ @${ECHO} " only install binaries, headers and libs"
@${ECHO} " for PostgreSQL clients"
@${ECHO} " WITHOUT_SSL Builds without OpenSSL support"
+ @${ECHO} " WITH_PAM Builds with PAM support"
@${ECHO} " WITH_MIT_KRB5 Builds with MIT's kerberos support"
@${ECHO} " WITH_HEIMDAL_KRB5 Builds with Heimdal's kerberos support"
@${ECHO} " WITH_OPTIMIZED_CFLAGS Builds with compiler optimizations (-O3)"
Index: distinfo
===================================================================
RCS file: /home/ncvs/ports/databases/postgresql7/distinfo,v
retrieving revision 1.29
diff -u -u -r1.29 distinfo
--- distinfo 12 Aug 2003 09:58:13 -0000 1.29
+++ distinfo 18 Nov 2003 00:19:59 -0000
@@ -1,4 +1,4 @@
-MD5 (postgresql/postgresql-base-7.3.4.tar.gz) = 2b8600cc0f0c2d80271b533c394c886b
-MD5 (postgresql/postgresql-opt-7.3.4.tar.gz) = 3a0f0254bf9d6dccc61baa149c68ae75
-MD5 (postgresql/postgresql-docs-7.3.4.tar.gz) = 0144134674614e6b6a54103482f8acb2
-MD5 (postgresql/postgresql-test-7.3.4.tar.gz) = 7734ec70bb8e3d3bb3ba49e6dcee10e5
+MD5 (postgresql/postgresql-base-7.4.tar.bz2) = a1af58384f506ed63c1d960ab43a2b3b
+MD5 (postgresql/postgresql-opt-7.4.tar.bz2) = df425a08172b1e6ca41e7720b65a6b15
+MD5 (postgresql/postgresql-test-7.4.tar.bz2) = 3c104928f6dadb8fa6086b5ae8060835
+MD5 (postgresql/postgresql-docs-7.4.tar.bz2) = b8f1d43dc64b6813b3239f36425c8cb8
Index: pkg-plist
===================================================================
RCS file: /home/ncvs/ports/databases/postgresql7/pkg-plist,v
retrieving revision 1.37
diff -u -u -r1.37 pkg-plist
--- pkg-plist 6 Feb 2003 20:46:51 -0000 1.37
+++ pkg-plist 18 Nov 2003 04:03:27 -0000
@@ -33,21 +33,38 @@
include/postgresql/internal/postgres_fe.h
include/postgresql/internal/pqexpbuffer.h
@dirrm include/postgresql/internal
+include/compatlib.h
+include/datetime.h
+include/decimal.h
+include/ecpg_informix.h
include/ecpgerrno.h
include/ecpglib.h
include/ecpgtype.h
include/libpq-fe.h
include/pg_config.h
include/pg_config_os.h
+include/pgtypes_date.h
+include/pgtypes_error.h
+include/pgtypes_interval.h
+include/pgtypes_numeric.h
+include/pgtypes_timestamp.h
include/postgres_ext.h
include/sql3types.h
include/sqlca.h
+include/sqlda.h
+include/sqltypes.h
lib/libecpg.a
lib/libecpg.so
-lib/libecpg.so.3
+lib/libecpg.so.4
+lib/libecpg_compat.a
+lib/libecpg_compat.so
+lib/libecpg_compat.so.1
lib/libpq.a
lib/libpq.so
lib/libpq.so.3
+lib/libpgtypes.a
+lib/libpgtypes.so
+lib/libpgtypes.so.1
%%SERVER%%lib/postgresql/ascii_and_mic.so
%%SERVER%%lib/postgresql/cyrillic_and_mic.so
%%SERVER%%lib/postgresql/euc_cn_and_mic.so
@@ -77,57 +94,93 @@
%%SERVER%%lib/postgresql/plpgsql.so
@unexec rmdir %D/lib/postgresql 2>/dev/null || true
%%SERVER%%share/postgresql/502.pgsql
-%%SERVER%%share/postgresql/postgres.bki
-%%SERVER%%share/postgresql/postgres.description
+%%SERVER%%share/postgresql/conversion_create.sql
+%%SERVER%%share/postgresql/information_schema.sql
%%SERVER%%share/postgresql/pg_hba.conf.sample
%%SERVER%%share/postgresql/pg_ident.conf.sample
+%%SERVER%%share/postgresql/pg_service.conf.sample
+%%SERVER%%share/postgresql/postgres.bki
+%%SERVER%%share/postgresql/postgres.description
%%SERVER%%share/postgresql/postgresql.conf.sample
-%%SERVER%%share/postgresql/conversion_create.sql
+%%SERVER%%share/postgresql/sql_features.txt
share/postgresql/post-install-notes
@unexec rmdir %D/share/postgresql 2>/dev/null || true
+%%GETTEXT%%share/locale/cs/LC_MESSAGES/libpq.mo
+%%GETTEXT%%share/locale/cs/LC_MESSAGES/pg_controldata.mo
%%GETTEXT%%share/locale/cs/LC_MESSAGES/pg_dump.mo
+%%GETTEXT%%share/locale/cs/LC_MESSAGES/pg_resetxlog.mo
+%%GETTEXT%%share/locale/cs/LC_MESSAGES/pgscripts.mo
%%GETTEXT%%share/locale/cs/LC_MESSAGES/psql.mo
-%%GETTEXT%%share/locale/cs/LC_MESSAGES/libpq.mo
%%GETTEXT%%share/locale/de/LC_MESSAGES/pg_dump.mo
%%GETTEXT%%share/locale/de/LC_MESSAGES/psql.mo
%%GETTEXT%%share/locale/de/LC_MESSAGES/pg_controldata.mo
%%GETTEXT%%share/locale/de/LC_MESSAGES/pg_resetxlog.mo
%%GETTEXT%%share/locale/de/LC_MESSAGES/libpq.mo
-%%GETTEXT%%share/locale/pt_BR/LC_MESSAGES/pg_dump.mo
+%%GETTEXT%%share/locale/de/LC_MESSAGES/pgscripts.mo
+%%GETTEXT%%share/locale/es/LC_MESSAGES/libpq.mo
+%%GETTEXT%%share/locale/es/LC_MESSAGES/pg_controldata.mo
+%%GETTEXT%%share/locale/es/LC_MESSAGES/pg_dump.mo
+%%GETTEXT%%share/locale/es/LC_MESSAGES/pg_resetxlog.mo
+%%GETTEXT%%share/locale/es/LC_MESSAGES/pgscripts.mo
+%%GETTEXT%%share/locale/es/LC_MESSAGES/psql.mo
+%%GETTEXT%%share/locale/fr/LC_MESSAGES/psql.mo
+%%GETTEXT%%share/locale/fr/LC_MESSAGES/pg_controldata.mo
+%%GETTEXT%%share/locale/fr/LC_MESSAGES/libpq.mo
+%%GETTEXT%%share/locale/hr/LC_MESSAGES/libpq.mo
+%%GETTEXT%%share/locale/hu/LC_MESSAGES/psql.mo
+%%GETTEXT%%share/locale/hu/LC_MESSAGES/pg_controldata.mo
+%%GETTEXT%%share/locale/hu/LC_MESSAGES/pg_resetxlog.mo
+%%GETTEXT%%share/locale/it/LC_MESSAGES/libpq.mo
+%%GETTEXT%%share/locale/it/LC_MESSAGES/pg_controldata.mo
+%%GETTEXT%%share/locale/it/LC_MESSAGES/pg_dump.mo
+%%GETTEXT%%share/locale/it/LC_MESSAGES/pg_resetxlog.mo
+%%GETTEXT%%share/locale/it/LC_MESSAGES/pgscripts.mo
+%%GETTEXT%%share/locale/it/LC_MESSAGES/psql.mo
+%%GETTEXT%%share/locale/nb/LC_MESSAGES/libpq.mo
+%%GETTEXT%%share/locale/nb/LC_MESSAGES/pg_controldata.mo
+%%GETTEXT%%share/locale/nb/LC_MESSAGES/pg_dump.mo
+%%GETTEXT%%share/locale/nb/LC_MESSAGES/pg_resetxlog.mo
+%%GETTEXT%%share/locale/nb/LC_MESSAGES/psql.mo
+%%GETTEXT%%share/locale/pt_BR/LC_MESSAGES/libpq.mo
%%GETTEXT%%share/locale/pt_BR/LC_MESSAGES/pg_controldata.mo
+%%GETTEXT%%share/locale/pt_BR/LC_MESSAGES/pg_dump.mo
%%GETTEXT%%share/locale/pt_BR/LC_MESSAGES/pg_resetxlog.mo
-%%GETTEXT%%share/locale/pt_BR/LC_MESSAGES/libpq.mo
-%%GETTEXT%%share/locale/ru/LC_MESSAGES/pg_dump.mo
-%%GETTEXT%%share/locale/ru/LC_MESSAGES/psql.mo
+%%GETTEXT%%share/locale/pt_BR/LC_MESSAGES/pgscripts.mo
+%%GETTEXT%%share/locale/pt_BR/LC_MESSAGES/psql.mo
+%%GETTEXT%%share/locale/ru/LC_MESSAGES/libpq.mo
%%GETTEXT%%share/locale/ru/LC_MESSAGES/pg_controldata.mo
+%%GETTEXT%%share/locale/ru/LC_MESSAGES/pg_dump.mo
%%GETTEXT%%share/locale/ru/LC_MESSAGES/pg_resetxlog.mo
-%%GETTEXT%%share/locale/ru/LC_MESSAGES/libpq.mo
-%%GETTEXT%%share/locale/sv/LC_MESSAGES/pg_dump.mo
-%%GETTEXT%%share/locale/sv/LC_MESSAGES/psql.mo
+%%GETTEXT%%share/locale/ru/LC_MESSAGES/pgscripts.mo
+%%GETTEXT%%share/locale/ru/LC_MESSAGES/psql.mo
+%%GETTEXT%%share/locale/sl/LC_MESSAGES/libpq.mo
+%%GETTEXT%%share/locale/sl/LC_MESSAGES/pg_controldata.mo
+%%GETTEXT%%share/locale/sl/LC_MESSAGES/pg_resetxlog.mo
+%%GETTEXT%%share/locale/sl/LC_MESSAGES/pgscripts.mo
+%%GETTEXT%%share/locale/sl/LC_MESSAGES/psql.mo
+%%GETTEXT%%share/locale/sv/LC_MESSAGES/libpq.mo
%%GETTEXT%%share/locale/sv/LC_MESSAGES/pg_controldata.mo
+%%GETTEXT%%share/locale/sv/LC_MESSAGES/pg_dump.mo
%%GETTEXT%%share/locale/sv/LC_MESSAGES/pg_resetxlog.mo
-%%GETTEXT%%share/locale/sv/LC_MESSAGES/libpq.mo
-%%GETTEXT%%share/locale/zh_CN/LC_MESSAGES/pg_dump.mo
-%%GETTEXT%%share/locale/zh_CN/LC_MESSAGES/psql.mo
+%%GETTEXT%%share/locale/sv/LC_MESSAGES/pgscripts.mo
+%%GETTEXT%%share/locale/sv/LC_MESSAGES/psql.mo
+%%GETTEXT%%share/locale/zh_CN/LC_MESSAGES/libpq.mo
%%GETTEXT%%share/locale/zh_CN/LC_MESSAGES/pg_controldata.mo
+%%GETTEXT%%share/locale/zh_CN/LC_MESSAGES/pg_dump.mo
%%GETTEXT%%share/locale/zh_CN/LC_MESSAGES/pg_resetxlog.mo
-%%GETTEXT%%share/locale/zh_CN/LC_MESSAGES/libpq.mo
+%%GETTEXT%%share/locale/zh_CN/LC_MESSAGES/pgscripts.mo
+%%GETTEXT%%share/locale/zh_CN/LC_MESSAGES/psql.mo
+%%GETTEXT%%share/locale/zh_TW/LC_MESSAGES/libpq.mo
%%GETTEXT%%share/locale/zh_TW/LC_MESSAGES/pg_dump.mo
%%GETTEXT%%share/locale/zh_TW/LC_MESSAGES/psql.mo
-%%GETTEXT%%share/locale/zh_TW/LC_MESSAGES/libpq.mo
-%%GETTEXT%%share/locale/fr/LC_MESSAGES/psql.mo
-%%GETTEXT%%share/locale/fr/LC_MESSAGES/pg_controldata.mo
-%%GETTEXT%%share/locale/fr/LC_MESSAGES/libpq.mo
-%%GETTEXT%%share/locale/hu/LC_MESSAGES/psql.mo
-%%GETTEXT%%share/locale/hu/LC_MESSAGES/pg_controldata.mo
-%%GETTEXT%%share/locale/hu/LC_MESSAGES/pg_resetxlog.mo
-%%GETTEXT%%share/locale/es/LC_MESSAGES/pg_controldata.mo
-%%GETTEXT%%share/locale/es/LC_MESSAGES/libpq.mo
%%SERVER%%%%GETTEXT%%share/locale/cs/LC_MESSAGES/postgres.mo
%%SERVER%%%%GETTEXT%%share/locale/de/LC_MESSAGES/postgres.mo
%%SERVER%%%%GETTEXT%%share/locale/es/LC_MESSAGES/postgres.mo
%%SERVER%%%%GETTEXT%%share/locale/hr/LC_MESSAGES/postgres.mo
%%SERVER%%%%GETTEXT%%share/locale/hu/LC_MESSAGES/postgres.mo
+%%SERVER%%%%GETTEXT%%share/locale/it/LC_MESSAGES/postgres.mo
+%%SERVER%%%%GETTEXT%%share/locale/nb/LC_MESSAGES/postgres.mo
+%%SERVER%%%%GETTEXT%%share/locale/pt_BR/LC_MESSAGES/postgres.mo
%%SERVER%%%%GETTEXT%%share/locale/ru/LC_MESSAGES/postgres.mo
%%SERVER%%%%GETTEXT%%share/locale/sv/LC_MESSAGES/postgres.mo
%%SERVER%%%%GETTEXT%%share/locale/tr/LC_MESSAGES/postgres.mo
@@ -173,6 +226,7 @@
%%SERVER%%include/postgresql/server/access/rtscan.h
%%SERVER%%include/postgresql/server/access/sdir.h
%%SERVER%%include/postgresql/server/access/skey.h
+%%SERVER%%include/postgresql/server/access/slru.h
%%SERVER%%include/postgresql/server/access/strat.h
%%SERVER%%include/postgresql/server/access/transam.h
%%SERVER%%include/postgresql/server/access/tupdesc.h
@@ -222,6 +276,7 @@
%%SERVER%%include/postgresql/server/catalog/pg_trigger.h
%%SERVER%%include/postgresql/server/catalog/pg_type.h
%%SERVER%%include/postgresql/server/catalog/pg_version.h
+%%SERVER%%include/postgresql/server/commands/alter.h
%%SERVER%%include/postgresql/server/commands/async.h
%%SERVER%%include/postgresql/server/commands/cluster.h
%%SERVER%%include/postgresql/server/commands/comment.h
@@ -238,6 +293,7 @@
%%SERVER%%include/postgresql/server/commands/sequence.h
%%SERVER%%include/postgresql/server/commands/tablecmds.h
%%SERVER%%include/postgresql/server/commands/trigger.h
+%%SERVER%%include/postgresql/server/commands/typecmds.h
%%SERVER%%include/postgresql/server/commands/user.h
%%SERVER%%include/postgresql/server/commands/vacuum.h
%%SERVER%%include/postgresql/server/commands/variable.h
@@ -271,6 +327,7 @@
%%SERVER%%include/postgresql/server/executor/nodeUnique.h
%%SERVER%%include/postgresql/server/executor/spi.h
%%SERVER%%include/postgresql/server/executor/spi_priv.h
+%%SERVER%%include/postgresql/server/executor/tstoreReceiver.h
%%SERVER%%include/postgresql/server/executor/tuptable.h
%%SERVER%%include/postgresql/server/lib/dllist.h
%%SERVER%%include/postgresql/server/lib/lispsort.h
@@ -279,14 +336,15 @@
%%SERVER%%include/postgresql/server/libpq/be-fsstubs.h
%%SERVER%%include/postgresql/server/libpq/crypt.h
%%SERVER%%include/postgresql/server/libpq/hba.h
+%%SERVER%%include/postgresql/server/libpq/ip.h
%%SERVER%%include/postgresql/server/libpq/libpq-be.h
%%SERVER%%include/postgresql/server/libpq/libpq-fs.h
%%SERVER%%include/postgresql/server/libpq/libpq.h
-%%SERVER%%include/postgresql/server/libpq/password.h
%%SERVER%%include/postgresql/server/libpq/pqcomm.h
%%SERVER%%include/postgresql/server/libpq/pqformat.h
%%SERVER%%include/postgresql/server/libpq/pqsignal.h
%%SERVER%%include/postgresql/server/mb/pg_wchar.h
+%%SERVER%%include/postgresql/server/nodes/bitmapset.h
%%SERVER%%include/postgresql/server/nodes/execnodes.h
%%SERVER%%include/postgresql/server/nodes/makefuncs.h
%%SERVER%%include/postgresql/server/nodes/memnodes.h
@@ -342,6 +400,7 @@
%%SERVER%%include/postgresql/server/port/aix.h
%%SERVER%%include/postgresql/server/port/beos.h
%%SERVER%%include/postgresql/server/port/bsdi.h
+%%SERVER%%include/postgresql/server/port/cygwin.h
%%SERVER%%include/postgresql/server/port/darwin.h
%%SERVER%%include/postgresql/server/port/dgux.h
%%SERVER%%include/postgresql/server/port/freebsd.h
@@ -360,13 +419,11 @@
%%SERVER%%include/postgresql/server/port/ultrix4.h
%%SERVER%%include/postgresql/server/port/univel.h
%%SERVER%%include/postgresql/server/port/unixware.h
-%%SERVER%%include/postgresql/server/port/win.h
%%SERVER%%include/postgresql/server/port/win32.h
-%%SERVER%%include/postgresql/server/regex/cclass.h
-%%SERVER%%include/postgresql/server/regex/cname.h
+%%SERVER%%include/postgresql/server/regex/regcustom.h
+%%SERVER%%include/postgresql/server/regex/regerrs.h
%%SERVER%%include/postgresql/server/regex/regex.h
-%%SERVER%%include/postgresql/server/regex/regex2.h
-%%SERVER%%include/postgresql/server/regex/utils.h
+%%SERVER%%include/postgresql/server/regex/regguts.h
%%SERVER%%include/postgresql/server/rewrite/prs2lock.h
%%SERVER%%include/postgresql/server/rewrite/rewriteDefine.h
%%SERVER%%include/postgresql/server/rewrite/rewriteHandler.h
@@ -392,7 +449,6 @@
%%SERVER%%include/postgresql/server/storage/lock.h
%%SERVER%%include/postgresql/server/storage/lwlock.h
%%SERVER%%include/postgresql/server/storage/off.h
-%%SERVER%%include/postgresql/server/storage/page.h
%%SERVER%%include/postgresql/server/storage/pg_sema.h
%%SERVER%%include/postgresql/server/storage/pg_shmem.h
%%SERVER%%include/postgresql/server/storage/pmsignal.h
@@ -414,7 +470,6 @@
%%SERVER%%include/postgresql/server/utils/acl.h
%%SERVER%%include/postgresql/server/utils/array.h
%%SERVER%%include/postgresql/server/utils/ascii.h
-%%SERVER%%include/postgresql/server/utils/bit.h
%%SERVER%%include/postgresql/server/utils/builtins.h
%%SERVER%%include/postgresql/server/utils/cash.h
%%SERVER%%include/postgresql/server/utils/catcache.h
@@ -424,13 +479,15 @@
%%SERVER%%include/postgresql/server/utils/dynahash.h
%%SERVER%%include/postgresql/server/utils/dynamic_loader.h
%%SERVER%%include/postgresql/server/utils/elog.h
-%%SERVER%%include/postgresql/server/utils/fcache.h
+%%SERVER%%include/postgresql/server/utils/errcodes.h
%%SERVER%%include/postgresql/server/utils/fmgroids.h
%%SERVER%%include/postgresql/server/utils/fmgrtab.h
%%SERVER%%include/postgresql/server/utils/formatting.h
%%SERVER%%include/postgresql/server/utils/geo_decls.h
%%SERVER%%include/postgresql/server/utils/guc.h
+%%SERVER%%include/postgresql/server/utils/guc_tables.h
%%SERVER%%include/postgresql/server/utils/hsearch.h
+%%SERVER%%include/postgresql/server/utils/help_config.h
%%SERVER%%include/postgresql/server/utils/inet.h
%%SERVER%%include/postgresql/server/utils/int8.h
%%SERVER%%include/postgresql/server/utils/inval.h
@@ -454,15 +511,20 @@
%%SERVER%%include/postgresql/server/utils/tqual.h
%%SERVER%%include/postgresql/server/utils/tuplesort.h
%%SERVER%%include/postgresql/server/utils/tuplestore.h
+%%SERVER%%include/postgresql/server/utils/typcache.h
%%SERVER%%include/postgresql/server/utils/varbit.h
-%%SERVER%%include/postgresql/server/pg_config.h
-%%SERVER%%include/postgresql/server/pg_config_os.h
%%SERVER%%include/postgresql/server/c.h
%%SERVER%%include/postgresql/server/dynloader.h
%%SERVER%%include/postgresql/server/fmgr.h
%%SERVER%%include/postgresql/server/funcapi.h
+%%SERVER%%include/postgresql/server/getaddrinfo.h
+%%SERVER%%include/postgresql/server/getopt_long.h
%%SERVER%%include/postgresql/server/miscadmin.h
+%%SERVER%%include/postgresql/server/pg_config.h
+%%SERVER%%include/postgresql/server/pg_config_manual.h
+%%SERVER%%include/postgresql/server/pg_config_os.h
%%SERVER%%include/postgresql/server/pgstat.h
+%%SERVER%%include/postgresql/server/port.h
%%SERVER%%include/postgresql/server/postgres.h
%%SERVER%%include/postgresql/server/postgres_ext.h
%%SERVER%%include/postgresql/server/postgres_fe.h
Index: files/pgsql.sh.tmpl
===================================================================
RCS file: /home/ncvs/ports/databases/postgresql7/files/pgsql.sh.tmpl,v
retrieving revision 1.15
diff -u -u -r1.15 pgsql.sh.tmpl
--- files/pgsql.sh.tmpl 11 Jun 2003 23:25:24 -0000 1.15
+++ files/pgsql.sh.tmpl 4 Nov 2003 22:30:02 -0000
@@ -9,30 +9,32 @@
PREFIX=%%PREFIX%%
PGBIN=${PREFIX}/bin
-logfile=/var/log/pgsql
case $1 in
start)
- touch ${logfile}
- chmod 600 ${logfile}
- chown pgsql:pgsql ${logfile}
[ -x ${PGBIN}/pg_ctl ] && {
- su -l pgsql -c \
- "[ -d \${PGDATA} ] && exec ${PREFIX}/bin/pg_ctl start -s -w -l ${logfile}"
echo -n ' pgsql'
+ su -l pgsql -c \
+ "[ -d \${PGDATA} ] && exec ${PREFIX}/bin/pg_ctl start -s -w"
}
;;
stop)
[ -x ${PGBIN}/pg_ctl ] && {
- su -l pgsql -c "exec ${PREFIX}/bin/pg_ctl stop -s -m fast"
echo -n ' pgsql'
+ su -l pgsql -c "exec ${PREFIX}/bin/pg_ctl stop -s -m fast"
}
;;
restart)
[ -x ${PGBIN}/pg_ctl ] && {
- exec su -l pgsql -c "exec ${PREFIX}/bin/pg_ctl restart -s -m fast -l ${logfile}"
+ exec su -l pgsql -c "exec ${PREFIX}/bin/pg_ctl restart -s -m fast"
+ }
+ ;;
+
+reload)
+ [ -x ${PGBIN}/pg_ctl ] && {
+ exec su -l pgsql -c "exec ${PREFIX}/bin/pg_ctl reload"
}
;;
@@ -43,7 +45,7 @@
;;
*)
- echo "usage: `basename $0` {start|stop|restart|status}" >&2
+ echo "usage: `basename $0` {start|stop|restart|reload|status}" >&2
exit 64
;;
esac
Index: files/pkg-message.server
===================================================================
RCS file: /home/ncvs/ports/databases/postgresql7/files/pkg-message.server,v
retrieving revision 1.1
diff -u -u -r1.1 pkg-message.server
--- files/pkg-message.server 12 Aug 2003 14:00:35 -0000 1.1
+++ files/pkg-message.server 18 Nov 2003 04:22:05 -0000
@@ -13,5 +13,9 @@
/usr/local/etc/rc.d/010.pgsql.sh start
For postmaster settings, see ~pgsql/data/postgresql.conf
+
+NB. FreeBSD's PostgreSQL port now by default logs to syslog
+ See ~pgsql/data/postgresql.conf for more info
+
For more tips, read ~pgsql/post-install-notes
======================================================================
--- /dev/null Tue Nov 18 05:25:50 2003
+++ files/patch-src:backend:utils:misc:postgresql.conf.sample Tue Nov 18 05:09:23 2003
@@ -0,0 +1,24 @@
+--- src/backend/utils/misc/postgresql.conf.sample~ Wed Oct 8 05:49:38 2003
++++ src/backend/utils/misc/postgresql.conf.sample Tue Nov 18 05:08:08 2003
+@@ -136,9 +136,9 @@
+
+ # - Syslog -
+
+-#syslog = 0 # range 0-2; 0=stdout; 1=both; 2=syslog
+-#syslog_facility = 'LOCAL0'
+-#syslog_ident = 'postgres'
++syslog = 2 # range 0-2; 0=stdout; 1=both; 2=syslog
++syslog_facility = 'LOCAL0'
++syslog_ident = 'postgres'
+
+ # - When to Log -
+
+@@ -162,7 +162,7 @@
+ # milliseconds. Zero prints all queries.
+ # Minus-one disables.
+
+-#silent_mode = false # DO NOT USE without Syslog!
++silent_mode = true # DO NOT USE without Syslog!
+
+ # - What to Log -
+
--- postgresql-7.4.patch ends here ---
>Release-Note:
>Audit-Trail:
>Unformatted:
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?200311180431.hAI4VLbJ040204>