databases/postgresql7 dump + restore didn't include pgcrypto
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
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.
+ Lots of contributed utilities, postgresql functions and
+ datatypes. There you find autovacuum, pgcrypto and many other cool
-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