From owner-freebsd-ports-bugs@FreeBSD.ORG Mon Nov 17 20:40:23 2003 Return-Path: Delivered-To: freebsd-ports-bugs@hub.freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 93DE616A4CE for ; Mon, 17 Nov 2003 20:40:23 -0800 (PST) Received: from freefall.freebsd.org (freefall.freebsd.org [216.136.204.21]) by mx1.FreeBSD.org (Postfix) with ESMTP id 77CC843FDD for ; Mon, 17 Nov 2003 20:40:16 -0800 (PST) (envelope-from gnats@FreeBSD.org) Received: from freefall.freebsd.org (gnats@localhost [127.0.0.1]) by freefall.freebsd.org (8.12.9/8.12.9) with ESMTP id hAI4eGFY093358 for ; Mon, 17 Nov 2003 20:40:16 -0800 (PST) (envelope-from gnats@freefall.freebsd.org) Received: (from gnats@localhost) by freefall.freebsd.org (8.12.9/8.12.9/Submit) id hAI4eGrG093357; Mon, 17 Nov 2003 20:40:16 -0800 (PST) (envelope-from gnats) Resent-Date: Mon, 17 Nov 2003 20:40:16 -0800 (PST) Resent-Message-Id: <200311180440.hAI4eGrG093357@freefall.freebsd.org> Resent-From: FreeBSD-gnats-submit@FreeBSD.org (GNATS Filer) Resent-To: freebsd-ports-bugs@FreeBSD.org Resent-Reply-To: FreeBSD-gnats-submit@FreeBSD.org, Palle Girgensohn Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id BDD7D16A4CE for ; Mon, 17 Nov 2003 20:31:26 -0800 (PST) Received: from amsfep11-int.chello.nl (amsfep11-int.chello.nl [213.46.243.20]) by mx1.FreeBSD.org (Postfix) with ESMTP id 4C9CE43FDD for ; Mon, 17 Nov 2003 20:31:23 -0800 (PST) (envelope-from girgen@smtp.chello.se) Received: from palle.girgensohn.se ([213.89.138.245]) by amsfep11-int.chello.nlESMTP <20031118043122.IYLK1413.amsfep11-int.chello.nl@palle.girgensohn.se>; Tue, 18 Nov 2003 05:31:22 +0100 Received: from palle.girgensohn.se (localhost [127.0.0.1]) by palle.girgensohn.se (8.12.9p2/8.12.9) with ESMTP id hAI4VLK3040205; Tue, 18 Nov 2003 05:31:21 +0100 (CET) (envelope-from girgen@palle.girgensohn.se) Received: (from girgen@localhost) by palle.girgensohn.se (8.12.9p2/8.12.9/Submit) id hAI4VLbJ040204; Tue, 18 Nov 2003 05:31:21 +0100 (CET) (envelope-from girgen) Message-Id: <200311180431.hAI4VLbJ040204@palle.girgensohn.se> Date: Tue, 18 Nov 2003 05:31:21 +0100 (CET) From: Palle Girgensohn To: FreeBSD-gnats-submit@FreeBSD.org X-Send-Pr-Version: 3.113 Subject: ports/59402: [MAINTAINER] databases/postgresql: update to 7.4 X-BeenThere: freebsd-ports-bugs@freebsd.org X-Mailman-Version: 2.1.1 Precedence: list List-Id: Ports bug reports List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Tue, 18 Nov 2003 04:40:23 -0000 >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: