databases/postgresql7 dump + restore didn't include pgcrypto functions

Palle Girgensohn girgen at pingpong.net
Sat Jan 31 08:14:52 PST 2004


--On lördag, januari 31, 2004 10.52.53 -0500 Dan Langille 
<dan at langille.org> wrote:

> On 31 Jan 2004 at 16:44, Palle Girgensohn wrote:
>
>> --On lördag, januari 31, 2004 08.14.59 -0500 Dan Langille
>> <dan at 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
===================================================================
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



More information about the freebsd-ports mailing list