Date: Sat, 31 Jan 2004 17:14:25 +0100 From: Palle Girgensohn <girgen@pingpong.net> To: Dan Langille <dan@langille.org> Cc: ports@freebsd.org Subject: Re: databases/postgresql7 dump + restore didn't include pgcrypto functions Message-ID: <44550000.1075565665@palle.girgensohn.se> In-Reply-To: <401B8905.6936.1A6A3212@localhost> References: <401B6403.8589.19D9A1B3@localhost> <401B8905.6936.1A6A3212@localhost>
next in thread | previous in thread | raw e-mail | index | archive | help
--On l=F6rdag, januari 31, 2004 10.52.53 -0500 Dan Langille=20 <dan@langille.org> wrote: > On 31 Jan 2004 at 16:44, Palle Girgensohn wrote: > >> --On l=F6rdag, januari 31, 2004 08.14.59 -0500 Dan Langille >> <dan@langille.org> wrote: >> >> > On 31 Jan 2004 at 5:06, Palle Girgensohn wrote: >> > >> >> If I'm not wrong, this means that postgresql functions, at least = those >> >> programmed in C and using elog, must be rebuilt when updating the >> >> server 7.3 -> 7.4. >> > >> > Yes. This is confirmed by http://archives.postgresql.org/pgsql- >> > general/2003-10/msg00667.php >> >> Cool. An echo in the Makefile would end up in the postgresql-contrib >> makefile IMO, but would not have helped you, since you didn't use the >> port. If one does use the port, chances are pretty high that all pg >> ports will be updated together. I'm not sure an echo will do much good >> - too much information makes ppl stop reading... The postgresql7 port >> is already overloaded with echoes. > > This issue is not mentioned anywhere [that I could find] in the > PostgreSQL HISTORY or INSTALL files. It is recorded many times in > the archives, but that's not the place to put things such as this. > > The issue only arises is upgrading from PG < 7.4. Sorry, no more > ideas here. > -- > Dan Langille : http://www.langille.org/ > BSDCan - http://www.bsdcan.org/ > How about this? /Palle Index: post-install-notes =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D RCS file: /home/ncvs/ports/databases/postgresql7/files/post-install-notes,v retrieving revision 1.18 diff -u -r1.18 post-install-notes --- post-install-notes 25 Dec 2003 10:55:39 -0000 1.18 +++ 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
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?44550000.1075565665>