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 --- databases/postgresql7/files/pkg-message.server | 16 ++++++++++++++++ databases/postgresql7/files/post-install-notes | 3 +-- 2 files changed, 17 insertions(+), 2 deletions(-) (limited to 'databases/postgresql7/files') diff --git a/databases/postgresql7/files/pkg-message.server b/databases/postgresql7/files/pkg-message.server index a2e7293462ca..69826681eb42 100644 --- a/databases/postgresql7/files/pkg-message.server +++ b/databases/postgresql7/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) diff --git a/databases/postgresql7/files/post-install-notes b/databases/postgresql7/files/post-install-notes index 037eec446deb..0fb0604214b8 100644 --- a/databases/postgresql7/files/post-install-notes +++ b/databases/postgresql7/files/post-install-notes @@ -7,8 +7,7 @@ p5-Pg A perl5 API for client access to PostgreSQL databases. postgresql-tcltk - If you want tcl/tk client support. You get a neat GUI, pgaccess, as - a bonus! + If you want tcl/tk client support. postgresql-jdbc For Java JDBC support. -- cgit v1.2.3