Date: Sat, 31 Jan 2004 17:37:51 +0100 (CET) From: Palle Girgensohn <girgen@pingpong.net> To: FreeBSD-gnats-submit@FreeBSD.org Subject: ports/62167: [MAINTAINER] databases/postgresql: add upgrade note Message-ID: <200401311637.i0VGbpqR096303@palle.girgensohn.se> Resent-Message-ID: <200401311640.i0VGeKsX022005@freefall.freebsd.org>
next in thread | raw e-mail | index | archive | help
>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:
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?200401311637.i0VGbpqR096303>