From b919b91069c1ba6836d4dff773524b7963f1a185 Mon Sep 17 00:00:00 2001 From: Sean Chittenden Date: Thu, 25 Dec 2003 10:55:39 +0000 Subject: Maintainer update to PostgreSQL 7.4.1. This release includes fixed ident authentication support for FreeBSD (been broken since 7.4). Merry Christmas to all, and to all a good night. Release notes: http://developer.postgresql.org/docs/postgres/release.html#RELEASE-7-4-1 Prompted by PR: ports/60542 Obtained from: maintainer --- .../postgresql-devel-server/files/pkg-message.server | 16 ++++++++++++++++ 1 file changed, 16 insertions(+) (limited to 'databases/postgresql-devel-server/files/pkg-message.server') diff --git a/databases/postgresql-devel-server/files/pkg-message.server b/databases/postgresql-devel-server/files/pkg-message.server index a2e7293462ca..69826681eb42 100644 --- a/databases/postgresql-devel-server/files/pkg-message.server +++ b/databases/postgresql-devel-server/files/pkg-message.server @@ -19,3 +19,19 @@ NB. FreeBSD's PostgreSQL port now by default logs to syslog For more tips, read ~pgsql/post-install-notes ====================================================================== +Specific for the 7.4.1 update: + + A dump/restore is *not* required for those running 7.4. + + If you want to install the fixes in the information schema you need to + reload it into the database. This is either accomplished by + initializing a new cluster by running "initdb", or by running the + following sequence of SQL commands in each database (ideally including + template1) as a superuser in psql, after installing the new release: +DROP SCHEMA information_schema CASCADE; +\i /usr/local/pgsql/share/information_schema.sql + + Fixes to the information schema (from HISTORY): + * Fix information schema for bit data types (Peter) + * Fix information schema view constraint_column_usage for foreign + keys (Peter) -- cgit v1.2.3