From owner-freebsd-ports-bugs@FreeBSD.ORG Sat Jan 31 08:40:23 2004 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 CBD5A16A4CE for ; Sat, 31 Jan 2004 08:40:23 -0800 (PST) Received: from freefall.freebsd.org (freefall.freebsd.org [216.136.204.21]) by mx1.FreeBSD.org (Postfix) with ESMTP id 7C6CD43D5A for ; Sat, 31 Jan 2004 08:40:20 -0800 (PST) (envelope-from gnats@FreeBSD.org) Received: from freefall.freebsd.org (gnats@localhost [127.0.0.1]) i0VGeKFR022006 for ; Sat, 31 Jan 2004 08:40:20 -0800 (PST) (envelope-from gnats@freefall.freebsd.org) Received: (from gnats@localhost) by freefall.freebsd.org (8.12.10/8.12.10/Submit) id i0VGeKsX022005; Sat, 31 Jan 2004 08:40:20 -0800 (PST) (envelope-from gnats) Resent-Date: Sat, 31 Jan 2004 08:40:20 -0800 (PST) Resent-Message-Id: <200401311640.i0VGeKsX022005@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 CD5F616A4CE for ; Sat, 31 Jan 2004 08:37:59 -0800 (PST) Received: from amsfep19-int.chello.nl (amsfep19-int.chello.nl [213.46.243.20]) by mx1.FreeBSD.org (Postfix) with ESMTP id 4473E43D1D for ; Sat, 31 Jan 2004 08:37:54 -0800 (PST) (envelope-from girgen@smtp.chello.se) Received: from palle.girgensohn.se ([213.89.137.38]) by amsfep19-int.chello.nlESMTP <20040131163752.TZEU1965.amsfep19-int.chello.nl@palle.girgensohn.se> for ; Sat, 31 Jan 2004 17:37:52 +0100 Received: from palle.girgensohn.se (localhost [127.0.0.1]) by palle.girgensohn.se (8.12.9p2/8.12.9) with ESMTP id i0VGbqQY096304 for ; Sat, 31 Jan 2004 17:37:52 +0100 (CET) (envelope-from girgen@palle.girgensohn.se) Received: (from girgen@localhost) by palle.girgensohn.se (8.12.9p2/8.12.9/Submit) id i0VGbpqR096303; Sat, 31 Jan 2004 17:37:51 +0100 (CET) (envelope-from girgen) Message-Id: <200401311637.i0VGbpqR096303@palle.girgensohn.se> Date: Sat, 31 Jan 2004 17:37:51 +0100 (CET) From: Palle Girgensohn To: FreeBSD-gnats-submit@FreeBSD.org X-Send-Pr-Version: 3.113 Subject: ports/62167: [MAINTAINER] databases/postgresql: add upgrade note 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: Sat, 31 Jan 2004 16:40:24 -0000 >Number: 62167 >Category: ports >Synopsis: [MAINTAINER] databases/postgresql: add upgrade note >Confidential: no >Severity: non-critical >Priority: low >Responsible: freebsd-ports-bugs >State: open >Quarter: >Keywords: >Date-Required: >Class: maintainer-update >Submitter-Id: current-users >Arrival-Date: Sat Jan 31 08:40:20 PST 2004 >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: The function "elog" has been removed from pg-7.4, so contrib functions must be updated when updating the postgres binary. This patch adds a note about that. Also, it's been a while since the postgresql layout shift, no reason to inform about it anymore. Generated with FreeBSD Port Tools 0.50 >How-To-Repeat: >Fix: --- postgresql-7.4.1.patch begins here --- Index: files/post-install-notes =================================================================== RCS file: /home/ncvs/ports/databases/postgresql7/files/post-install-notes,v retrieving revision 1.18 diff -u -u -r1.18 post-install-notes --- files/post-install-notes 25 Dec 2003 10:55:39 -0000 1.18 +++ files/post-install-notes 31 Jan 2004 16:13:26 -0000 @@ -24,11 +24,17 @@ p5-postgresql-plperl, postgresql-pltcl & postgresql-plruby For using perl5, tcl & ruby as procedural languages. +postgresql-contrib + Lots of contributed utilities, postgresql functions and + datatypes. There you find autovacuum, pgcrypto and many other cool + things. + etc etc... -Note that many files have moved around compared to previous versions -of PostgreSQL. For example, plpgsql.so and all other language modules -are now in /usr/local/lib/postgresql. +For procedural languages and postgresql functions, please note that +you might have to update them when updating the server. For example, +the "elog" method disappeared in postgresql-7.4, so postgresql-contrib +must be updated along with the server. If you have many tables and many clients running, consider raising kern.maxfiles using sysctl(8), or reconfigure your kernel --- postgresql-7.4.1.patch ends here --- >Release-Note: >Audit-Trail: >Unformatted: